>What is 79 in your select statement and does it absolutely need to be executed using EXECUTE?
>
>>>
>>>SET @lcsqlcmd = '
>>> select #treport.*, apvadr.cphone as cBphone, apvadr.ccontact as cBcontact,
>>> apvadr.ccompany as cBcompany, apvadr.caddr1 as cBaddr1, apvadr.caddr2 as cBaddr2,
>>> apvadr.ccity as cBcity, apvadr.cstate as cBstate, apvadr.czip as cBzip,
>>> apvadr.ccountry as cBcountry
>>> from #treport JOIN apvadr ON #treport.cvendno = apvadr.cvendno
>>> where apvadr.cvendno = ''Z_SKIPS'' and apvadr.ctype=''O'' and apvadr.caddrno = ''MIA''
>>> order by 79
>>> ,' + @lcsortno
>>>
>>>
>>>>The relation between them should be a field name cvendno, both tables have it
>>>>
>>>>>What's releationship between #treport an apvadr ?
>>
>>
>>thanks,I am polishing it now
79, the main column order
.......
DO WHILE .T.
ME.Work()
ENDDO
