Re: [pilot-db-list] Re: Pilot-db-list digest, Vol 1 #994 - 1 msg

[Craig B. <cbo...@gm...>]

On 30-Apr-05, at 5:57 AM, 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'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.

It's always worked for me, both in the find and in the filter searches.
Let me ask an obvious question, you are selecting the correct field 
from the drop down list, rather than leaving it as "all fields"?

Lastly, you may try an alternate approach.  You are able to use 
equations in the find fields as well.
So lets say you have a boolean field as field 5.  You can search for 
checked values in field 5 with this:
(seq %5 1)

Which is to say  the string in field five equals the string "1".  You'd 
leave the Seach field in the Find dialog box set to "All Fields" since 
you're specifying the field in the equation.

Anyway, there are lots of useful possibilities for equations in filters.

-Craig Bowers