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
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