Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange SQL result
Message
From
05/01/2005 11:40:42
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00974162
Message ID:
00974427
Views:
23
>>>>Try
>>>>
>>>>
>>>>NOT DELETED("Links")
>>>>
>>>>
>>>You cannot use function like DELETE() with alias as parameter in SELECTS.
>>
>>Really! I could not varify my suggestion. I do not have a copy of VFP with here.
>
>Really. Alias you specify refers to the original table but SQL SELECT doesn't use open tables but reopens them again under different alias (similar to USE AGAIN).

Thanks for clarification.
Greg Reichert
Previous
Reply
Map
View

Click here to load this message in the networking platform