List:MySQL ODBC« Previous MessageNext Message »
From:Peter Harvey Date:February 11 2002 9:51pm
Subject:SQLColumns
View as plain text  
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.






Thread
SQLColumnsPeter Harvey11 Feb
  • RE: SQLColumnsVenu11 Feb
  • Re: SQLColumnsJim Dickenson11 Feb
    • RE: SQLColumnsVenu13 Feb