Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Error SQL Concat FormCalc

Avatar

Level 1

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