pilot-db-list

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

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

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'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.

LBG

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

[<di...@ta...>]

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

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

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

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

> I do not understand. What do you do and what happens?

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
>

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

[<di...@ta...>]

On Sat, Apr 30, 2005 at 06:09:43PM -0400, sho...@rc... wrote:
> 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.

Well, as I said, it does work for me.
Can you try with a small test db and email it (to me, not the list)?
Also, what version of pilot-db (sorry if you already wrote that)?
-- 
Didi