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