Is the Informix statement "for update" supported by SQL-Retriever, for example:
SELECT * FROM piprog WHERE prognr = 100 FOR UPDATE
Answer: No, SQL-Retriever does not support "cursor for update". It conflicts with the caching mechanism. The caching mechanism can put the cursor in a different place, causing the application to think it might be in the results set.
A possible solution is to turn off the caching with (FetchCache=0 for 16-bit or Datasource setup/Registry for 32-bit), although this will probably adversely affect performance.