Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trouble refreshing the grid
Message
From
28/10/1997 09:47:17
 
 
To
28/10/1997 09:42:29
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00056872
Message ID:
00056984
Views:
32
>>>>>I have a form with a grid based on a view.
>>>>>
>>>>>After the TableUdate() in my save method, I issue a Requery() on the view and a Refresh() of the form.
>>>>>
>>>>>For a reason I don't know, the Requery() doesn't seem to work, because the grid appear empty. I tried the Next and Previous button, but the grid still appear empty. If I quit the application and go back in, I will see my new record.
>>>>>
>>>>There is a good habit: any time you see problems with grid issue something like:
>>>>Thisform.Grid1.Recordsource=Thisform.Grid1.Recordsource
>>>
>>>I tried, without success.
>>>
>>This must work, or ...
>>Select view1
>>=requery()
>>Thisform.Grid1.recordsource="view1"
>>Thisform1.Grid1.refresh
>
>I found that it's not the grid who have a wrong behaviour. The Requery() doesn't return any record. If I browse the "Products" table and redo the Requery() now it show the new record. Why?

Do you have buffering on table? If yes, you should first tableupdate() on table itself (browsing there you fire it implicitly) and then requery() data into view. Actually, it will allow you to show records in grid, however IMHO you better use buffering on view and no buffering on table.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform