[pilot-db-list] Problem with Boolean fields and filter.

[Ship M <sh...@ho...>]

Hi

Thanks for a great program, and for making I free, I deeply appreciate it.

And now the question I have. I have some “problems” working with Boolean 
fields and filter.

Background - I have made at Pilot-DB over Hugo and Nebula award winners, 
here I use Boolean fields to mark if the book have won the Hugo award, the 
Nebula award and if I have the book.

If I want to find the books I don’t have, and use the icon (Finds String) - 
entering 0 at the string and chose “Have the Book” Field in Search, it works 
fine, I get a list of the books I don’t have.

When I make a filter to do the same, using the following script (and %7 0) 
it returns an empty list why???? What am I missing her???.

If I change the script to (and %7 1) it works fine, it returns a list of the 
books I have.

I have found out that using the script (! %7 1) works? This returns a list 
of the books I don’t have. What value dose a Boolean field have when it is 
off.

Here is some Systeminfo if you need it:

Pilot-DB version 1.1.0 (14 Nov 2003)
Running on a Palm Vx
With Palm OS 3.5.3
And 6392K Free Memory

Fields in the database:
Author, last name (string)
Author, first name (string)
Title (string)
Publishing year (Integer)
# Book in series (Integer)
Hugo winner (Boolean)
Nebula winner (Boolean)
Have the book (Boolean)

Once again thanks for great program.

In advance thank you and Have a nice day :-)

Ship Moller
Copenhagen, Denmark

_________________________________________________________________
Få alle de nye og sjove ikoner på Ilovemessenger 
http://ilovemessenger.msn.com