0 Replies Latest reply on Jun 10, 2011 1:51 PM by xpmpjp

    Error SQL Concat FormCalc

    xpmpjp

      hello

       

      I'm starting with FormCalc, and I have my first question.

      line "a" is correct when SelectField field was numeric. BUT I changed the field SelectField to text, and I wrote the line "b" and gives me error.
      You can help me, where I have the error.

       

       

      a)

      $sourceSet.DataConnection.#command.query.select.nodes.item(0).value = Concat("Select * from OfficeSupplies Where ID = ", Ltrim(Rtrim(SelectField.rawValue)) ,"")

       

      b)

      $sourceSet.DataConnection.#command.query.select.nodes.item(0).value = Concat("Select * from OfficeSupplies Where ID = ",SelectField.rawValue,"")

       

       

      Thank you very much