Re: Executing SP in VB6

----- Original Message -----

From: Goulet, Dick

To: Sandro Yaqub Yusuf ; pgsql-odbc@postgresql.org

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