Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No table is open in the current work area
Message
From
02/09/2016 01:54:50
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01640326
Message ID:
01640388
Views:
92
>I've seen it before in cases where changes to the recordsource table, or its order/relationships are causing a grid to auto-refresh, and DynamicBackColor is definitely very sensitive to that. Possibly, other grid events (like Before/AfterRowColChange) might trigger as well. Needless to say, the code you posted should not belong in a function executed on DynamicBackColor ...

Actually, the dynamicbackcolor calls a method on the same form in the same datasession, but that method has some code that calls the offending method with the two lines.

Walter

>
>>>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've got a suspect now...
>>
>>The two lines above are part of a method on an object that is called from a dynamicBackColor property in a grid which lives in another datasession.
>>I've seen this before where such a construct could lead to a method call being executed in the wrong datasession.
>>
>>I'll make some modifications and see whether this resolves the problem.
>>
>>Thanks everyone, but I do not think it has to do with anything being fired between the two lines of code. Its quire rare but structural.
>>I think its a VFP bug.
>>
>>Walter,
Previous
Reply
Map
View

Click here to load this message in the networking platform