Where is my cursor?

[Invicta]

When writing VB6 code to use stored proceedures on the server, is the result of the select (within the SP) stored on the server or passed to the client?

 

[Guest_imported]

That depends on the settings.  If you use ADO, you can specify the location with a parameter.

 

[calahans]

within an sp ALL the action takes place on the server (including cursors) <p>Cal<br><a href=mailto: > </a><br><a href= > </a><br>

 

[LuvASP]

Cursor.location = aduseclient<br>Curson.location = aduseserver<br><br>will determine where the resultset is going be after the recordset or command object is opened or executed.

 

[calahans]

You have to be careful here - the Cursor.location is a VB language thing not a SS nproperty. The followiong happens.<br><br>You VB app fires the SP.<br><br>The SP is run by SS and any selects & cursor it creates <b>DURING</b> execution will reside on the server. Regard less of what you have specified in your VB code.<br><br>When the SP <b>RETURNS</b> the results, the cursor is then resident where you have specified in the VB code.<br><br>My initial comment stil stands.<br><br>HTH <p>Cal<br><a href=mailto: > </a><br><a href= > </a><br>

 

[Invicta]

That's all for your comments.<br><br>Cal, special thanks for the extra info on where things sit DURING and on RETURN.