Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: SELECT ignore cursor's table
Message
 
 
To
01/04/2005 08:53:42
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01000615
Message ID:
01000940
Views:
21
It's not a bug but rather a side-effect. For performance reason a cursor is created with FILE_ATTRIBUTE_TEMPORARY attribute which instracts Windows not to create a physical presence on the disk if sufficient cache memory is available. Granted, this behavior should be documented better.

>
>CLOSE TABLES ALL
>CLEAR
>CREATE CURSOR MyInternalTable (aa i)
>? DBF('MyInternalTable'),ISEXCLUSIVE()
>* BUG: NEXT OPEN A DIALOG !
>SELECT * FROM DBF('MyInternalTable') INTO ARRAY ZZZ
>USE
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform