>There is a trick in FoxPro Advisor April 1996 page
>28 «Refresh
>Grid.RecordSource» published by Drew Speedie that
>work fine.
>
> The idea is to base a grid on a view, likely a
>parameterized one. When it's time to update the
>view:
>
>=requery(
)
>your grid and all the objects it contains remain
>INTACT; the displayd data changes.
>
>Since view can only exist in VFP databases, create
>a temporary database, add the view, and delete
>everything when done:
>*form load
>create database temp
>set database to temp
>create sql view...
>* the view is now available to the grid
>*form unload
>use in
>close database temp
>erase temp.dbc
>erase temp.dcx
>erase temp.dct
Ok, think I got all your message! Why create a Temp DBC when you can create a view in the current DBC & delete it when done?
I am still looking at using cursors though!
Thanks
Tom