How to check SqlSetPos compatibility on database? I have a database tool with the possibility to suppress the use of SqlSetPos. According to the documentation, some databases are not fully compatible with this function. How can I check if my database is compatible with this function or not?
You'll need to check the documentation for the specific ODBC driver you are using. I would expect the SqlSetPos function to return SQL_ERROR or SQL_SUCESS_WITH_INFO if the driver doesn't support (or partially supports) the function. In that case, a subsequent call to SQLGetDiagRec should return a SQLSTATE with the error/warning cause, such as IM001 (Driver does not support this function).  See the SQLSetPos function reference for details.