>Hi to all
>
>I use my views with the FOR UPDATE clause, to be sure to haven't conflit error ( like buffering in pessimistic mode).
>To update the data I use pass through method, with a SQLExec() but it doesn't work because record are locked by my view!
>
>How can I jump this problem ?
>
>The SQLExec and view work with the same connection name. I open the connection (SQLConnect()) at the start of my app, (but I think that view open another connection to share with other view)
>
>
>TIA
Hi Renato,
Though this is not a solution of the problem yor'r having right now but to avoid update conflict, we can set 'UpDateType' of the Remote View to 'Key Fields only'.
I can try to help you out,if you give more details of what sort of errors you'r getting while issuing SQLEXECUTE(). One more thing surprises me that what is the reason of using SPT to update the data which are brought using Remote View.
Bye
Jayesh
- Jayesh