>Thanks for the reply. However, this work only editing existing records. But if i Add a new record i get the error "Ole Dispatch ? from?" if you call the requery() method.
>
>If you chek the source of the recordset this is returned empty(only if the vfp server is hosted in COM+), and is not possible set the source if the recordset is open.
>
>Also, when i talk about $2000 dollars is not for the VFP licence, si the lost for me if this project fail..again...
>
>Thanks.

It would be helpful to understand under what circumstances do you need to call Requery on a disconnected recordset. It wouldn't work if say you are trying this from the client side, since you would have a recordset that was obtained via a middle tier object and not directly with RS.Open, Cn.Execute or Cmd.Execute.

And while I could be wrong about this, it is my understanding that Requery is used in the context of an open recordset with a live connection to the backend as is the case for server-side recordsets. Taking this into account leaves the Requery method out of the picture if the RS you are using is being disconnected and returned to the client. I guess some testing / research is in order here.

As I said before, batch updating works for me, be it for existing or new records via UpdateBatch().