make order for sql statement

Question

dear all

i have table and i create this statement

select * from xx order by xx.names,mline(xx.names2,2) into cursor xx2

the error message tell me the there is an error in order

what's the error in this line

Answer 1

Change the select to

Select *, mline(names2, 2) as SecondMemoline from xx order by names, SecondMemoLine into cursor xx2

Assuming names2 is a field and not mline(names,2,2)

Answer 2

In Visual FoxPro you can not use a function for the field in the ORDER BY. It means that you either have to include the computed field in the result set and use its alias in the ORDER BY or add this field to the derived table and re-structure the query as

select field1, field2, etc. from (select *, myComputedColumn from ...) X ORDER BY myComputedColumn

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 3

Hi,

to avoid unwanted result better fix the length of SecondMemoLine with :

Padr(Mline(remark1,2),60,' ')

where 60 is your desired length

Regards,

Koen