I have a realSQL database that is populated, in part, with Boolean fields that obtain their value from checkboxes. When I query the whole database and fill a listbox with the string values everything looks fine. The Boolean values are either true or false. However if I put together a sql statement that tests for equality like so:
theSQL="select * from casedata where referralstatus='true' " I don't get a database error but it finds nothing! HOWEVER, if I put the statement together like this: theSQL="select * from casedata where referralstatus<>'false' " It works perfectly. Why is this so?!? Obviously I have a solution but I'm puzzled nonetheless. Any idea what I'm missing? ~joe RB2006r3 WinXP _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
