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