I want to connect to a SQLBase database with ODBC. (Unit4 financial software running on Gupta SQLBase). For some tables it just works fine.

The customer table has two columns that don't allow NULL values and don't have a default value according to Database Builder. These columns are customer ID (CDRELATIE) and customer number (CDDEBITEUR). When I try to find a record a got a error (Invalid column name, etc).

I can't change the database. Is there a way to suppress this error?


Click image for larger version. 

Name:	SQLBase debiteuren.png 
Views:	301 
Size:	36.9 KB 
ID:	4340

Code:
 
c:\dataflex\vdf16.1\bin\dbexplor.exe
Algemene fout 42S22 (1401)--[MERANT][ODBC SQLBase driver][SQLBase]01401 DLU ICN Invalid column name   Table = DEBITEUR (5), Source = ODBC_DRV.Find
 
Error: 12289
MSG_ERROR_REPORT (433) - OERRORDIALOG (81) - at address 44930
MSG_REQUEST_FIND (385) - oDebiteur_DD (1272) - at address 13231
MSG_ITEM_FIND (5126) - oDebiteur_DD (1272) - at address 9703
MSG_REQUEST_FIND (385) - oCDRELATIEdbForm (1221) - at address 16788
MSG_FIND_GE (5703) - oCDRELATIEdbForm (1221) - at address 16003
MSG_ONEXECUTE (7803) - OFINDEQUALRECORDBUTTON (268) - at address 49964
MSG_EXECUTE (7802) - OFINDEQUALRECORDBUTTON (268) - at address 42147
MSG_ONCOMEXECUTE (6989) - OREBAR (131) - at address 41185
[start] - at address 75503