Releasing a Database

lmc · **Posted:** March 29th, 2013, 1:34 pm

Thanks for your help Mac.

So I would set RecSet and db in your example to null on exit and that should work?

Code:

var db = new Database("DSN=IRDB;") 
var RecSet = db.ExecuteSQL("SELECT * FROM orders WHERE c_name='"+c+"' ORDER BY c_product") 

Thanks, Luke

mackavi · **Posted:** March 29th, 2013, 4:39 pm

My example is a local variable in a function, so it would be released when the function call is finished, BUT, yes setting the RecSet to null works as well. db is the database connection and doesn't appear to affect the creation of a locked MDB.

Mack

Digital Workshop

Releasing a Database

Who is online