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:
01001663
Views:
15
Hi Fabio,

Here is a workaround:
CREATE CURSOR MyInternalTable (aa i)
? DBF('MyInternalTable'),ISEXCLUSIVE()
* Works ok when referenced by alias
SELECT * FROM MyInternalTable INTO ARRAY ZZZ
* Workaround if DBF() is needed 
USE (DBF('MyInternalTable')) again ALIAS SomeUniqueALias IN 0
SELECT * FROM SomeUniqueALias INTO ARRAY ZZZ
USE IN (SELECT('SomeUniqueALias'))
USE
Regards,
Frank Camp
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform