Announcement

Collapse
No announcement yet.

[SOLVED] Grid lookup and string concat failed

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

  • [SOLVED] Grid lookup and string concat failed

    It's been 3 years ago since I evaluated Scriptcase and here I am, evaluating it again.

    I've just downloaded the version 8 trial.
    Created a grid, then select fields, turn it into automatic lookup.

    SQL generated is :
    SELECT sc_concat(firstname, middlename)
    FROM "public".userhdr
    WHERE id = {createdbyid}
    ORDER BY firstname, middlename

    and no result shown in the column.
    I've also tried Postgresql's syntax SELECT firstname || lastname..., result is still empty.

    But if I only select 1 column, like SELECT firstname...., the column shows correct value in the grid.

    Any help please ?
    Thank you in advance

  • #2
    found out it is cause by lastname field has null value.
    If field lastname not null, then the column in grid displays correct values

    case closed

    Comment


    • #3
      Hello,

      Thanks for your feedback.

      regards,
      Bernhard Bernsmann

      Comment

      Working...
      X