[sqlite] Why can't I delete tmp.db after close sqlite?

2006-11-08 Thread LuYanJun
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 ( !

[sqlite] Fw: Why can't I delete tmp.db after close sqlite?

2006-11-08 Thread LuYanJun
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

Re: [sqlite] Music Files

2006-11-27 Thread LuYanJun
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:

Re: [sqlite] Music Files

2006-11-29 Thread LuYanJun
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

[sqlite] SQL error: near "READ_ONLY": syntax error

2006-12-17 Thread LuYanJun
Hi guy: what does the follow meaning? sqlite> BEGIN READ_ONLY; SQL error: near "READ_ONLY": syntax error

Re: [sqlite] SQL error: near "READ_ONLY": syntax error

2006-12-18 Thread LuYanJun
; ...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

[sqlite] SELECT * FROM Schdeule WHERE title LIKE '%%%'

2006-12-21 Thread LuYanJun
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 .

Re: [sqlite] does sqlite support mutil-thread be run in samedatabase?

2007-01-18 Thread LuYanJun
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