Hi Team,
   Thought I had a bug in my program until I tried this.
   Win 10, D10.3, EDB 2.30b1.
   Not pointing the finger anywhere att.
   Fire up D10.3, New VCL Forms project, add Engine, Session, Database Table, Datasource and DBGrid.
   Hook them all together as appropriate, Local mode, to a table that has a boolean field.
   Turn them all 'on' and see the data in the DBGrid.  No problem.  Hopefully the Boolean field has some True and False
values.
   Now, in the EDBTable, set the filter to xxxxx=True, where xxxxx is obviusly the boolean field.
   Set Filtered to True.  All good, can see all the records with the boolean field True.
   Now set the Filter to xxxxx=False ensuring Filtered is True.  No records show.
   No set the Filter to xxxxx<>True ensuring Filtered is True.  Now the False records show. ???

   Is this just my installation or can someone duplicate it please?

Regards & TIA,
Ian
   

Ian,

I've just tested it and I can't see what you are seeing - everything is working as expected.

--
Fernando Dias
[Team Elevate]

Fernando Dias wrote:

> Ian,
>
> I've just tested it and I can't see what you are seeing - everything is working as expected.

Hi Fernando,
   Thanks for testing.  D10.3 I take it?
   Hmm.  Something is different then because it wasn't an issue in D10.2.3.  Sigh!

Regards & Tks again.
Ian

Ian,

<<Something is different then>>

You could perhaps post a demo database with that table in the binaries...

--
Fernando Dias
[Team Elevate]

Fernando Dias wrote:

> Ian,
>
> <<Something is different then>>
>
> You could perhaps post a demo database with that table in the binaries...

Hi Fernando,
   It doesn't matter which table I use, there are 32 tables of which 18 have one or more boolean fields and all I have
tested are exhibiting the same issue.

Ian

Keeping the original edbmgr aside, it works OK, I just rebuilt in D10.3.
When I try the filter blocked=False, or any Boolean field in any of the tables, I get the same result.

Just in case it was D10.2.3 I tried a DBISAM database/table.  True & False Filter works fine there.

The thicken plots....
I created a new test database and exported/imported one of the tbales I have been playing with.
Opened the new databse/table in my test app and all good!!!
So, the conclusion here is that it is something with the databse/table itself.
Not sure how to tackle it from here.

On 1/10/2019 10:41 PM, Ian Branch wrote:
> So, the conclusion here is that it is something with the databse/table itself.
> Not sure how to tackle it from here.

Zip it and send a copy of the whole thing (database+table+catalogue) to
Tim using the support email - he can likely take a look and tell you
what's going on.

Raul

Hmmm.  I created another Test database and used the existing Users table SQL to create a new table in the new database.
With the structure now created I thought to simply copy the original Users table into the new database directory.
When I tried to open the table in the new database I get the following error.
"ElevateDB Error #100 There is an error in the metadata for the table Users (The internal structure does not match the
structure in the catalog)"
If I export the original table to a .csv and import it into the new all is good.