how to test for null values in a column
843854Oct 14 2003 — edited Oct 14 2003I'm having problems testing for null values in a MS access database which I connected to using the jdbc-odbc bridge.
For dbase, I simply used
Object val = theTable.getObject(i+1);
if (theTable.wasNull())
{ tableData[row] = null;
}
else if (columnType[i] == String.class)
{ tableData[row][i] = theTable.getString(i+1);
}
and so on.
but with the microsoft access ODBC driver. After I used get once for the i+1 column, I cannot use any other getMethod on it afterward. Does anyone know how I can conteract this?