innovaphone Apps SDK Developer Forum

1 of 1 users consider this post helpful

Re: SQL Prepare Statements in JS

Hello Daniel,

for 1) and 2) you are correct - prepared statements are possible.

Also for 3), you can use PREPARE and EXECUTE statements as the exec function parameter.

The only drawback for 3) existing - no binary parameter transfer available. This may affect performance on high load applications.

We are reviewing the possibility to implement additional functions for the Database object of the JavaScript library for App Services, in order to support binary parameter transfer.

Best Regards

Andreas Fink

You are here