Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Order by clause is invalid
Message
From
06/06/2008 16:34:37
 
 
To
06/06/2008 14:42:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01322130
Message ID:
01322195
Views:
18
>The limit of 8192 is not exceeded
>The field is a date field
>That field is one of the fields selected
>the order clause specifies the name of the field and not a numeric position
>
>Additional info: In my select I do this
>
>select date as MeaningfullNameForDate...
>
>and the order is with MeaningfullNameForDate. That should'nt be a problem should it?
>

Try using the numeric position of the field in the list rather than its new name.

Tamar
Previous
Reply
Map
View

Click here to load this message in the networking platform