Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bug about select command
Message
De
26/12/2006 09:22:28
 
 
À
26/12/2006 09:07:50
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01180172
Message ID:
01180189
Vues:
18
>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>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform