Page 1 of 1

TMyQuery: property 'Required' not set automatically with MySQL 5.0

Posted: Fri 16 Dec 2005 21:25
by Hans
Hi,

I use the latest MyDac with MySQL 5.0. I wonder why table fields are not set to 'Required' aqutomatically in the fieldlist of e.g. a TMyQuery. Is this a bug or do you have to set this propety manually?
Is this property together with the onvalidate the right way to chek if all required fields are filled with values before you do a post?

best regards,
Hans

Posted: Mon 19 Dec 2005 10:24
by Ikar
Just set TMyQuery.Options.Required to True. Consider setting AUTOINCREMENT fields.

> Is this property together with the onvalidate the right way to chek if all
> required fields are filled with values before you do a post?

This is controversial point. It's too difficult to have a well-defined answer.