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

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

Article #4931

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

#4931

From: Satya S Kolachina
Date: Sat, 01 Sep 2001 11:43

34 lines
2137 bytes

Hello,

I am using Microsoft SQL Server 2000 and Oracle 8i (8.1.6). For SQL server I
am using the OLEDB driver that came with MDAC2.6 and for Oracle I am using
OLEDB driver provided by Oracle.

Do I have to use the system tables specific to the respective database, to
get this info ?
In that case, what is the meaning of the following two properties ??
(1) TDataSet->FieldDefList->FieldDefs[i]->Required
(2) TDataSet->FieldDefList->FieldDefs[i]->Attributes.Contains(faRequired)

Thanks for you help
Satya Kolachina

"Harold Howe (TeamB)" <hhowe@bcbdev.com> wrote in message
news:3B8EFF8B.F6DF5A90@bcbdev.com...
> Satya S Kolachina wrote:
>
> > I need to determine if a particular column allows null values or not, in
the
> > underlying table.
> >
> > (1) TDataSet->FieldDefList->FieldDefs[i]->Required
> > (2)
TDataSet->FieldDefList->FieldDefs[i]->Attributes.Contains(faRequired)
>
> What database are you using? You might need to perform a query against the
system
> tables of that database.
>
> Harold Howe [TeamB]
> http://www.bcbdev.com

Technical Details

Message-ID: <3b90c9bc$1_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!logbridge.uoregon.edu!xmission!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

References: <3b88fdf0$1_2@dnews> <3B8EFF8B.F6DF5A90@bcbdev.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,15569c6db2db3bc8
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-09-01 04:55:32 PST
Reply-To: "Satya S Kolachina" <skolachi@etsolutionsinc.com>
From: "Satya S Kolachina" <skolachi@etsolutionsinc.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3b88fdf0$1_2@dnews> <3B8EFF8B.F6DF5A90@bcbdev.com>
Subject: Re: How to find if a table column is null allowed or not ?
Date: Sat, 1 Sep 2001 06:43:17 -0500
Lines: 36
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: <3b90c9bc$1_1@dnews>
X-Trace: dnews 999344572 24.17.249.137 (1 Sep 2001 04:42:52 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!logbridge.uoregon.edu!xmission!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Reply to Parent Message