Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: SELECT ignore cursor's table
Message
From
02/04/2005 01:44:57
 
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:
01000950
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.

Sergey, I known it, but:
- the cursor is within VFP by definition
- DBF('cursor') is unique by definition

then:
- VFP can found it into they file handles list.

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

Click here to load this message in the networking platform