Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiuser app, second instance losing grid bindings
Message
From
20/11/2008 02:13:12
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01361877
Message ID:
01363060
Views:
12
>>>Kenneth,
>>>
>>>Don't use the root of c drive for your temp folder. Use a directory.
>>
>>changed to C:\TEMP
>>
>>Same problem.
>>
>>I found somewhere I was resetting the RecordSource to the cursor. I took this out and the references to the columns.
>>
>>So now I have this:
>>
>>Form Load Method: Creates blank cursor called CaseSQL
>>GRID Record Source is set to CaseSQL originally.
>>GRID columns are set with the appropiate fields from CaseSQL
>>
>>Now, run system on one machine and comes up fine.
>>Start on second machine and Grid comes up completely white.
>>
>>The recordsource is still there (CaseSQL) but the grid is completely blank.
>>
>>I am confounded. It must be me because I have done this many times before but I am besides myself at to why this now.
>
>Can you post code which is re-selecting records?
>
>Also you may want to grab all form's code using Class Browser View Code feature and look where you reference the grid. May be there is some strange code hidden somewhere.
>
>Finally, when you select records to your temp cursor, are you using NOFILTER clause? It may be important.

Taking another line of thinking here. It has something to do with the column ControlSources. I am starting from scratch and building the grid up one column at a time. First column works ok so it looks like the creating of the RecordSource (CaseSQL) is working fine and not the cause of the Grid error.

Will keep you posted. Thanks for all your ideas.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform