Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid loosing its data
Message
From
25/11/1999 14:27:13
 
 
To
25/11/1999 06:26:18
Robin Cole
Olive Leaf Enterprises Pty Ltd
Blackburn, Australia
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00295489
Message ID:
00295617
Views:
17
>I have a pageframe with 10 pages on it. The first one has a grid with records from two related tables. I can cycle between most pages and return to page 1 but when I return from some pages the data does not display. I know it is there as I have placed a listbox with the same data on page 1 and it displays the data ok. Is there a special 'refresh' command for grids?
>
>Hope I have given enough info, can omeone can help.
>
>Thanks Rob Cole

Grids have bad habit to lose data when you touch its recordsource. For example, if you base a grid on a cursor and re-populate the cursor with Select-SQL. Also, it may be the result if you pack a table, requery a view etc. The general remedy is to restore Grid.Recordsource programmatically:
Grid.Recordsource=''
Grid.Recorsource='mycursor'
In many cases, it's not enough. You may also have to restore Columncount property and Column.Controlsources and may be something else.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform