Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUG: SELECT UNION bad fieldname with a order pass
Message
 
 
À
05/09/2005 18:19:10
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:
01046872
Vues:
14
>And this what it centers with the name of the fields of the result?

What it suppose to mean?

>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. That's why I always give the same name for the specific column in all SELECTs in UNION.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform