International Boolean

[masonad]

When I make a call to a recordset with "select * FROM Table WHERE myfield = " & True I get an error from non-English computers. I then tried "select * FROM Table WHERE myfield = " & CBool(-1). I still get the error of too few parameters. These both work fine on English setting computers. What works internationally?

[Thread1]

it depends on the DBMS but mostly a value 1 and 0 represents true and false respectively. so i thought you can write the statement as..?

"SELECT * FROM Table WHERE myfield = '1'"
or
"SELECT * FROM Table WHERE myfield = 1"
or
"SELECT * FROM Table WHERE myfield"

"SELECT * FROM Table WHERE myfield = '0'"
or
"SELECT * FROM Table WHERE myfield = 0"
or
"SELECT * FROM Table WHERE NOT myfield"

[Phoney]

Just declare a boolean

Dim blnVal as boolean

blnVal = True 'or blnVal= False


rs.Open "SELECT * FROM Table WHERE myfiled=" & blnVal, db, adOpenStatic, adLockOptimistic