Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bug about select command
Message
From
26/12/2006 09:22:28
 
 
To
26/12/2006 09:07:50
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01180172
Message ID:
01180189
Views:
16
>I aliased table test as atest. Maybe from your viewpoint it's not a bug. But from mine, It's a bug.
>
>>There is no bug here. You try to select from table test into cursor test. Since the name is test for both the from table and the result cursor, you get the correct error. What did you expect? I agree that the error message is misleading, but it's definely no bug.

To speed up frequent selects, it's an old trick to keep the tables open by issuing USE statements for all the relevant tables early in the code. If you USE a table ALIAS something, then the alias is treated exactly like it was the name of the table. AFAIK it's "always" been like that. Try this
Use yourtable as xxc
Select * from xxc && You get exactly the same result as if you issue Select * from yourtable
If you consider this a bug, it's your choice. I never consider documented behavior as a bug. If documented behavior is a bug, then VFP has a lot of bugs. <vbg>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform