Q:

Auto Detect Required Fields of TFDQuery in Delphi

I am using, in Delphi XE5, the TFDQuery component to insert and update records from a table in the PostgreSQL database. One drawback I encountered while adding the fields (persisting in DFM) was that it did not detect that some table fields are NOTNULL. The Component should have set the "Required" property of TFields to "True", but what happened was that all fields, including the primary key were set to "False". I would like to know if there is any specific configuration for this, whether it is a component BUG, or if it is an expected behavior.

A:

TFDAutoIncField doesn't have Required flag enabled (so even if you enabled ExtendedMetadata connection parameter, which is what you should do for purpose of persistent field definition, nothing changes). It is expected behavior.

