General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I must agree with you, Fabio, that considering the input table(s) field names when an ORDER BY is specified is pointless when it is stipulated that any field named in an ODER BY must be in the select's OUTPUT. Clearly it is the OUTPUT field names ONLY that matter.
I also wish that VFP would get rid of it's unhelpful means of determining an output field's size by using some occurrence of its CONTENT and just use the defined field's size unless overridden in the select itself.
cheers
>>Hi Jarid,
>>
>>Sergey is correct, this is not a BUG.
>>
>>Thanks,
>>Aleksey.
>>
>
>Aleksey,
>
>If in the grouping case ( DISTINCT or GROUP BY )
>it is not possible to order to the results for a tablesource's field,
>why VFP search the ORDER BY name in the list of the fields of the table source?
>It does not have sense.
>This creates alone problems in the construction of the query, without benefits.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only