>Hi to all,
>
>I've create my remote view as
>
>CREATE SQL VIEW myView REMOTE CONNECTION myConn SHARE AS SELECT * FROM myTable WHERE primaryKey = ?THISFORM.cPKey
>
>and my form works fine, I can read the view and update the data by pass-through.
>
>Now I've modified my view and I've add the FOR UPDATE clause at the end of command (this to lock the record that I read), but now I cannot open because I've this error:
>
>ORA-1002:Fetch Out of sequence.
>
>I've had the same problem for the SQLEXEC(lnConnHandle, 'SELECT ... FOR UPDATE', 'myCur'). To solve this problem I've put the Transaction property of the connection to 2 (Manually transaction) and now it works fine, but on the view the error already exist.
>
>What can it be ?
>
>TIA

What does ORACLE say about 'ORA-1002:Fetch Out of sequence.'? You can find it out with ORACLE manual/help file etc.