Is your MTS object doing a "Select * From myTable"?
If so try changing the source to a table name and also change the command type. Something like this:
oRS.Open("myTable", oCn,,, adCmdTable)
I have a VFP DLL in MTS that does this and the source is not cleared. When the batch update is done I can still see the source property although I don't requery from the same method since that function is on another method.
>Thanks for the reply.
>
>This is the pseudocode:
>
>1- The client request the data from a object inside MTS
> somtething like MyData:=MyServer.MyObject.GetData(Filter,Order);
>2- In the client, change is done for the user
>3- The client request a update to the same object..
> Like it:
> MyServer.MyObject.SendData(MyData)
>
>Inside the server, i loop for the changed records (i use updatebatch), update each one, and return ok or not ok to the client. The rs is passed by ref...
>
>The problem is that in the 1- step, MTS clear the source property...
>
>In VB happend it?