GpSQLBuilder
GpSQLBuilder copied to clipboard
how to create paramater value ?
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
And what is the source code that generates this query?