Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid's strange behavor with filters and relations
Message
From
25/09/1997 09:31:38
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00051543
Message ID:
00051584
Views:
30
>Here is a complicated problem:
>I have a grid in a form which the RecordSource is an Alias, this alias has a relation to another table just to be able to display the description of an ID code field of the original table in one column of the grid, the original alias is filtered on a particular field. By some other means (other form opened by a command button) I change the contents of the original table, then I return to the original grid and the user meves to the top or bottom (with the Page Up/page Down key), or moves with the scroll bar to the top, suddently the column having the other table descriptions messes up, showing the same description in all rows. this gets corrected after I do a form refresh but only after that strange thing happens, if I do the refresh before it won't prevent from this to happen. It seems that the relation is broken for a while due to the filtered condition. I have optimistic table buffering on the grid alias
>Did anybody understand my problem? any suggestions?

I saw similar problems. The situation may be corrected by applying :
Form.lockscreen=.t.
**** existing code including Grid.Refresh
Form.Lockscreen.=.f.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform