>I try to use,
>in sql order by thisform.order.vlaue
>but now working, how can be
I always am careful not to use thisform or this in a SQL query. I would usually dump that in a variable and make reference to it such as ORDER BY &lcOrder.
Or, if you use SQLExec(), you can have something like this:
IF NOT goSQLExec.SQLExec('SELECT Table.Numero,Table.ID FROM Table WHERE Table.Table="'+ThisForm.cTable+'"')
RETURN .F.
ENDIF
By that, no matter if the SQLExec() is executed within or not the scope of the form or the this, it will always work.