Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Proper syntax when using UNION
Message
De
23/01/2002 18:05:48
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00609414
Message ID:
00609430
Vues:
17
>Been that way as long as I can remember. I think it is that way because different field/column names can be used in the SELECT statements as long as the data types are the same.

The field column remain intact with or without the UNION clause, in the example I gave. I understand that was calculation field are present that we have to either reference it by numeric references or by an assigned field name. But, in this case, the result includes the proper field names. That's what is frustrating.

I'll add that one in the Toledo Wish List.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform