Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What does CA closes alias cursor after executing?
Message
From
01/02/2005 11:28:22
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP3
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00981617
Message ID:
00982701
Views:
14
Hi Stuart.

>I am using CA with ADO to access data on a SQL server database. I have a method on a form that calls links to the database and retreieves the data. I can see the alias created while the code is executing in the method. However, the minute the method terminates the cursor is gone. How can I prevent the cursor from closing once the method has terminated so that it is available through out the form like any other table or cursor.

In addition to Beth's suggestion, you can use the CursorAdapter's CursorDetach method to free the cursor from the CursorAdapter.

Doug
Previous
Reply
Map
View

Click here to load this message in the networking platform