Bug with revQueryDatabase 2.7.4 build 291
robmann at gp-racing.com
Fri Dec 15 18:33:06 EST 2006
I am having a problem with revQueryDatabase returning a number when it
should not be I think?
In the following sql statement if there is no data in column
gyearmodel & "' curID should not be a number? and it is
put "SELECT * FROM wt_springcalc WHERE wt_springcalc.year_model='" &
gyearmodel & "' and wt_springcalc.company_id='1'" into theSQL
put revQueryDatabase(dbID2, theSQL) into curID
put curID into fld "curIDnum"
IF curID is a number THEN
put revDatabaseColumnNamed(curID,"fr_mx_multiplier") into fld "frmxm1"
put curID into fld "error"
can someone test a sql statement that they know should return on non-number
to the revQueryDatabase and see what you get
More information about the Use-livecode