Menu

#111 TableInput.Filter:= 'OMIT = FALSE'; Recognizes FALSE as a field

Win32/Linux
open
nobody
None
5
2024-02-27
2024-02-17
David Allen
No

TableInput.Filter:= 'OMIT = FALSE'; returns an error: Unknown Field "FALSE"
This worked with BDE but throws this error with TDBF. OMIT is a field name in TableInput. TDBF seems to be recognizing FALSE as a field name rather than as Boolean FALSE.
Have I done something wrong or is boolean filtering not supported by TDBF?

Discussion

  • David Allen

    David Allen - 2024-02-18

    A workaround is to use OnFilterRecord instead as follows:
    Accept := DataSet.FieldByName('OMIT').AsBoolean = FALSE;

     
  • Paul Baker

    Paul Baker - 2024-02-27

    This seems to be a missing feature. There is no concept of a boolean constant - see TConstant in dbf_prsdef.pas.

     

Log in to post a comment.