Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using ADO in ntier
Message
From
16/09/2002 10:51:58
 
 
To
16/09/2002 10:34:10
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00700771
Message ID:
00700807
Views:
8
Beth,

If this is a method of a DLL and you want to pass the RS back to a client, then the RS CursorLocation property needs to be 3 = adUseClient.

More to your question, to disconnect a recordset you set its ActiveConnection to Null after the RS has been populated, i.e. after the Open method has been executed or after another Execute method has returned an RS with a result set.

I am not certain that this is the problem in your case, just throwing some ideas of what could be causing problems. Are you getting any error messages?

Hope this helps.

>don't you need that connect for the making of the recordset?
>
>>If this code is from a DLL method the recordset oRecordCta has to be client >side, and also try disconnecting the recordset before returning with
>>oRecordCta.ActiveConnection = Null
>>HTH
>>JCF, MCSD
>>Check out http://foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform