How to find if a table column is null allowed or not ?

Article View: borland.public.cppbuilder.database.ado

Article #4893

Back to borland.public.cppbuilder.database.ado Previous Next

#4893

From: Satya S Kolachina
Date: Sun, 26 Aug 2001 13:47

22 lines
1615 bytes

Hello.

I need to determine if a particular column allows null values or not, in the
underlying table.

I tried the following two approaches.

(1) TDataSet->FieldDefList->FieldDefs[i]->Required

(2) TDataSet->FieldDefList->FieldDefs[i]->Attributes.Contains(faRequired)

Both the methods failed. Failed means, they are returning 'false' for all
the columns in the underlying table, even if the underlying table has
columns that do not allow nulls.

I am expecting to see 'true' for columns that do not allow nulls; and
'false' for columns that allow nulls.

Please help me.

Thanks and regards,
Satya S Kolachina

Technical Details

Message-ID: <3b88fdf0$1_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!netnews.com!xfer02.netnews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,15569c6db2db3bc8,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-08-26 06:47:52 PST
Reply-To: "Satya S Kolachina" <skolachi@etsolutionsinc.com>
From: "Satya S Kolachina" <skolachi@etsolutionsinc.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: How to find if a table column is null allowed or not ?
Date: Sun, 26 Aug 2001 08:47:54 -0500
Lines: 25
Organization: Emerging Technology Solutions, Inc.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2462.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2462.0000
NNTP-Posting-Host: 24.17.249.137
Message-ID: <3b88fdf0$1_2@dnews>
X-Trace: dnews 998833648 24.17.249.137 (26 Aug 2001 06:47:28 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!netnews.com!xfer02.netnews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews