Hi all
Why can't I delete tmp.db after close sqlite?
sqlite3* mpDB;
int nRet = sqlite3_open("tmp.db", );
if (nRet != SQLITE_OK)
{
const char* szError = sqlite3_errmsg(mpDB);
printf("open error:%s\n",szError);
}
sqlite3_close(mpDB);
printf("close!\n");
if ( !
if the file is new for opening, then success for delete, in other hand, if the
file is old for opening, then failed for delete. example as follow:
sqlite3_open("tmp.db", ); //tmp.db is exist
- Original Message -----
From: LuYanJun
To: sqlite-users sqlite.org
Sent: Thursday, N
Can anybody give a simple example for domestrating ?
I am puzzled by this topic, how does a music file be sotred in DB as BLOB type?
TKS.
- Original Message -
From: "Alex Roston" <[EMAIL PROTECTED]>
To:
Sent: Saturday, October 28, 2006 4:35 AM
Subject: Re:
riginal Message -
From: "Isaac Raway" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, November 28, 2006 11:04 PM
Subject: Re: [sqlite] Music Files
> On 11/27/06, LuYanJun <[EMAIL PROTECTED]> wrote:
>>
>> Can anybody give a simple
Hi guy:
what does the follow meaning?
sqlite> BEGIN READ_ONLY;
SQL error: near "READ_ONLY": syntax error
;
...and so forth.
I wonder that does do something with version?
- Original Message -
From: "Marten Feldtmann" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, December 18, 2006 3:00 PM
Subject: Re: [sqlite] SQL error: near "READ_ONLY": syntax e
Hi guy
Suppose there is table name Schedule and more than two records be stored.
however, one filed name as title and its values contain '%' in one of both
records , so then such SQL pharse: SELECT * FROM Schedule WHERE title LIKE
'%%%' be given , then return both records NOT only one .
AIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Friday, January 19, 2007 1:08 PM
Subject: Re: [sqlite] does sqlite support mutil-thread be run in samedatabase?
>
> On Fri, 2007-01-19 at 11:42 +0800, LuYanJun wrote:
>> The next question is that if I want to use multi-thread in
8 matches
Mail list logo