I can certainly understand what you are saying. In the database that I am working with, which has values written by both the old and new standards, I am having to write "xx or xx = 'true'" for filter for true and 'not xx and xx != 'true'" to filter for false.
Next time I design a database, I'll do it your way! Paul Dobbs Software Engineer, Staff Lockheed Martin Missiles and Fire Control Phone (972) 603-1244 Fax (972) 603-2017 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dr Gerard Hammond Sent: Tuesday, September 05, 2006 8:14 PM To: REALbasic NUG Subject: RE: Database problem This is exactly why I stopped using Booleans in SQlite and REAL SQL dbs Consider defining it as an integer, 0 = no/false 1 = yes/true You get the added benefit of a very portable db model. SQLite, with it's silly manifest typing, can bite you if you move to a different backend. For me, integers work great for very little extra work. At 8:43 AM -0500 5/9/06, Dobbs, Paul wrote: >Same result. > > >Paul Dobbs >Software Engineer, Staff >Lockheed Martin Missiles and Fire Control Phone (972) 603-1244 Fax >(972) 603-2017 > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >Marco Bambini >Sent: Tuesday, September 05, 2006 8:16 AM >To: REALbasic NUG >Subject: Re: Database problem > >Try this: > >... where active = 'True' > >--- >Marco Bambini >http://www.sqlabs.net >http://www.sqlabs.net/blog/ > > > >On Sep 5, 2006, at 3:10 PM, Dobbs, Paul wrote: > >> I have a database program which I created some time back to track >> access to a secure area. The program (last compiled in April) has >> developed a problem in that it will not add new records. All other >> operations work fine. When I trie to run the program in the IDE so >> that I can look at the problem, it will load the database. >> >> The problem occurs in the following code: >> RS = DB.SQLSelect("select fname, lname, empno from people where >> active = 'true' order by lname, fname") >> If DB.Error Then >> ReportError "Error while getting names: " + DB.ErrorMessage, Error >> Else >> While Not RS.EOF >> Names.Append RS.Field("fname").StringValue + " " + >> RS.Field("lname").StringValue >> EmpNos.Append RS.Field("empno").IntegerValue >> RS.MoveNext >> Wend >> End If >> >> I always get the "Error while getting names" message. >> >> I found the following in the release notes for RB2006 R2: >> >> BooleanColumn (in RecordSets and DatabaseRecords) now write a '1' >> for true and a '0' for false into table fields. >> Before they wrote the strings 'true' and 'false >> >> And the following in the release notes for R3: >> REAL SQL Database: Boolean fields are now more pedantic about what >> they expect when using DatabaseField. BooleanValue. Previously, '0' >> and 'false' were treated as False and anything else was treated as >> True. >> Now, '0' and 'false' are treated as False and '1' and 'true' are >> treated as True. The behavior of any other values is undefined if >> retrieved using DatabaseField.BooleanValue. >> DatabaseField.StringValue, > >> on the other hand, should be able to retrieve the original data if >> it can't be identified as a boolean. If the REAL SQL Database can >> identify the value as a boolean, however, then False will always >> return 'false' and True will always return 'true', regardless of how >> those values are stored in the database. This is a side effect of the >> way in which database engines interact with the database API in the >> REALbasic framework. Note that the change to >> DatabaseField.BooleanValue should only be an issue if you are trying >> to store non-boolean data in a boolean column. >> >> Neither seems to tell me just how to fix my problem. I have tried >> "where active = 1", "where active = '1'" and "where active" and all >> give the same results as "where active = 'true'". How can I fix this >> problem so that I can go looking for the original problem? >> >> Paul Dobbs >> Software Engineer, Staff >> Lockheed Martin Missiles and Fire Control Phone (972) 603-1244 Fax >> (972) 603-2017 >> >> _______________________________________________ >> Unsubscribe or switch delivery mode: >> <http://www.realsoftware.com/support/listmanager/> >> >> Search the archives of this list here: >> <http://support.realsoftware.com/listarchives/lists.html> > >_______________________________________________ >Unsubscribe or switch delivery mode: ><http://www.realsoftware.com/support/listmanager/> > >Search the archives of this list here: ><http://support.realsoftware.com/listarchives/lists.html> >_______________________________________________ >Unsubscribe or switch delivery mode: ><http://www.realsoftware.com/support/listmanager/> > >Search the archives of this list here: ><http://support.realsoftware.com/listarchives/lists.html> -- Cheers, Dr Gerard Hammond MacSOS Solutions http://www.macsos.com.au _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html> _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
