How to identify if a column can be null

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
alchemy9
Posts: 5
Joined: Wed 01 Feb 2006 06:39

How to identify if a column can be null

Post by alchemy9 » Mon 26 Mar 2007 13:49

how do you identify if a column can be null?

I though it would be by using the following:

MSQuery1.FieldDefs.Items.Required


however this does not appear to work I have seen this link:

http://qc.borland.com/wc/qcmain.aspx?d=6264

so is it a bug?

Jackson
Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Tue 27 Mar 2007 09:00

If you need TCustomDADataSet to set the Required property of TField and TFieldDef objects for NOT NULL fields, you have to set the TMSQuery.Options.RequiredFields property to True. For more information about the RequiredFields property, please see the SDAC help.

Post Reply