Re: International Boolean
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"
Re: International Boolean
Just declare a boolean
Dim blnVal as boolean
blnVal = True 'or blnVal= False
rs.Open "SELECT * FROM Table WHERE myfiled=" & blnVal, db, adOpenStatic, adLockOptimistic