It appears that you have to say
"SELECT ... WHERE upper(active)='TRUE' ..."
If you converted to the newer format where True is stored as '1' and
False as '0', you could say
"SELECT ... WHERE active ..."
So, to select those where active is True (ie, represented as either
'1' or 'true' in the db file), you would have to say
SELECT ... WHERE active OR upper(active)='TRUE' ..."
This is surely a misfeature that will be corrected in the future.
Michael
On Sep 1, 2006, at 6:29 PM, Paul Dobbs <[EMAIL PROTECTED]> wrote:
I tried that. I still get the error. Maybe it's because the data in
the database still has "true' in it. Do I need to convert it somehow?
On Sep 1, 2006, at 4:18 PM, Michael Sharpe wrote:
Change the sql to ..where active... instead of ...where
active='true'...
Boolean columns now represent True by either the string 'true' or
the number 1.
Michael
On Sep 1, 2006, at 1:04 PM, "Dobbs, Paul" <[EMAIL PROTECTED]>
wrote:
Subject: Database program won't run in IDE
From: "Dobbs, Paul" <[EMAIL PROTECTED]>
Date: Fri, 01 Sep 2006 13:22:25 -0500
I have a database program that I created a year of so back which has
developed a bug. The program (.exe file) runs and displays the
database
but won't allow me to add records. When I try to run the program
in the
IDE, it won't even load the database. I get an error in the routine
below at the select. I seem to remember something in the release
notes
about boolean values having changed, but I can't seem to find it.
Does
anyone know what my problem is and how to correct it?
Dim RS As RecordSet
//get list of active names for menu
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
_______________________________________________
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>
