Re: [sqlite] sqlite3 question

2012-01-31 Thread Pete
:00 AM, <sqlite-users-requ...@sqlite.org> wrote: > Message: 16 > Date: Mon, 30 Jan 2012 21:12:59 -0800 > From: Larry Brasfield <larry_brasfi...@iinet.com> > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] sqlite3 question > Message-ID: <4f27785b.7030...@iine

Re: [sqlite] sqlite3 question

2012-01-30 Thread Larry Brasfield
If you look at shell.c in the code implementing sqlite3.exe, you will find a procedure named resolve_backslashes(char *z) which performs a substitution of '\'-escaped characters that is similar to the C/C++ interpretation of string literals. That is what has sucked up those backslashes. Getting

[sqlite] sqlite3 question

2012-01-30 Thread Pete
I'm not sure if this is an sqlite3 question or WIndows. I am trying to use the .output command to send the output from a SELECT statement to a file on WIndows 7. The .output command looks like: .output C:\Users\Pete\AppData\Local\Temp\sqlite3out.txt When the SELECT statement is executed the

Re: [sqlite] sqlite3 question

2010-10-30 Thread john Papier
Also what's your journal_mode and synchronous setting? ( http://www.sqlite.org/pragma.html#pragma_synchronous) Depending on how these are set, if your application terminates early, or system crashes, you will likely corrupt your DB. 2010/10/30 Martin Engelschalk >

Re: [sqlite] sqlite3 question

2010-10-30 Thread Martin Engelschalk
Hello Lizhe, in order for the members in this list to help you, please provide more details. First, the most probable cause for this error is that the database file is in fact corrupted in some way or is not a sqlite database file. What step/steps leads to corruption? What sqlite function returns

[sqlite] sqlite3 question

2010-10-30 Thread lizhe
您好: 我们使用的SQLITE3 数据库版本为3.6.23.1版本,在红帽编译器下运行,运行的硬件系统为LINUX(2.6版本),现在出现了一个问题,长时间运行后会出现查询数据库返回"The database disk image is malformed", 请问这是什么原因造成的.如何解决,使用最新版本3.7.2是否会避免出现这个问题? Dear Sir: I am writing to enquire about a bug we found. Now the SQLITE3 database we use is version 3.6.23.1,

Re: [sqlite] sqlite3 question

2010-02-04 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 lizhe wrote: > I am writing to enquire about a bug we found. http://www.beiww.com/doc/oss/smart-questions.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

[sqlite] sqlite3 question

2010-02-04 Thread lizhe
您好: 我们使用的SQLITE3 数据库版本为3.6版本,在红帽编译器下运行,运行的硬件系统为LINUX(2.6版本),现在出现了一个问题,对有些板子,发现如果连续插入数据库会造成LINUX系统的崩溃,有的时候会造成FLASH的丢失,使用调试口测试,发现是堆栈益出,但是在有些板子上却很正常,可以连续插入几万条记录,请问这是什么原因造成的. Dear Sir: I am writing to enquire about a bug we found. Now the SQLITE3 database we use is version 3.6, which

Re: [sqlite] SQLite3 question

2009-05-29 Thread Oza, Hiral_Dineshbhai
@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of D. Richard Hipp Sent: Thursday, May 28, 2009 6:23 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite3 question On May 28, 2009, at 8:43 AM, Oza, Hiral_Dineshbhai wrote: > > Can you please let me know mean

Re: [sqlite] SQLite3 question

2009-05-28 Thread John Machin
On 28/05/2009 10:53 PM, Igor Tandetnik wrote: > "Oza, Hiral_Dineshbhai" > wrote in > message > news:24ea477c0c5854409ba742169a5d71c406bd4...@mailhyd2.hyd.deshaw.com >> Can you please let me know meaning of 'Cell' in Btrees used in >> sqlite3. > > Can you point to

Re: [sqlite] SQLite3 question

2009-05-28 Thread Igor Tandetnik
"Oza, Hiral_Dineshbhai" wrote in message news:24ea477c0c5854409ba742169a5d71c406bd4...@mailhyd2.hyd.deshaw.com > Can you please let me know meaning of 'Cell' in Btrees used in > sqlite3. Can you point to the text where you saw sqlite3, B-trees and the word

Re: [sqlite] SQLite3 question

2009-05-28 Thread D. Richard Hipp
On May 28, 2009, at 8:43 AM, Oza, Hiral_Dineshbhai wrote: > > Can you please let me know meaning of 'Cell' in Btrees used in > sqlite3. See line 43 of the btreeInt.h source file for the definition. You will want to read the previous 42 lines of that same file for context. D. Richard Hipp

[sqlite] SQLite3 question

2009-05-28 Thread Oza, Hiral_Dineshbhai
Hi, I am new to this list, so I am not sure whether this is the right forum to get this information... Can you please let me know meaning of 'Cell' in Btrees used in sqlite3. Thank you. -Hiral ___ sqlite-users mailing list sqlite-users@sqlite.org