Re: [pilot-db-list] "Finding" on Boolean Field

[<sho...@rc...>]

When I ask DB to find those records in which the boolean field is "1", 
it displays all records in the DB. The only difference between looking 
for "yes" or "true" is the the records are sorted by that field: the 
checked items together and then the unchecked.  I want it to show only 
the checked records.



On Apr 30, 2005, at 9:19 AM, Yedidyah Bar-David wrote:

> On Sat, Apr 30, 2005 at 08:57:41AM -0400, sho...@rc... wrote:
>> I have a DB with a boolean field and want to 'find' only those records
>> where it is checked.
>>
>> I've tried "Where the value of --- is 'yes'," I've tried 'true'. The
>> only thing that seem to have an effect is looking for where the value
>> is 0 or 1. But that only sorts: it does not isolate the 'checked'
>> items.
>
> I do not understand. What do you do and what happens?
> Searching for 0 or 1 on boolean fields does work for me as expected.
>
>>
>> I'm using v. 1.1.3 on a Tungsten E
>>
>> I've only just joined the list: please forgive me if this matter has
>> already been covered.
>
> Welcome.
> -- 
> Didi
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: NEC IT Guy Games.
> Get your fingers limbered up and give it your best shot. 4 great 
> events, 4
> opportunities to win big! Highest score wins.NEC IT Guy Games. Play to
> win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=20
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
>