Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Cursor and table shows as the same when display status
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL Cursor and table shows as the same when display status
Miscellaneous
Thread ID:
00636393
Message ID:
00636393
Views:
40
If you do a SQL * from a table into a cursor (which would result in the resultant being identical to the FROM table), doing display status shows the (FROM table) being open (which is correct) and the identity of the cursor is identical to the open table except that it shows a different alias and is readonly. If the exected SQL resultant is filtered and the resultant is not identical, the identity of the cursor is different. I was under the impression that a cursor always had an identity of its own!

Can somebody explain why this is happening?
Next
Reply
Map
View

Click here to load this message in the networking platform