Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Required Fields

9 views
Skip to first unread message

Rui Pedro Ferreira

unread,
Mar 10, 2002, 1:49:44 PM3/10/02
to
Hi:
When using a TADOTable (D5), and the fields editor, the REQUIRED property of
my NOT NULL fields are always FALSE when they should be TRUE.

Does anyone knows why?

Thanks,
Rui Ferreira


Brian Bushay TeamB

unread,
Mar 10, 2002, 8:52:03 PM3/10/02
to

>When using a TADOTable (D5), and the fields editor, the REQUIRED property of
>my NOT NULL fields are always FALSE when they should be TRUE.
>
>Does anyone knows why?

That property does not propagate from the database to the Tfields.
If you want to use it you will have to set it.
--
Brian Bushay (TeamB)
Bbu...@NMPLS.com

Andreas Schmidt

unread,
Mar 11, 2002, 11:13:32 AM3/11/02
to

"Rui Pedro Ferreira" <ferr...@criticalsoftware.com> schrieb im Newsbeitrag
news:3c8baacd_1@dnews...

> Hi:
> When using a TADOTable (D5), and the fields editor, the REQUIRED property
of
> my NOT NULL fields are always FALSE when they should be TRUE.
>

This is a bug in ADO-Express.

Unit ADODB.PAS (line 3560ff)

{ Determine if the field's property list contains an ISAUTOINCREMENT
entry }
procedure AddFieldDef(F: Field; FieldDefs: TFieldDefs);
var
FieldType: TFieldType;
FieldDef: TFieldDef;
I: Integer;
FName: string;
FSize: Integer;
FPrecision: Integer;
begin
FieldType := ADOTypeToFieldType(F.Type_, EnableBCD);
if FieldType <> ftUnknown then
begin
FSize := 0;
FPrecision := 0;
FieldDef := FieldDefs.AddFieldDef;

// ****Bug Fix A. Schmidt 23.10.2001****
FieldDef.Required := (F.Attributes and adFldIsNullable)=0;


greetings
Andreas

--
Database Explorer for ADO (Freeware)
http://www.tobilan.de/adodeskexe.zip

Rui Pedro Ferreira

unread,
Mar 11, 2002, 6:21:20 PM3/11/02
to
Andreas, thanks a lot.

Rui Ferreira

"Andreas Schmidt" <a_j_s...@rocketmail.com> wrote in message
news:3c8cd7ef_1@dnews...

0 new messages