problem with concat() in query

[Frank Schima]

Hi Chris,


On Oct 7, 2005, at 10:34 AM, Chris Sheffield wrote:

> Shouldn't this query work in Valentina 1.x:
>
> SELECT CONCAT(LastName, ', ', FirstName), RecID FROM Teachers WHERE  
> SETeacher=0 AND Type=0 ORDER BY LastName
>
>
> I'm getting error "603 field not found" when trying to run it.   
> I've double-checked all field names and all are correct.  Is there  
> something I'm not doing correctly?
>
> I'm using Revolution, btw.

No. You must put that concat statement in a field method in the table  
and then SELECT that field method. You need Val 2.x to run SQL like  
that. Even with 2.x, you might need to SELECT LastName by itself also  
to ORDER BY it.


Best regards,
Frank Schima