Thanks Erol,
I had time to revise the code. Please check out the latest snapshot [1], in which prepared statements can now be closed, too.
Christian
[1] http://files.basex.org/releases/latest/
On Thu, May 29, 2014 at 3:03 PM, Erol Akarsu eakarsu@gmail.com wrote:
Christian,
I tried to close prepared statement and got this exception:
[BXSQ0002] No opened connection with id 1
It throws exception at line
let $clres := sql:close($prep)
let $prep := sql:prepare($conn,$sqlStmt) let $params := sql:parameters <sql:parameter type='string'>{$useType}</sql:parameter> </sql:parameters> let $result := sql:execute-prepared($prep, $params) let $clres := sql:close($prep)
On Wed, May 28, 2014 at 3:51 PM, Christian Grün christian.gruen@gmail.com wrote:
sql:close is for connection to SQL server but prepared statement?
If I remember right, it's for both. Did you have a try?