Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: SELECT UNION bad fieldname with a order pass
Message
From
05/09/2005 18:02:23
 
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:
01046855
Views:
22
>It's documented behavior of ORDER BY in UNION query in VFP9.
>
>>when VFP apply a ORDER pass ( it do this also to make the distinct pass )
>>VFP build a new cursor
>>but it uses the names of the fields of the last select
>>in the case these is present:
><snip>

where ?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform