Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refresh grid
Message
From
28/11/2004 11:06:42
 
 
To
28/11/2004 11:01:31
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00965219
Message ID:
00965220
Views:
7
>I have a form with grid and another few text boxes to add value to the source table.
>I populate the grid in 'load' of the form and its very good by the following syntax:
>
select * from melamdim into cursor crsrgrid readwrite
>ThisForm.grdmelamd.refresh()
>When I want to add new things to the table and to update the grid, my code of the 'safe' command is like the following:
set safety off
>zap in crsrgrid
>set safety on
>select * from melamdim into cursor crsrgrid readwrite
>ThisForm.grdmelamd.refresh()
>The table updated, but the grid become whait, what can I do?


Before the zap set the grid.recordsource to "". Then zap. Then select. Then reset the grid.recordsource to the cursor of the select "crsrgrid". Put everything between form.lockscreen =.t. and form.lockscreen=.f. statements to make a cleaner form update.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform