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 02:45:17
 
 
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:
01046908
Vues:
14
>>And this what it centers with the name of the fields of the result?
>
>What it suppose to mean?

It means only that who has written the documentation
it has not understood a lot of things.

>
>>I hope that Aleksey he realizes where the error is
>>(it is in an array of names of the internal routine C++)
>>
>>Do you think that it is correct that these two queries return two different results?
>
>It works this way since Fox 2.6 at least. Unfortunately there's no clear description in VFP help on how the names of result set are derived in the SQL Select in case of UNION.

And therefore if a bug succeeds in surviving to 10 revisions of an application
does it turn him into a correct feature?

No, an old bug remains.

>That's why I always give the same name for the specific column in all SELECTs in UNION.

This is a workaround, nothing more.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform