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

From Iain
Subject Re: Executing SP in VB6
Date
Msg-id 001601c4aa80$0b157d30$7201a8c0@mst1x5r347kymb
Whole thread Raw
In response to Re: Executing SP in VB6  ("Goulet, Dick" <DGoulet@vicr.com>)
List pgsql-odbc
Hi Yusef,

I just realized that it probably isn't the VB code you wanted to see, but
the pg stored procedure code.

I don't have an example on hand, but presumably all you have to do is return
a ref cursor from you pg procedure and the same VB code that you used for
sql server would work on pg. Maybe...

Anyway, I think that you should check the docs for "refcursor" - maybe
section 37.8 and see if that is what you are looking for.

Regards
Iain
----- Original Message -----
From: Sandro Yaqub Yusuf
To: Goulet, Dick
Cc: pgsql-odbc@postgresql.org
Sent: Tuesday, October 05, 2004 4:24 AM
Subject: Re: [ODBC] Executing SP in VB6


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@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


pgsql-odbc by date:

Previous
From: "Iain"
Date:
Subject: Re: Executing SP in VB6
Next
From: "Scot Loach"
Date:
Subject: change to error result in SQLStatistics