Re: [sqlite] Deleting database content : SQLite3 API

2009-05-30 Thread Hamish Allan
On Sat, May 30, 2009 at 1:20 PM, wrote: > Yes , I understand that. Infact I was doing that through a script during > system startup. I wanted to know whether SQLite provides any API to do the > same. No, and it doesn't provide any API for changing access permissions

Re: [sqlite] Deleting database content : SQLite3 API

2009-05-30 Thread John Stanton
gt; > Thanks and Regards, > Souvik > -Original Message- > From: sqlite-users-boun...@sqlite.org on behalf of John Stanton > Sent: Sat 5/30/2009 5:30 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Deleting database content : SQLite3 API >

Re: [sqlite] Deleting database content : SQLite3 API

2009-05-30 Thread Kees Nuyt
>To: General Discussion of SQLite Database >Subject: Re: [sqlite] Deleting database content : SQLite3 API > >An Sqlite database is just a file. Delete the file when you start >your program and when you open the database Sqlite will create a fresh >dne, a very low overhead p

Re: [sqlite] Deleting database content : SQLite3 API

2009-05-30 Thread John Machin
On 30/05/2009 10:20 PM, souvik.da...@wipro.com wrote: [top-posting unscrambled] [first message] >> As a result , after finding that the >> database already exits at the system startup, I cannot just drop the >> tables. ( As the table which are present in the existing data base is >> not

Re: [sqlite] Deleting database content : SQLite3 API

2009-05-30 Thread souvik.datta
:30 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Deleting database content : SQLite3 API An Sqlite database is just a file. Delete the file when you start your program and when you open the database Sqlite will create a fresh dne, a very low overhead process

Re: [sqlite] Deleting database content : SQLite3 API

2009-05-30 Thread John Stanton
An Sqlite database is just a file. Delete the file when you start your program and when you open the database Sqlite will create a fresh dne, a very low overhead process.. . souvik.da...@wipro.com wrote: > Hello, > > Please let me know if we have an API in SQLite3 which allows me to >

[sqlite] Deleting database content : SQLite3 API

2009-05-30 Thread souvik.datta
Hello, Please let me know if we have an API in SQLite3 which allows me to retain the database but delete it's content at runtime. The problem I am facing is that : Every time I restart my system , I need to create the database. If the database exits already it's contents need to be deleted. The