Hi I have this same element running successfully in a form.
> The mySQL database, which I use for storing data allows a select syntax as > follows: SELECT CONCAT(FamName, ", ", FirstName) FROM Komponisten Have you tried with single quotes instead of double quotes around the comma? It is always tricky to get the correct quotes... select concat(FamName, ', ', FirstName) from Komponisten This works for me. My query: SELECT "Person1"."PId", concat(Name, ', ', Vorname) as "Fullname", [...] FROM "Person" "Person1" [...] Yep, I do have double quotes around the field names and no quotes in the concat. Marco ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Hk-classes-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
