>Any timers around that could switch work area?
Yes, there are timers, but it happens too often just between those lines and nowhere else (in this million+ codeline app).
I'm beginning to suspect it is a problem that its at the wrong datasession. Still does not explain why it passes the 1st line without a problem.
>>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?