Getting error with SQL insert command

Clovertech Forums Read Only Archives Cloverleaf Tcl Library Getting error with SQL insert command

  • Creator
    Topic
  • #52720
    Tom Gilbert
    Participant

      I am getting the following errors when running the following script.

    Viewing 2 reply threads
    • Author
      Replies
      • #75275
        Chris Williams
        Participant

          Just guessing, but it looks like you are trying to use the individual words of a diagnostic message “12 microseconds per iteration” in your INSERT rather than the appropriate { } pairs.

        • #75276
          Tom Gilbert
          Participant

            Hello Chris,  I am not sure what you mean…  Please explain.

          • #75277
            Chris Williams
            Participant

              Tom,

              After a closer look at your code, your proc is not returning an appropriate $dispList value. When you call a tcl proc, if you do not specify a return value it will return the value that was returned by the last tcl statement in the proc. It appears that the last tcl statement executed inside the proc returned the string “12 microseconds per iteration” which just doesn’t work as a $dispList value.

              You can’t just comment out pieces of your code without understanding the ramifications. Also in switch statements you cannot place the comment characters where you have them, e.g., “#shutdown”, “#default”. Get the braces back where they belong, remove those inappropriate “#” characters and give it another try.

          Viewing 2 reply threads
          • The forum ‘Tcl Library’ is closed to new topics and replies.