Announcement

Collapse
No announcement yet.

bug : problem in n-n relations

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

  • bug : problem in n-n relations

    n-n relationships:
    when using a global variable between two single quoted , at the time of execution
    the query sent to the database omitted the second single quoted
    example:
    select FICHINVE_CODEBARR, FICHINVE_DESI
    from TFICHINVE
    WHERE FICHINVE_DOSS = '[DOSSCOUR_CODE]'

    query set to db:

    select FICHINVE_CODEBARR, FICHINVE_DESI from TFICHINVE WHERE FICHINVE_DOSS = '08


    my scriptcase version in : 8.00.0016
    database: sql server

  • #2
    Hello,

    Have you tried to use no quotes?

    Have you tried to space your quotes?

    ' [globalVar] '

    regards,
    Bernhard

    Comment


    • #3
      Hello,

      Try without quotes, or protect with backquotes `[global]`

      Waiting your tests.

      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