>>>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?
>>
>>May be timer switches the currently selected area. I suggest to add set order to ItemId in InvestLimits - this will prevent such error
>
>A timer between two lines seems very unlikely to me.
If you're using any timers, then they're always going to run between two lines. You just don't know which two lines.
Tamar