Page 1 of 1
[Solved] Concatenation in "Link slave fields"
Posted: Thu Jun 04, 2020 5:01 pm
by charlie.it
Hi everyone,
in a Form the concatenation "Surname||' '||Name" between mainform and subform in Form Properties "Link slave fields" does not work.
Is there another way of writing it?
Thank you.
Re: Concatenation in "Link slave fields"
Posted: Thu Jun 04, 2020 5:17 pm
by Villeroy
Content type: SQL
Content: SELECT *, "Surname"||' '||"Name" AS "Concat" FROM "Personale"
Link slave fields: "Concat"
Re: Concatenation in "Link slave fields"
Posted: Thu Jun 04, 2020 5:29 pm
by charlie.it
I had tried that too, but it didn't work. Obviously I was wrong. Thanks so much.
Re: [Solved] Concatenation in "Link slave fields"
Posted: Thu Jun 04, 2020 6:44 pm
by Villeroy
If you want to match "Carl" with forename *carl* OR with surname *carl*, you can also use a parameter query:
Code: Select all
SELECT * FROM "Personale"
WHERE UPPER("Surname") LIKE '%' || :pFilter || '%'
OR UPPER("Forename") LIKE '%' || :pFilter || '%'
Master Field: Filter (field of parent form)
Slave Field: pFilter (named parameter :pFilter)
If your field types are VARCHAR_IGNORECASE, you may drop the UPPER function.