Hi,
I am trying to use vvOut_execSqlToJson(vvOut:lStmt) to execute a prepared SQL/JSON statement. The SQl that is prepared just inserts data into a file. It doesn't return any response to the browser.
If I run the same tailored SQL outside, i am able to insert the records into the target file, where as when i pass the SQL Statement(lStmt) to vvOUT_execSQLToJson as above, records are not being inserted.
Could you please let me know if I am using this procedure correct? or is there any other alternative proc that can be called?
Regards,
Pavan
I am trying to use vvOut_execSqlToJson(vvOut:lStmt) to execute a prepared SQL/JSON statement. The SQl that is prepared just inserts data into a file. It doesn't return any response to the browser.
If I run the same tailored SQL outside, i am able to insert the records into the target file, where as when i pass the SQL Statement(lStmt) to vvOUT_execSQLToJson as above, records are not being inserted.
Could you please let me know if I am using this procedure correct? or is there any other alternative proc that can be called?
Regards,
Pavan
Comment