>Hi Renato,
>
>I think the problem might be the connection. The way you describe it, you are not using the same connection on the view and Pass through commands.
>
>The only way I know to share a connection between a remote view and pass through commands, is to get the connection handle that the view uses.
>
>When you create a remote view, it doesn't connect to the server. It only connects to the server when you USE the view.
>
>So after you USE the view, you can use cursorgetprop("ConnectHandle",VIEW_NAME) to get the handle for the connection that VFP created.
>
>Then you can use this handle to send commands with SQLEXEC to the server.
>
>This way you are sure that you are sending the commands through the same connection that the view uses.
Thanks for your solution, it works fine.
Now I can create my view as a Oracle SELECT ... FOR UPDATE statement and update data by pass through method.
Renato