>>>This used to work fine in vfp3
>>>
>>>select distinct last_name, first_name, mid_name, ;
>>> address1, address2, city, state, zip_code, ;
>>> ' ' as packet_id,ssn, right(a.ssn,4) as ssno ;
>>> from temp ;
>>> into cursor address ;
>>> order by ssno, ssn
>>>
>>>How to fix in vfp9 besides making two statements?
>>>How to find all like this in code?
>>
>>select ... order by 11,10
>>
>>should work. Does it?
>>PS: There is a potential error in code there - right(a.ssn,4).
>>Cetin
>
>Cetin-
>
>I've run this code after creating a temp table with all these fields.
>It only fails because of the "a." in front of the ssn.
>
>But if you
>Select A
>Use Temp
>
>Then issue the select it works fine.
>
>
>Dan
Dan,
In my first message I've noted it as a potential error and Doug said it was a typo there. Now I'm not yet clear if it errors in VFP9 or not:) There is another thread provided in Fabio's message claiming the error occurs and is expected. The SQL in that thread seems fairly legal to me.
Anyway when I install VFP9 sure I'll be trying out myself.
Cetin