Announcement

Collapse
No announcement yet.

Selected fields and linked.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Selected fields and linked.

    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)

    Comment


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

      Comment


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

        Comment

        Working...
        X