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 14:59:31
 
 
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:
01047129
Vues:
8
>Hi Fabio,
>
>I agree with David and Sergey. Why do we want to create inconsistent names to begin with and then try to blame VFP for not resolving it properly? Even if this is a bug, it's a bug that was provoked on purpose.
>

Naomi,

>>>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