🚀 go-pugleaf

Jorge Matos wrote in message <6e6j9o$ah414@forums.borland.com>...
>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
>
>
>

I figured it out, I used a parameterized query!

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

    q = new query()
    q.database = d
    q.sql =  "select * from table where myLogicalField  = :boolval"
    q.params["boolval"] = true
    q.active = true

    The above example works regardless if the BDE ALIAS is for DBASE or SQL
Server.