Re: [sqlite] Create database

2017-04-14 Thread Daniel Anderson
m: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > > On Behalf Of Daniel Anderson > > Sent: Friday, 14 April, 2017 21:11 > > To: SQLite mailing list > > Subject: Re: [sqlite] Create database > > > > you would probably be better off using C++

Re: [sqlite] Create database

2017-04-14 Thread Keith Medcalf
SQLite mailing list > Subject: Re: [sqlite] Create database > > you would probably be better off using C++ to handle everything, less > chances of forgetting to close something. > > do not build your own classes, use existing one! > > 2017-04-14 10:44 GMT-04:00 Igor K

Re: [sqlite] Create database

2017-04-14 Thread Daniel Anderson
ginal Message- > >> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org > ] > >> On Behalf Of Keith Medcalf > >> Sent: Friday, 14 April, 2017 08:32 > >> To: SQLite mailing list > >> Subject: Re: [sqlite] Create database > &

Re: [sqlite] Create database

2017-04-14 Thread Jens Alfke
> On Apr 14, 2017, at 7:44 AM, Igor Korot wrote: > > It means that the call to sqlite3_open() does not close previously > opened database and I have to explicitly close it > with sqlite3_close(). > > I was just couldn't find it anywhere in the docs. Probably missed it. The

Re: [sqlite] Create database

2017-04-14 Thread Simon Slavin
On 14 Apr 2017, at 3:44pm, Igor Korot wrote: > Thank you for clarifying. > It means that the call to sqlite3_open() does not close previously > opened database and I have to explicitly close it > with sqlite3_close(). SQLite can open as many connections as you want. It

Re: [sqlite] Create database

2017-04-14 Thread Igor Korot
lite-users-boun...@mailinglists.sqlite.org] >> On Behalf Of Keith Medcalf >> Sent: Friday, 14 April, 2017 08:32 >> To: SQLite mailing list >> Subject: Re: [sqlite] Create database >> >> >> No, a new database will be opened and you will be given an sqlite3* to it

Re: [sqlite] Create database

2017-04-14 Thread Keith Medcalf
te mailing list > Subject: Re: [sqlite] Create database > > > No, a new database will be opened and you will be given an sqlite3* to it. > > Just like the fopen() call can be used to open multiple files, > sqlite3_open* opens a database. The way to close an sqlite3* (handle to &

Re: [sqlite] Create database

2017-04-14 Thread Igor Korot
Keith, On Fri, Apr 14, 2017 at 10:32 AM, Keith Medcalf wrote: > > No, a new database will be opened and you will be given an sqlite3* to it. > > Just like the fopen() call can be used to open multiple files, sqlite3_open* > opens a database. The way to close an sqlite3*

Re: [sqlite] Create database

2017-04-14 Thread Keith Medcalf
No, a new database will be opened and you will be given an sqlite3* to it. Just like the fopen() call can be used to open multiple files, sqlite3_open* opens a database. The way to close an sqlite3* (handle to a) database is to use sqlite3_close specifying the database you want to close. --

Re: [sqlite] create database file at runtime

2005-09-14 Thread Nemanja Corlija
On 9/14/05, Mark Wyszomierski <[EMAIL PROTECTED]> wrote: > Hi everyone, > Two quick questions: > 1) Is there anything special the supplied sqlite3.exe does to create a > database file. I want to programatically create a database file at runtime, > so can I just create an empty xxx.db file, and

RE: [sqlite] create database API

2005-01-17 Thread Fred Williams
Don't worry. It was a trick question :-) -Original Message- From: bs [mailto:[EMAIL PROTECTED] Sent: Monday, January 17, 2005 1:19 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] create database API Ulrik Petersen wrote: > Hi there, > > bs wrote: > >>

Re: [sqlite] create database API

2005-01-17 Thread bs
Ulrik Petersen wrote: Hi there, bs wrote: if (NULL == (db = sqlite_open(argv[0], 0, ))) { argv[0] is the name of the program, which is not a database. You probably want argv[1]. pls hit me with a big stick! thx! bal

Re: [sqlite] create database API

2005-01-17 Thread Kurt Welgehausen
What does argv[0] point to? Regards