Announcement

Collapse
No announcement yet.

sc_concat fails in MS Access when more than two parameters

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

  • sc_concat fails in MS Access when more than two parameters

    Please refer to this post:
    http://www.scriptcase.net/forum/show...ight=sc_concat

    Essentially, I see that when using MS Access, sc_concat will only work with two parameters. By example

    sc_concat(f1, f2) as f3 will work
    sc_concat(f1, " ", f2) as f3 or sc_concat(f1, f2, f3, f4) will fail as an unrecognised function in ODBC.

    MS Access syntax, i.e. f1 & " " & f2 & " " & f3 AS NewField provides a work around. However, now the project is no longer portable between databases.

    Thanks
    The GuiGuy
    ... from Down Under

  • #2
    Hello,

    Issue reported to our bugs team.

    regards,
    Bernhard Bernsmann

    Comment

    Working...
    X