Bug with revQueryDatabase 2.7.4 build 291

[Mark Wieder]

Robert-

Friday, December 15, 2006, 3:33:06 PM, you wrote:

> 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"

This is actually correct behavior. What you're doing is returning a
recordset id from which you can start to extract data. All the
revQueryDatabase() function is doing is getting you that far, and you
aren't getting any errors because you're connecting properly with your
database and don't have any syntax errors in your SQL statement. The
fact that the data represented by the recordset is empty is not
relevant. You would see an error if you specified a field that didn't
exist in the database or a if dbID2 didn't specify a currently open
database or some other such error.

If you use the recordset returned to you by the revQueryDatabase()
function in a revDatabaseColumnNamed() function call you will see that
it returns empty to you, but again no error.

-- 
-Mark Wieder
 mwieder at ahsoftware.net