[sqlite] SQLitedb problem

2009-12-21 Thread Othman Guessous
Hello, I have a problem with a sqlitedb file. So there is some data in this sqlitedb file (on notepad or pspad we can found easily these data) but they don't appear on a sqlite application browser (i use SQLite Database Browser 2.0 b1)...it seems that these data are ignored. Then how can i fix my

Re: [sqlite] SQLitedb problem

2009-12-21 Thread Jay A. Kreibich
On Mon, Dec 21, 2009 at 10:59:10AM +, Othman Guessous scratched on the wall: > Hello, > > I have a problem with a sqlitedb file. So there is some data in this > sqlitedb file (on notepad or pspad we can found easily these data) but they > don't appear on a sqlite application browser (i use SQL

Re: [sqlite] SQLitedb problem

2009-12-21 Thread Simon Slavin
On 21 Dec 2009, at 3:12pm, Jay A. Kreibich wrote: > Make a copy of the database file. Run the VACUUM command on the copy. > If the data is gone from the raw file dump, it has already been deleted > from the database structure. Alternatively you could use the command-line tool included with s

Re: [sqlite] SQLitedb problem

2009-12-28 Thread Othman Guessous
Hello, I wait for your help. Please can you answer to me ASAP. Thanks, Othman. On Mon, Dec 21, 2009 at 12:35 AM, Othman Guessous wrote: > Hello, > > I have a problem with a sqlitedb file. So there is some data in this > sqlitedb file (on notepad or pspad we can found easily these data) but the

Re: [sqlite] SQLitedb problem

2009-12-28 Thread Artur Reilin
Are these data got deleted recently? Then it was only not overwritten yet. Artur -- Am 28.12.2009, 12:13 Uhr, schrieb Othman Guessous : > Hello, > > I wait for your help. Please can you answer to me ASAP. > > Thanks, > Othman. > > On Mon, Dec 21, 2009 at 12:35 AM, Othman Guessous

Re: [sqlite] SQLitedb problem

2009-12-28 Thread Pavel Ivanov
What's the problem with the answers already given? Pavel On Mon, Dec 28, 2009 at 6:13 AM, Othman Guessous wrote: > Hello, > > I wait for your help. Please can you answer to me ASAP. > > Thanks, > Othman. > > On Mon, Dec 21, 2009 at 12:35 AM, Othman Guessous > wrote: > >> Hello, >> >> I have a pr

Re: [sqlite] SQLitedb problem

2009-12-28 Thread Artur Reilin
And I also don't think there is existing a application, that was made to read unused date in an SQLite database file. Deleted data is deleted. If you still want this data, then use an editor and copy the data out. If your sqlite application browser don't show these data, then all is said, o

Re: [sqlite] SQLitedb problem

2009-12-28 Thread Pavel Ivanov
1. Don't reply directly to me. If you write your question to the mailing list all further discussion should take place in the list. 2. Do you realize that if you write your question to the mailing list then all members of the list will answer to the list, not directly to your e-mail? Yes, I wrote d

Re: [sqlite] SQLitedb problem

2009-12-28 Thread Pavel Ivanov
http://www.mail-archive.com/sqlite-users@sqlite.org/msg49299.html Pavel On Mon, Dec 28, 2009 at 1:15 PM, Othman Guessous wrote: > Thanks, for your remark. I paid no attention to the mailing list. In fact, I > wanted to respond to the list. > > But, i doesn't receive on my inbox answers from the

Re: [sqlite] SQLitedb problem

2009-12-29 Thread Othman Guessous
Hello, Thanks you for your reply. Ok i will explain my sqlite's problem with more details. The problem concern the address book sqlitedb file from my iPhone. There is some data (contacts) from this file don't appear on my Iphone. And i verfy that by using a sqlite application browser : SQLite Da

Re: [sqlite] SQLitedb problem

2009-12-29 Thread Othman Guessous
Thanks, for your remark. I paid no attention to the mailing list. In fact, I wanted to respond to the list. But, i doesn't receive on my inbox answers from the mailing list. Is there any answers? Othman. On Mon, Dec 28, 2009 at 6:05 PM, Pavel Ivanov wrote: > 1. Don't reply directly to me. If

Re: [sqlite] SQLitedb problem

2009-12-29 Thread Othman Guessous
I understand now. Thank you Pavel for the link. But i don't understand why i don't receive the answers to my gmail inbox. However, I joined the mailing list. So i'll check my registration. I thank everyone for the responses. I will read them with attention. Othman. On Mon, Dec 28, 2009 at 6:23

Re: [sqlite] SQLitedb problem

2009-12-29 Thread Artur Reilin
Because the data was deleted. If the data was deleted it doesn't mean, that the data is not more in the database. It just not overwritten or not cleaned by an vacuum command. Is that so hard to believe? Artur -- Am 28.12.2009, 19:09 Uhr, schrieb Othman Guessous : > Hello, > > Than