At 02:49 AM 28/07/2003 +0000, you wrote:

>I cant insert a record for a reason that seems to be so weird. It
>always says "ProduceDate field is a required field but I have input
>the date their. The ib_datetimepicker has a datasource set
>to "Produce" table and its data field to "ProduceDate".
>
>I have made a careful check on how I set up the components, I think
>everything is right. I wonder what is causing this.
>
>I have set the column attributes ofthe "ProduceDate" field to
>required. but in the orignal database design it accept nulls. But
>when I uncheck the required attributes. The error message doesn't
>appear but when I check the record in IB Expert, it has a null value
>on the "ProduceDate". It seems that somethings wrong with my
>ib_datetimepicker. So I drop it and create another one, but it didn't
>fix my problem.
>
>The other field are doing fine. I wonder what wrong with this field.

You are leaving out more than you are telling. You don't mention what you
are doing about connection your TIB_DateTimePicker to the TIB_Datasource.

Are you by some chance trying to use TIB_DateTimePicker with the VCL
TDatasource and a TIBOQuery or TIBOTable? (That won't work). I'm
suspicious that this might be the mistake you are making, since you refer
to a "table" not a "query". (IBO native data access doesn't have a table
component...)

How are you linking the DataField to the column? are you selecting from
the list or relying on typing it in manually?

Show us the relative excerpts from your DFM. It will answer the unanswered
questions.

Helen