Zeoslib doesn't release the Database file after disconnect.
Posted: 10.11.2014, 21:04
I don't understand what is going on. I thought that when you connected to the database dummy.db file through TZConnection tool, you always stayed connected until you disconnected from it. However, no matter what I do once I connect to a database file, it remains connected even though I call disconnect procedure of TZConnection. Thus, it never releases the database file dummy.db until I shutdown the program. Am I missing something?
ZConnection1.Database := 'dummy.db';
ZConnection1.Protocol := 'SQLite-3';
ZConnection1.Connect;
Query1.SQL.TEXT := 'SELECT * FROM test'; (Query1 connection is ZConnection1)
Query1.ExeSQL;
ZConnection1.Disconnect;
But disconnect never releases the dummy.db file. I need to be able to do that for my program... Any hints or clues will be greatly appreciated. Thanks.
ZConnection1.Database := 'dummy.db';
ZConnection1.Protocol := 'SQLite-3';
ZConnection1.Connect;
Query1.SQL.TEXT := 'SELECT * FROM test'; (Query1 connection is ZConnection1)
Query1.ExeSQL;
ZConnection1.Disconnect;
But disconnect never releases the dummy.db file. I need to be able to do that for my program... Any hints or clues will be greatly appreciated. Thanks.