Announcement

Collapse
No announcement yet.

Error parsing SQL sentences

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

  • Error parsing SQL sentences

    Hi all,

    I found that Mirth 1.7 has many problems parsing many complex SQL sentences like:

    SELECT tabla1.code+convert(char(8),(SELECT TOP 1 description FROM tablazzz WHERE zona=tabla1.code)) as total FROM XXX tabla1 LEFT JOIN YYY tabla2 ON tabla1.code=tabla2.code

    At this point Mirth is unable to parse "total" as a result of this sentence.

    Any hints,

    Ricardo Bernat

  • #2
    Re:Error parsing SQL sentences

    Try moving the SELECT to a database view and in Mirth change the SQL statement to use the view instead of the base tables.

    Hope this workaround helps!

    Comment

    Working...
    X