Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid not displaying data or refreshing
Message
From
21/01/1999 21:30:03
 
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00178801
Message ID:
00178813
Views:
34
>>Well, I got the grid attached to a cursor, but it is completely blank. At least there are no errors when the form runs! This is my first time using a grid, btw. I know there is an issue with the grid loosing its recordsource when refreshed, but am at a loss as to where to put the code to get anything to display. Any suggestions would be appreciated.
>
>Make sure the cursor exists before the grid is initialized. Also make sure the cursor doesn't stop existing any time while the grid exists.
>
>-Michelle

Good point. This also goes for reexecuting the SQL that creates the cursor, because SQL first deletes the existing and then creates the new one. IF you must do this, then do it like this:

MyGrid.RecordSource = ""
SELECT * FROM MyTable INTO CURSOR MyCursor
Mygrid.RecordSource = "MyCursor"
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform