Re: [sqlite] Cannot delete a Database file?

2017-06-28 Thread Domonic Tom
__ From: sqlite-users on behalf of Richard Hipp Sent: Wednesday, 28 June 2017 7:55 PM To: SQLite mailing list Subject: Re: [sqlite] Cannot delete a Database file? On 6/28/17, Domonic Tom wrote: > > Would anyone know how to go about making sure that the database file is not > busy and can

[sqlite] Cannot delete a Database file?

2017-06-28 Thread Domonic Tom
After calling sqlite3_close(handle) I try then to use the 'remove' method in C++ to delete my .db file. For some reason it just won't delete. It's hard to show you the whole project because it's large. I believe this has something to do with sqlite3_close only de-allocating the connection to

Re: [sqlite] Can the Explain explain what is going on here?

2017-01-04 Thread Domonic Tom
Thanks Simon. I solved the issue by making sqlite3 *dbhandle = NULL then testing it for a null value afterwards. It works fine. From: sqlite-users on behalf of Simon Slavin Sent: Wednesday, 4 January 2017 9:47 AM To: SQLite mailing list Subject: Re: [sqli

[sqlite] Testing Sqlite3* DB_handle?

2017-01-02 Thread Domonic Tom
Is there a way to test whether the DB_handle used when opening a database is good? I need to find some way of testing it to make sure it represents the live connection to a database? Is that possible? Thanks ___ sqlite-users mailing list sqlite-use

[sqlite] Get Table names from Database in C++?

2016-08-04 Thread Domonic Tom
Would anyone know how to get the table names from a specific database in C++ or just using the C API for sqlite? I have tried the below but I get nothing. Thought I might be able to move the list of names into a table but it doesn't seem to want to work. Clearly I can't do this using sql.. A