| Subject | Re: Default value for Required property in TIBOQuery |
|---|---|
| Author | |
| Post date | 2018-10-24T10:43:15Z |
This sound a bit strange. I do not suffer from your problem.
I just tested a simple TIBOQuery. In the IBO Design-time Query editor i can see (under the "Fields" Tab) that only PRJ_ID and PRJ_DATE_STARTING do not have "NULL". So i put a button on the form and assign this code:
for I := 0 to IBOQuery1.Fields.Count - 1 do
Memo1.Lines.Add(IBOQuery1.Fields[I].FieldName + ' Req: ' + BoolToStr(IBOQuery1.Fields[I].Required, true));
And i get the following result:
PRJ_ID Req: True
PRJ_READABLE Req: False
PRJ_NAME_SV Req: False
PRJ_DATE_START Req: True
PRJ_DATE_ENDING Req: False
So... Some things to check:
Version of IBO, stable, latest?
Version of Delphi (the TDataSet classes have been updated during the releases of newer Delphi versions).
Check out the TIBOQuery.FieldOptions property.
Right-click on your Query and choose "Edit Query". In the "ColumnAttributes" tab you have the option to override the required flags as IBO reads them from the database schema.
Also check out the way you are using the SchemaCache. Perhaps just clearing out the caches will help.
HTH,
Regards,
/Dany (user of IBO, not official support)