Announcement

Collapse
No announcement yet.

Close bracket symbol caused error in SQL statement

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

  • Close bracket symbol caused error in SQL statement

    Close bracket symbol caused error in SQL statement.

    bug.JPG

    bug2.JPG

  • #2
    Try with single quotes ' )'
    /Giuseppe

    Professional Scriptcase Services
    Some Customers opinions

    Comment


    • #3
      Don't use the provided sc_concat() macro, use the db function instead and it's working.

      jsb

      Comment


      • #4
        Hello,

        As JSB hinted, use the db function instead of sc_concat().

        Issue reported to our bugs team.

        regards,
        Bernhard Bernsmann

        Comment


        • #5
          Hello,

          the two solutions said on this topic, some of them solve your problem? One was to use only single quotes, and the other was to use the concat your database.
          Thank you.
          Best regards,
          Thomas Soares.
          ScriptCase International.

          Email: t.soares@scriptcase.net
          Visit our Blog: http://www.scriptcase.net/blog/
          Visit out fan page: http://www.facebook.com/Scriptcase

          Comment

          Working...
          X