🚀 go-pugleaf

I use Intrabuilder + BDE4.5.

There is a problem with the default "false" value for the logical field
in dbase.

The default false value is x20 (" ")???
The assign false value is x46 ("F")
The assign true value is x54 ("T")

Try this script:
//////////////////////////////////////////
    Q = new Query();
     try
     {
       Q.sql = "DROP TABLE \"table1.dbf\"";
       Q.active = true;
       Q.active = false;
     }
     catch (Exception e)
     {
     }
     try
     {
       Q.sql = "DROP TABLE \"table2.dbf\"";
       Q.active = true;
       Q.active = false;
     }
     catch (Exception e)
     {
     }
     Q.sql = "CREATE TABLE \"table1.dbf\" (C CHARACTER(10), B1 BOOLEAN,
B2 BOOLEAN)";
     Q.active = true;
     Q.active = false;
     Q.sql = "CREATE TABLE \"table2.dbf\" (C CHARACTER(10), B1 BOOLEAN,
B2 BOOLEAN)";
     Q.active = true;
     Q.active = false;
     Q.sql = "INSERT INTO \"table1.dbf\" (C, B1) VALUES (\"TABLE1\",
FALSE)";
     Q.active = true;
     Q.active = false;
     Q.sql = "INSERT INTO \"table2.dbf\" (C, B2) VALUES (\"TABLE2\",
FALSE)";
     Q.active = true;
     Q.active = false;
     Q.sql = "SELECT A.C FROM \"table1.dbf\" AS A, \"table1.dbf\" AS B
WHERE A.B1 = B.B2 AND A.B2 = B.B2";
     Q.active = true;
     alert("You should see (one record) :" + Q.rowset.count());

/////////////////////////////////

Launch the designer and view the data in table1 and table2
The designer shows that the table1 contains the one record with the
following info "TABLE1", false, false     and table2 contains one record
with the following info "TABLE2", false, false.