Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid goes blank
Message
From
11/05/2005 19:49:08
 
 
To
11/05/2005 14:06:40
Mike Cline
Silver Creek Software
Boise, Idaho, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01013064
Message ID:
01013199
Views:
13
Yes, I have...

One way to get around this is to programatically reset the desired information on the grid... something like this:
with thisform.grid1.
   recordsource='tablename'
   column1.controlsource='fieldname'
   column1.width=80
   column1.header1.caption='Customer'
   .refresh()
endwith
>This is very odd.
>
>I have a grid with a temp table as its recordsource. The RecordSourceType is "Alias". This table is created before the form or the grid - get created. This table has no records in it at this point. Then after the form gets created we do some processing that does not involve the recordsource table - and for some reason - the link between the grid and my recordsource table gets broken... and the grid goes blank. The columns, the gridlines, everything disappears. The code that seems to trigger this is just moving a record pointer on an unrelated table.
>
>I searched Universal Thread and found that I could get around this by blanking out the grid's recordsource property before the offending code gets executed, and then re-establishing it afterwards. That worked, except that the data I see in the grid after doing that, is just the first 5 coulumns in my recordsource table...not the columns I setup in the column's ControlSource properties. I have tried re-establishing the column controlsources - but that does not work either.
>
>I am not closing the recordsource table anywhere in the code after it gets created. Also, this form is in a private datasession, but the recordsource table is available in this datasession.
>
>Has anyone seen something like this?... any ideas about what might cause it?
>
>--Thanks
>Mike C.
Thanks,

Stacy



Black Mountain Software, Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform