Re: 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(at)proservvi(dot)com(dot)br]
Sent: Monday, October 04, 2004 3:13 PM
To: pgsql-odbc(at)postgresql(dot)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