Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUG: SELECT UNION bad fieldname with a order pass
Message
De
06/09/2005 13:21:52
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Divers
Thread ID:
01046830
Message ID:
01047084
Vues:
11
>Fabio,
>
>>Because you are alone that you say that this is not a bug,
>>I always have trust that somebody else understands that this is a bug,
>>because the names of the fields of the result are not deterministic.
>
>Most developers that want specific column names in their final result specify them in the query. So count me in as another one that doesn't think this is a bug in VFP.

I think that you have not understood where the problem is.

Are you happy that these two queries return a final cursor with different column name?
* this return X
SELECT F1 X FROM T1;
UNION ALL;
SELECT F2 Y FROM T2

* this return Y
SELECT F1 X FROM T1;
UNION ;
SELECT F2 Y FROM T2
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform