Bug with revQueryDatabase 2.7.4 build 291

Robert Mann 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
wt_springcalc.year_model='" &
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"

ELSE
put curID into fld "error"
exit mouseUp

END IF

can someone test a sql statement that they know should return on non-number
to the revQueryDatabase and see what you get



Thanks
Robert Mann





More information about the Use-livecode mailing list