|Subject||Re: Cursor not updatable ???|
> Put in your own EditSQL and use it instead of the one that isJason,
> created for your automatically.
That works, but defeats my goal of updating only changed columns (or
no update if nothing changed).
Also why don't the update statements that IBO generates work? I traced
the code to the point where IBO calls the API, and the query seems to
be ok, something like:
UPDATE table SET col=? WHERE CURRENT OF cursor_id
I also tried with SearchedEdits=TRUE and KeyLinksAutoDefine=TRUE, so
the resulting update statement uses the "normal" method of updating a
row based on the ID column. The query passed to the API looks like:
UPDATE table SET col=? WHERE table.ID=?
This looks ok, and doesn't trigger any exception, but it also doesn't
Although I'm not really familiar with the API level, I may have
figured out what is wrong. It seems that the parameter block for the
search column (in this case ASQLDA.SQLVAR) - always contains a zero
value for the column. If this is indeed the case then the search fails
and so the update never happens.
Unfortunately, I can't get non-prepared-edits mode to work. There's a
problem in case of a cursor update, and another problem in case of a
Is there any way to get this working? I really like the idea of IBO
taking care to update the required columns, or not update at all, as