Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange SQL result
Message
 
 
To
04/01/2005 16:39:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00974162
Message ID:
00974229
Views:
24
>>>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).
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform