>I try to use,
>in sql order by thisform.order.vlaue
>but now working, how can be
>
>thanks
Do you mean VFP will not allow you to use "order by thisform.order.vlaue" (assuming that "vlaue" is a typo error for "value") in your SQL statement?
If so, first set a local var to thisform.order.value and use this
e.g.
lcOrderval = thisform.order.value
Select ...
... order by lcOrderval
HTH
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.