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>
