Thanks, Marco
In my application, there are several queries that use the approach that you
mention, and they work fine. The only difference: I do not put double quotes
around the fieldnames. Not necessary for me, as I am not using ä,ö and üs in
the names.
My problem is the ComboBox. This allows only a single fieldname, and no SQL
expression. I hope that Horst Knorr will put this on the todo list for future
implementation. It would automatically solve another Combobox problem about
which I will be preparing another mail shortly.
Egbert
Marco Wirz <[EMAIL PROTECTED]> wrote: 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
---------------------------------
For ideas on reducing your carbon footprint visit Yahoo! For Good this month.-------------------------------------------------------------------------
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
