Devart Forums

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?

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.