[PDFdev] How to close a Javascript statement ?

Wed, 21 Jan 2004 04:05:46 -0800 


PDFdev is a service provided by PDFzone.com | http://www.pdfzone.com
_____________________________________________________________

Hi,

I have a recursive Javscript function (Acrobat 6.0 pro, Windows XP) which creates a new SQL statement in each function call, with ADBC on an Access database :

function RecursiveFct(...) {
   ordreCLVar = connCLVar.newStatement();
   ordreCLVar.execute(ordsqlVar);
   while (...) {
       enr = ordreCLVar.getRow();
       ... call to the same recursive function RecursiveFct(...) ...
   }
}

I don't close my SQL statement, because I don't know how to do that.
I then trace my ODBC driver, and I notice that after about 220 execute statements, my Access ODBC driver says it can't open tables anymore.

Is it possible to close a SQL statement, so I could free my database resources ?

Thanks

Mikael LAUSSEUR
Aalto Consultant


To change your subscription:
http://www.pdfzone.com/discussions/lists-pdfdev.html

Reply via email to