Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Read/Write Cursor
Message
From
12/10/2004 02:50:06
 
 
To
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:
00950613
Views:
12
Even easier: add NOFILTER

>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform