Re: ADOX - Access table creation with nullable columns.

Andy wrote:
I need to programatically create a mdb file which will contain
nullable columns. I am using C++ with ADOX for the table creation
and ADO to perform the table update.

Although ADOX seems to create the table ok, Table->Columns->Appends
does not set the fields as adColNullable as expected.
<sniip>
m_pCol1->Attributes = ADOX::adColNullable; \\Does this work?


It's been a while but I think you have to use the Properties collection (not
the Attributes collection) of the Column object to set the
DBPROP_COL_NULLABLE property to true.


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Loading