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