Thank you for your response.

As suggested, I used the REQUIRED/NOREQUIRED ColumnAttributes of the
IBConnection
in order to control the Nullability Constraint.

I have tried the following codes(one at the time) to add Not Null
constraint to a column called Currency but it does not change the
attribute of the column.

IB_Connection1.ColumnAttributes.Add('COUNTRY.CURRENCY=REQUIRED=TRUE');
IB_Connection1.ColumnAttributes.Add('CURRENCY=REQUIRED');
IB_Connection1.ColumnAttributes.LinkValues['CURRENCY']:= IB_REQUIRED;

I appreciate you assistance.

Shahram

--- In IBObjects@y..., "Helen Borrie (TeamIBO)" <helebor@t...> wrote:
> At 06:08 AM 30-05-02 +0000, you wrote:
> >Hello,
> >
> >I like to change the ?Not Null? constraint for a field at run time
> >using the SchemaCache.Requried but have been unsuccessful.
> >
> >Is it possible to Add/Delete the FieldName and TableName to
> >SchemaCache.Requried or is this object only used to display Fields
> >that have the ?Not Null? Constraint.
> >
> >I appreciate you help.
>
> Don't attempt to meddle with the Schema Cache - it is not intended
for this.
>
> Set the REQUIRED ColumnAttribute of the column to False, at dataset
level
> or, if you need it multiple places, at the connection level.
>
> For more information, see the help text and also the "Working
with.." TI
> sheets on the TechInfo page.
>
> regards,
> Helen Borrie (TeamIBO Support)
>
> ** Please don't email your support questions privately **
> Ask on the list and everyone benefits
> Don't forget the IB Objects online FAQ - link from any page at
> www.ibobjects.com