Menu
▾
▴
[pilot-db-list] Problem with Boolean field.
|
From: Ship M <sh...@ho...> - 2004-04-21 02:03:07
|
<html><div style='background-color:'><DIV class=RTE> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman"> <o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">Thanks for a great program, and for making I free, I deeply appreciate it.<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman"> <o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">And now the question I have. I have some problems working with Boolean fields and filter.<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman"> <o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'">Background - I have made at </SPAN><SPAN lang=EN-GB style="mso-ansi-language: EN-GB">Pilot-DB</SPAN><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"> 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.<o:p></o:p></SPAN></FONT></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman"> <o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">If I want to find the books I dont 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 dont have.<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman"> <o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">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???.<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman"> <o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">If I change the script to (and %7 1) it works fine, it returns a list of the books I have.<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman"> <o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">I have found out that using the script (! %7 1) works? This returns a list of the books I dont have. What value dose a Boolean field have when it is off.<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman"> <o:p></o:p></FONT></FONT></SPAN></P><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman"> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'">Here is some Systeminfo if you need it:<o:p></o:p></SPAN></P><o:p></o:p></FONT></FONT></SPAN> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman"> <o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB"><FONT size=3><FONT face="Times New Roman">Pilot-DB version 1.1.0 (14 Nov 2003)<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">Running on a Palm Vx<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">With Palm OS 3.5.3<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">And 6392K Free Memory<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB"><FONT size=3><FONT face="Times New Roman"> <o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">Fields in the database:<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">Author, last name (string)<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">Author, first name (string)<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">Title (string)<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">Publishing year (Integer)<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman"># Book in series (Integer)<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">Hugo winner (Boolean)<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">Nebula winner (Boolean)<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">Have the book (Boolean)<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman"> <o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">Once again thanks for great program.<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman"> <o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">In advance thank you and Have a nice day :-)<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB style="mso-ansi-language: EN-GB; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman"> <o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=DE style="mso-ansi-language: DE; mso-fareast-font-family: 'MS Mincho'"><FONT size=3><FONT face="Times New Roman">Ship Moller<o:p></o:p></FONT></FONT></SPAN></P><SPAN lang=DE style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-ansi-language: DE; mso-fareast-font-family: 'MS Mincho'; mso-fareast-language: DA; mso-bidi-language: AR-SA">Copenhagen, Denmark</SPAN></DIV></div><br clear=all><hr>Find din nye bolig med <a href="http://g.msn.com/8HMADADK/2743??PS=">MSN Bolig</a> </html> |
