>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.