Closing open db connection

[Piorun]

Hi,

I know that in "normal" programming lang i must close db connection. How is it possible to do in MTA (using Lua and db... functions)?

[GTX]

Use

destroyElement 

to close DB connection.

[Piorun]

Thanks a lot

[ixjf]

Hi,

I know that in "normal" programming lang i must close db connection. How is it possible to do in MTA (using Lua and db... functions)?

That is wrong. If you need to close the database connection in the middle of the execution of the script, then you can use destroyElement. Otherwise, you can just let Lua's garbage collector close the database connection automatically when it is no longer referenced anywhere in your code (or, for example, when you stop the resource). In other languages, for example, C++, even though you don't have garbage collection, you have idioms like RAII (Resource Acquisition Is Initialization), which take care of that.