From: | "Sandro Yaqub Yusuf" <sandro(at)proservvi(dot)com(dot)br> |
---|---|
To: | "Goulet, Dick" <DGoulet(at)vicr(dot)com> |
Cc: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Executing SP in VB6 |
Date: | 2004-10-04 19:24:33 |
Message-ID: | 002c01c4aa47$c7438f30$9414a8c0@proservvi.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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 -----
From: Goulet, Dick
To: Sandro Yaqub Yusuf ; pgsql-odbc(at)postgresql(dot)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(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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2004-10-04 19:34:18 | Re: New snapshot 08.00.0001 uploaded |
Previous Message | Goulet, Dick | 2004-10-04 19:15:38 | Re: Executing SP in VB6 |