SQL-Retriever ODBC


FAQ: Does SQL-Retriever support 'cursor for update'?

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.


SQL-Retriever: ODBC driver
Home | Software | Background | Library | Configuration | Versions | Security Manager | Debug | FAQ |
Site Map; Accessibility;

Last modified: Wednesday, 22-Mar-2017 15:49:33 GMT