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

From Goulet, Dick
Subject Re: Executing SP in VB6
Date
Msg-id 4001DEAF7DF9BD498B58B45051FBEA6501B9D50B@25exch1.vicorpower.vicr.com
Whole thread Raw
In response to Executing SP in VB6  ("Sandro Yaqub Yusuf" <sandro@proservvi.com.br>)
List pgsql-odbc
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: "Greg Campbell"
Date:
Subject: Re: Can't find ODBC driver in the admin list
Next
From: "Sandro Yaqub Yusuf"
Date:
Subject: Re: Executing SP in VB6