Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calling stored procedures from OO4O to return dynaset

Status
Not open for further replies.

culshaja

Programmer
Aug 10, 1999
705
GB
I want to permanently declare a stored procedure in the database <br>
that creates a cursor containing data of a specific criteria, <br>
but I don't require passed parameters. The reason is to have <br>
this compiled on the server for performance - I don't wish to <br>
create a view unless I have to as I still have to pass a select <br>
statement to this view. I want to get access to this cursor from <br>
OO4O as a read-only dynaset in VB6. How do I define the <br>
procedure, and then how do I get access to the stored procedure.<br>
<br>
<br>
James :)<br>
<br>

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top