AW: V4RB SELECT and SQL function question

[Florian Bogeschdorfer]

If you want to find all incidents of first name = AaRon OR AarON etc. you
might as well use the LIKE option.

Florian

 

> -----Ursprüngliche Nachricht-----
> Von: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] Im Auftrag von 
> Ruslan Zasukhin
> Gesendet: Sonntag, 16. November 2003 22:05
> An: valentina at lists.macserve.net
> Betreff: Re: V4RB SELECT and SQL function question
> 
> 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
> -------------------------------------------------------------
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina