Lets say I create a table...
> CREATE TABLE tbInvoices
> (
> pkInvoice BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
> dCreated DATE NOT NULL,
> PRIMARY KEY (pkInvoice)
> );
Then I call SQLColumns to find out what the columns are. Now there are
two ways to find out if the column can be NULL, aside from assuming it
because it is a primary key.
1. column 11 (NULLABLE)
2. column 18 (IS_NULLABLE)
Now I would expect that column 11 would be SQL_NO_NULLS but myodbc 3.5
does not appear to return this?
Peter
BTW: Column 11 is fine when the column is NOT a primary key.
