Selected fields and linked.

Applications Grid / Reports
#1

Hi I have a customer_id from a grid with which I make a double select in the customer table in this way:

SELECT sc_concat (surname, first name)
FROM dati_persona
WHERE id = {} id_persona
ORDER BY name, first name

selection works well
only that the result that the press is as follows:
FirstnameLastname

how can I make sure that the press in this way:

Name - Surname

#2

you must add that separator: sc_concat (surname,’ - ’ ,first name)

#3

Hello, would you be kind enough to show me where I have to put this code for the grid and from ???

#4

Excuse me, I managed to solve, I realized that the separation must be in the selection. Thanks so much.