🚀 go-pugleaf

Hello,

    I exported a dbf table that has a boolean field to SQL Server 6.5 and I
noticed that it converted the DBASE Logical type to a SQL Server Bit field
type.  The problem I have is that I have a query object in VDB 7 that looks
like this "select * from table where mylogicalfield  = true"  this works if
the table is a DBASE table but when I try it against the SQL Server version
of the table, I get a BDE error message "Database Engine Error: Could not
find object".  If I change my query to be "select * from table where
mylogicalfield = 1" then it works.

I could write code that checked the "driverName" property of my database
object and then I could chose the appropriate query sql string , for example

    d = new database()
    d.databaseName = "BDE ALIAS FOR DBASE TABLE"
    d.active = true

    q = new query()
    q.database = d

    if d.driverName = "DBASE"
        q.sql = "select * from table where field  = true"
    else
        q.sql = "select * from table where field  = 1"
    endif

    q.active = true


The above code would still work when I change the databaseName property to a
BDE alias for SQL Server, but I think this is a kludge and I wonder if
theres a better solution to this problem.  I also can't believe I would be
the only one to encounter this problem and I hope someone else has a better
solution to this.  I'm hoping there is a better way to phrase my sql
statement so that it would work regardless of which BDE alias my database
object is using.

Thanks in Advance
Jorge Matos