Re: [sqlite] checking the database status

2005-08-26 Thread victor...
you can check if some table of your db exits. The file generated is empty. []'s Victor Dennis Jenkins <[EMAIL PROTECTED]> escreveu: Robert Simpson wrote: > um ... It's a file. You just check to see if the file exists. No > sqlite calls involved. > > Robert > That would work in this situati

Re: [sqlite] checking the database status

2005-08-26 Thread Robert Simpson
- Original Message - From: "Dennis Jenkins" <[EMAIL PROTECTED]> To: Sent: Friday, August 26, 2005 1:48 PM Subject: Re: [sqlite] checking the database status Robert Simpson wrote: What I say below is in no means trying to be rude or show you (or anyone) up. I have n

Re: [sqlite] checking the database status

2005-08-26 Thread Dennis Jenkins
Robert Simpson wrote: What I say below is in no means trying to be rude or show you (or anyone) up. I have no idea what your experiences are with Windows or Unix or Unix-Like operating systems. I'm probably stating things that almost all of us already know. :) So? If you open the file,

Re: [sqlite] checking the database status

2005-08-26 Thread Robert Simpson
- Original Message - From: "Dennis Jenkins" <[EMAIL PROTECTED]> To: Sent: Friday, August 26, 2005 1:12 PM Subject: Re: [sqlite] checking the database status Robert Simpson wrote: sqlite3_open() doesn't create/open a file for exclusive access off the bat. If y

Re: [sqlite] checking the database status

2005-08-26 Thread Dennis Jenkins
Robert Simpson wrote: sqlite3_open() doesn't create/open a file for exclusive access off the bat. If you want to atomically open a file that already exists, open it yourself and while its open, call sqlite3_open(), then close your own handle to it. If you want to atomically create a file an

Re: [sqlite] checking the database status

2005-08-26 Thread Robert Simpson
f you created it, create it yourself and while its open, call sqlite3_open() then close your handle. Robert - Original Message - From: "Dennis Jenkins" <[EMAIL PROTECTED]> To: Sent: Friday, August 26, 2005 12:51 PM Subject: Re: [sqlite] checking the database status

Re: [sqlite] checking the database status

2005-08-26 Thread Dennis Jenkins
Robert Simpson wrote: um ... It's a file. You just check to see if the file exists. No sqlite calls involved. Robert That would work in this situation, but what about the inverse? You only want to open the file IF it already exists. There is a race condition: where you check for the fil

[sqlite] checking the database status

2005-08-26 Thread YOGESH
hello, i am working on sqlite 2.8.16 and my requirement is when i use the sqlite_open function i want to display error message if the database is not present.I don't want a new database with the wrong name to be created each time i use the sqlite_open function. I checked for the error parameter

Re: [sqlite] checking the database status

2005-08-26 Thread Robert Simpson
um ... It's a file. You just check to see if the file exists. No sqlite calls involved. Robert - Original Message - From: "YOGESH" <[EMAIL PROTECTED]> To: Sent: Friday, August 26, 2005 12:50 PM Subject: [sqlite] checking the database status hello, i am wor