V4RB SELECT and SQL function question

[Ruslan Zasukhin]

on 11/16/03 9:07 PM, Aaron Bratcher at aaronbratcher at abdatatools.com wrote:

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

Hi Aaron,

In Valentina 1.x functions cannot be used directly in SQL.
You need use BaseObject methods.

Remember? :-)

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------