Expand my Community achievements bar.

Error SQL Concat FormCalc

Avatar

Former Community Member

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

0 Replies