Announcement

Collapse
No announcement yet.

[SOLVED] Problem grid - SQL statement with global variables

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [SOLVED] Problem grid - SQL statement with global variables

    when you have global variables in the WHERE
    Example:
    SELECT numfact, date, code, numfact FROM facturas WHERE value = [glnumfact]

    When I run the following error displays:

    Parse error: syntax error, unexpected T_STRING, expecting ']' in C: \ NetMake \ V7 \ wwwroot \ ScriptCase \ app \ xxxxxx \ grid_nnnnn\ grid_nnnnn_grid.class.php on line 367

    Please your urgent assistance

  • #2
    The missing ] will probably be the problem ... In your post is it, but in your code? I use global variables in where-clauses constantly ...
    Best regards: - Reinhard -

    I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

    Comment


    • #3
      Yes, I use this construction continuously too, but I have not upgraded yet to 7.1 So it might be an issue or perhaps the global variable is containing a '[' ?
      Albert Drent
      aducom software netherlands
      scriptcase partner, reseller, support and (turn-key) development
      www.scriptcase.eu / www.scriptcase.nl

      Comment


      • #4
        Hello,

        Do you have any global variables set on your events? Could you comment all events to make sure the issue isn't being caused by any event?

        regards,
        Bernhard Bernsmann

        Comment


        • #5
          Hello,

          It is the only global variable defined in the grid.

          regards

          Comment


          • #6
            Good afternoon,

            I proceeded to perform the upgrade ScriptCase and this problem is solved.

            Thanks .....

            Comment


            • #7
              Thanks for your feedback.

              regards,
              Bernhard Bernsmann

              Comment

              Working...
              X