Postgres Pro
Downloads
Home   >   mailing lists

Re: Executing SP in VB6 - Mailing list pgsql-odbc

From Sandro Yaqub Yusuf
Subject Re: Executing SP in VB6
Date
Msg-id 002c01c4aa47$c7438f30$9414a8c0@proservvi.com.br
Whole thread Raw
In response to Re: Executing SP in VB6  ("Goulet, Dick" <DGoulet@vicr.com>)
List pgsql-odbc
Tree view
Hello my friend,
 
That is simple. I work developing programs in Visual Basic using complex Stored Procedures in SQL-SERVER 7/2000.
I want to make STORED PROCEDURES in PostGresQL using Visual Basic 6. I need one example to begin.
 
Thanks,
 
Sandroyy
----- Original Message -----
Sent: Monday, October 04, 2004 4:15 PM
Subject: RE: [ODBC] Executing SP in VB6

May I ask why you want to use a stored procedure?  A simple "Select fullname from users where user = '<value>';" should work just fine.
 

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

 

From: Sandro Yaqub Yusuf [mailto:sandro@proservvi.com.br]
Sent: Monday, October 04, 2004 3:13 PM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] Executing SP in VB6

Hello,
 
Please, I just trying search in all WEB SITES about using STORED PROCEDURES with VISUAL BASIC, but I not found anything about this that can help me.
 
I have a table: USERS with colums IDUSER, USER, PASSWORD, FULLNAME
I need get the colum FULLNAME with parameter USER.
How I do to create and execute a STORED PROCEDURE in VISUAL BASIC 6 to resolve this litle problem ? (please, forgiven my english because I living in BRAZIL and not speak english).
 
Thanks,
 
Sandroyy
 
 

pgsql-odbc by date:

Previous
From: "Goulet, Dick"
Date:
Subject: Re: Executing SP in VB6
Next
From: "Dave Page"
Date:
Subject: Re: New snapshot 08.00.0001 uploaded