Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Read/Write Cursor
Message
From
11/10/2004 19:45:23
John White
Micro-Oriented Software Techniques, Inc.
Phoenix, Arizona, United States
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00950034
Message ID:
00950569
Views:
20
>Thank you very much, it works!!!
>
>Thanks again :)

Be aware this method only works when a physical cursor is created. Some queries (when using WHERE clause) result in a "virtual" cursor without a physical reality (filtered version of main table). So when processing the cursor via USE (DBF()) you are actually attaching to the TABLE and not the cursor.

A safety net you can use is to always add a field to the SELECT that causes a physical cursor to br written:
SELECT *, .T. as Junk from MyTable into Cursor MyCursor
This guarantees that a physical cursor will be created.
John White [MOST]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform