Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG2: SQL SELECT does not see open alias
Message
From
04/04/2005 02:13:19
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01000541
Message ID:
01001140
Views:
47
Hi sergey,

>I don't see anything different in VFP9.

Well there *is* as difference, however I'm failing to see what exactly. A piece of code doing a SQL select in a EXECSCRIPT() on an open alias buildin the executable is running under VFP8SP1 but fails in VFP9. Your test proves that the construction does not work in general in VFP8SP1, however I still not able to find out why it does run in my instance of VFP8SP1. I'll keep you updated when I found the key to this issue....

>Anyway, I think that what you're posted is a bug because we should be able to reference a table or a cursor by its alias anywhere it's visible.

I agree,

Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform