>>>I'm stumped by the error in the title on the 2nd line. I catched this in the error log at a clients, so no repro.
>>>Its intermittend.
>>>
>>>

SELECT InvestLimits
>>>SET ORDER TO Itemid

>>>
>>>
>>>There is no variable called Investlimits, just an alias. The first line has no problem, but it bangs on the SET ORDER TO ItemID.
>>>
>>>Anyone have an idea?
>>
>>I am guessing from database entry that table is housed on local platter ?
>>If dbc is used, that is in local exe or at least locally installed data dir ?
>>In vfp9 a sporadic bug was fixed where closing and reopening seldom resulted in wrong alias, so from version no dice.
>>I'd sandwich an select() and afields() calls between those lines, hoping to get the info reflected in error log before trying via patch programming or simple doevents...
>
>Its a cursor attached to a cursoradapter

grasping at straws: temp dir where ? # of files in temp dir ? If many thousands by never cleaning residuals, some operations will be much slower...