irwan,
One fast way is to do a parallel insert into the VFP cursor that is being displayed in the grid:
SQLExec( ..., "insert into... )
insert into vfpcursor ...
thisform.grdX.Refresh()
A slower way is to repull the data back down from SQL, but then you have to clear the RecordSource of the grid to keep it from self destructing during the select and restore it afterwards. You can also use a seperate cursor that's zapped/appended to.
You could also use a RemoteView which would support a requery() operation.
>hi all, i've unsolve problem, how do i refresh my grid after i insert/update to sql server table, i've used =requery() but 'not support for sql pass-thru...'
>i've used mysql 3.51 as backend. thank's