Thanks Tim, Roy and Uli

OK, great, problem solved.

As to how the Required property got set - I'm not sure.

The database has been in existence from BDE, DBISAM2, DBISAM3 and now EDB.
I don't think that I would have deliberately set the Required property - why
would I when it was the DBMS's job to do that?

Presumably (sometime in the mists of time and Delphi 2or3) I double-clicked
the table and ctrl+F'd to get the fields.

Which leads to the next question - should I sweep through the system and
remove "required = true" everywhere?

I have 119 instances in 14 forms - I can't think of any reason not to do so.

Cheers

Jeff
--
Jeff Cook
Aspect Systems Ltd
www.aspect.co.nz

"Roy Lambert" <roy@lybster.me.uk> wrote in message
news:E03045B8-1AFA-4ED4-921E-D16B0F152CFF@news.elevatesoft.com...
> Uli
>
>>Since the field definitions didn't macht (Ansistring vs. Widestring) I
>>deleted the fields and recreated them.
>>That's why the required property was not set in the ANSI version.
>
> That would explain it your part in it Now all we have to find out is
> why Jeff got Required in there to start with.
>
> Roy

Jeff,

<< Which leads to the next question - should I sweep through the system and
remove "required = true" everywhere? >>

Yes.  It will cause you problems if you still have some in there.

<< I have 119 instances in 14 forms - I can't think of any reason not to do
so. >>

Just please don't do the update manually - loading the forms/data modules in
code, updating them, and re-saving them is the trick.  If you want a code
sample, let me know.

Tim Young
Elevate Software
www.elevatesoft.com