Single quotes appearing in a SQL for a string value
Hello,
Need help in resolving this issue,
I am assigning String variable to a State record character field in a people code and using same field in a SQL but whenever this field is resolved in SQL it comes with single quotes which makes my SQL incorrect. Any idea how can i fix it, i tried noquotes for bind variable but did not work.
in People Code
C_INT_APP_AET.PAGETEXT1.Value = &fieldVar;
in SQL
(%Bind(PAGETEXT2, NOQUOTES)) this expands into a character value with Quotes around it.