--- Robert Mann <[EMAIL PROTECTED]> wrote: > 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 > wt_springcalc.year_model='" & > gyearmodel & "' curID should not be a number? > > > 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 > > > What happens is curID is returned as a number then > when the > revDatabaseColumnNamed(curID,"fr_mx_multiplier") > into fld "frmxm1" executes > it puts ”revdberr,invalid column number” in the fld > and then rev shuts down > > Not sure where I have gone wrong? > > > Thanks > Robert Mann >
Hi Robert, The above looks correct to me, and I've used this approach for ages to fetch data and extract individual columns. And the RevDB library should definitely not crash Revolution. A few things to check: - did you use the correct column name? (use the function 'revDatabaseColumnNames' to display a list) - are there any results in your record set? (use the function 'revNumberOfRecords' to find out - beware that this doesn't work for ODBC databases at the moment) You may want to file a bugzilla report that this leads to a crash. Make sure to send along the crash report so they can try and figure it out. Hope this helped, Jan Schenkel. Quartam Reports for Revolution <http://www.quartam.com> ===== "As we grow older, we grow both wiser and more foolish at the same time." (La Rochefoucauld) __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ 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