V4RB SELECT and SQL function question

Aaron Bratcher aaronbratcher at abdatatools.com
Sun Nov 16 14:07:28 CST 2003


Im trying to run this query in V4RB 1.9.8:

select personnel.recid, personnel.firstName, personnel.lastName from 
personnel where  upper(personnel.firstName) = 'AARON'

It gives me a 616 error: Mixed aggregate and normal functions.  I have 
no idea what that means.  I only have 1 function and I believe I am 
using it correctly.  Any ideas?

Thanks.

--
Aaron Bratcher
ab DataTools
http://www.abDataTools.com



More information about the Valentina mailing list