Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: SELECT UNION bad fieldname with a order pass
Message
From
06/09/2005 13:21:52
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01046830
Message ID:
01047084
Views:
12
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform