Subject Cursor not updatable ???
Author Eyal
Hi,

I'm using a TIB_Cursor to scan data in a table and, depending on some
conditions, update some of the rows. However I get an exception with
SQLError -510 "Cursor not updatable".

Some more inforation:

Query uses a JOIN.
KeyRelation = name of table I need to modify.
PreparedEdits = FALSE, so IBO only update changed fields.

Code looks like:

WHILE NOT Cursor.EOF DO
IF some_condition THEN
BEGIN
Cursor.Edit;
Cusror['col1']:=Value1;
Cursor['col2']:=Value2;
...
Cursor.Post; // Here happens the exception
END

I traced through IBO code to the point where IBO calls the raw API,
which returns an error code, and so IBO triggers an exception.

Any ideas?

Thanks,

Eyal.