[Solved] Concatenation in "Link slave fields"

[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.

[Villeroy]

Content type: SQL
Content: SELECT *, "Surname"||' '||"Name" AS "Concat" FROM "Personale"
Link slave fields: "Concat"

[charlie.it]

I had tried that too, but it didn't work. Obviously I was wrong. Thanks so much.

[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.