trying to search records in a db2 via ODBC client access driver using a simple find/search sequence:
gives me the wrong result and when checking the getSQL, the sql query used by the databasemanager is wrong compared with the search condition, it does not select all fields in the form but only the id one, and the where condition which should be the search condition is “?”. Searched field is a 3 characters text field.
If I use the real SQL query myself, using getDataSetByQuery, it returns the correct result.