Put in your own EditSQL and use it instead of the one that is created for
your automatically.

Jason

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Eyal
> Sent: Thursday, June 02, 2005 12:18 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Cursor not updatable ???
>
>
> 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.
>