GpSQLBuilder icon indicating copy to clipboard operation
GpSQLBuilder copied to clipboard

how to create paramater value ?

Open v4v4n opened this issue 2 years ago • 1 comments

hello,

i need to create sql with paramater value. like below INSERT INTO tenant (tenant_name, notes) VALUES (:tenant_param, :notes_param)

can the sql builder create the values part without quotes ? because the resulted query is : INSERT INTO tenant (tenant_name, notes) VALUES ('':tenant_param'','' :notes_param'')

so the dataset can not find the paramater tenant_param as it is quoted

Thank you

v4v4n avatar May 06 '23 04:05 v4v4n

And what is the source code that generates this query?

gabr42 avatar May 08 '23 17:05 gabr42