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