you probably need to trim your field.
theSQL="select * from TRIM(casedata) where referralstatus='true' "
cause right now you're comparing 'true' to 'true ' notice the space...:-)
----- Original Message -----
From: "Joseph" <[EMAIL PROTECTED]>
To: "'REALbasic NUG'" <[email protected]>
Sent: Wednesday, August 16, 2006 10:04 AM
Subject: SQL equal boolean
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>
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.10.10/419 - Release Date: 8/15/2006
_______________________________________________
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>
