Home› General
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Filtering for blanks or nulls?

rbuserrbuser
edited January 2005 in General
In my application, if I enter data to a cell, save and then delete the cell
data again, the cell is not being seen as blank or null.

In the Data-Search tab I have tried to filter my report to only records
where WORKORD.FINAL_CLEARENCE is empty.

Field Op Value
---------------------------------------
Eqn 1 WORKORD.FINAL_CLEARENCE =
Eqn 2 WORKORD.FINAL_CLEARENCE BLANK
Eqn 3 WORKORD.FINAL_CLEARENCE = ''

None of these 3 search criteria will find this record.
What do I need to do to get an edited blank record?

Thanks
Red

Comments

  • nicociziknicocizik
    edited January 2005
    Hi Red,

    Which database are you connecting to? Which connectivity are you using? Is
    the Final_Clearance field a string field? Dade simply generates the SQL
    that gets sent to your database. You might try manually entering the
    generated SQL into your database and see if you get the expected results.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.