Subject | Cursor not updatable ??? |
---|---|
Author | Eyal |
Post date | 2005-06-02T19:17:41Z |
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.
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.