Hi Cicilia,
I don't use value 2 as first parameter.
Will you get the same error if you use 1?
MartinJ
>Hi
>
>When using an updatable cursor in a form, and saving the changes I can sometimes get the following message :
>* [ORACLE][ODBC]No data at executioon values pendig.
>*
>* Reverting changes in cursor
>*
>*
>
>This message is followed by :
>
>* Connectivity error: [ORACLE][ODBC][Ora] ORA-03127: no new
>* operations allowed until the active operation ends.
>
>The error is recreatable, after a number of updates going in and out of a form. There is no specific data that causes it, and the table it is going against does not have any BLOB fields.(Which is what most of my research is indicating can cause this error.) This is not for just one specific form/table, but going against a number of different once...
>
>
>I am using
>
> SQLEXEC( lnConHandle, lcSql, lcUpdtCursor)
>
>and the following Cursorsetprop's
>
> CURSORSETPROP("TABLES", lcTableName, lcUpdtCursor)
>
> CURSORSETPROP("KEYFIELDLIST", lcKeyField, lcUpdtCursor)
>
> CURSORSETPROP("UPDATABLEFIELDLIST", lcUpdFields, lcUpdtCursor)
>
> CURSORSETPROP("UPDATENAMELIST", lcUpdNames, lcUpdtCursor)
>
> CURSORSETPROP("WHERETYPE", 1, lcUpdtCursor)
> CURSORSETPROP("SENDUPDATES", .T., lcUpdtCursor)
>
> CURSORSETPROP("BUFFERING", 5, lcUpdtCursor)
>
>
>and for commiting the changes ....
>
> TABLEUPDATE(2, .F., lcUpdtCursor)
>&& where lcUpdtCursor is the name of the cursor.
>
>Do you have any soughts what could cause this, or what the solution would be???
>
>Thank you Cicilia