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 _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
