>Thanks David,
>
>ADO recordset sounds good to me. The problem is that the grid that comes with VFP (version 6.0 sp4) doesn't allow me to bind it to an ADO recordset. Do you have any solution for that ?
>
>Thanks a lot
See CursorToRS and RSToCursor in the VFPCom utility. Of course, this won't help you because once you have to convert the recordset to a cursor you have lost the dynamic behavior of the recordset.
You could see if there is an event that fires on the dynamic ADO recordset when records are added or deleted on the backend. If there is, then you could bind to that event, again using VFPCom in VFP6 or EVENTHANDLER in VFP7 and update the VFP cursor in that event handler.
Of course, you could also just setup a timer in VFP and query the backend at a predetermined interval. Ugly, but it would work.
Or find a third party grid that works with ADO.