Keith,

On Fri, Apr 14, 2017 at 10:32 AM, Keith Medcalf <kmedc...@dessus.com> 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* (handle to a) database is to 
> use sqlite3_close specifying the database you want to close.

I'm talking about using same database handle for both calls.

Something like this:

[pseudo-code]
sqlite3 *m_db;
int res = sqlite3_open( name1, &m_db );
//some database operations
res = sqlite3_open( name2, &m_db );
[/pseudo-code]

Thank you.

>
> --
> ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
>
>
>> -----Original Message-----
>> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
>> On Behalf Of Igor Korot
>> Sent: Friday, 14 April, 2017 08:26
>> To: Discussion of SQLite Database; General Discussion of SQLite Database
>> Subject: [sqlite] Create database
>>
>>  Hi,
>> If I have a database open with sqlite3_open() and then want to issue
>> another sqlite3_open(),
>> the old database will be closed and the new one will open?
>> Or I have to explicitly call sqlite3_close()?
>>
>> Thank you.
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to