You could say (this has always worked for me)
>>>>> "SELECT myField FROM myTable WHERE myBooleanField"
Then again, on my machine (same setup as yours), it also works to say
>>>>> SELECT myField FROM myTable WHERE myBooleanField=1"
and
>>>>> SELECT myField FROM myTable WHERE myBooleanField='1'"
Are you working with a database which may have been populated by an
older version, where 'true' may have been used instead of '1'?
On Jun 29, 2007, at 1:14 PM, realbasic-nug-
request at lists dot realsoftware dot com wrote:
> On 6/29/07, keatk at comcast dot net <keatk at comcast dot net> wrote:
>> I create the table in the IDE, use DatabaseRecord to create new
>> records and RecordSet to modify them istead of raw SQL and
>> DB.SQLExecute. With all that, selects using 0 and 1's for booleans
>> work fine.
>>
>> -------------- Original message --------------
>> From: "Dennis Birch" <dennisbirch at gmail dot com>
>>
>>> On 6/28/07, Karen wrote:
>>>>
>>>> On Jun 29, 2007, at 1:01 AM, Dennis Birch wrote:
>>>>
>>>>> "SELECT myField FROM myTable WHERE myBooleanField = 1"
>>>>
>>>> 1 and 0 work for me for true and false just fine.
>>>
>>> They clearly do not work for me. Can you describe your setup in more
>>> detail? Perhaps I'm doing something wrong with the way I create the
>>> table or populate the records.
>
> I create my tables in code, and do everything else the same as you
> described. What RB version and OS are you working in? I'm running into
> this problem with RB 2007R3 in Mac OS 10.4.10.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
|