Re: Re: [sqlite] DELETE row problem

2007-04-16 Thread dszhang
first,thanks for your answer. in my application, i port sqlite 3.3.12 base on the OS named OS20 supported by ST and a flash FS developed by our team. them i just open a DB(flash_db) and PRAGMA it, PRAGMA temp_store = MEMORY; PRAGMA synchronous = NORMAL; after that,i creat table(flash_tabel)

Re: [sqlite] DELETE row problem

2007-04-14 Thread drh
"dszhang" <[EMAIL PROTECTED]> wrote: > when i delete some row in my table ... i find the sqlite will free > some memory that have been free[d] previous[ly]. > my question is why that thing happen and how to solve it? > SQLite should never call free() on the same piece of memory twice. If it

[sqlite] DELETE row problem

2007-04-13 Thread dszhang
dear all, i'm are freshman in sqlite,so,firstly forgive me for simple question. in my application ,i ported sqlite base on a flash fs writed by ourself. so far , everything is ok but when i delete some row in my table. during do that , i find the sqlite will free some memory that have been free