Re: [sqlite] test failures on cygwin

2007-09-21 Thread Gerry Snyder
Evans, Mark (Tandem) wrote: So it looks like I have a cygwin TCL issue. Is this fixable? You can load Active State Tcl and use that instead of the version that comes with Cygwin. You get lots of extra goodies, in addition to an up-to-date Tcl core. HTH, Gerry

Re: [sqlite] test failures on cygwin

2007-09-21 Thread drh
"Evans, Mark (Tandem)" <[EMAIL PROTECTED]> wrote: > ** > N.B.: The version of TCL that you used to build this test harness > is defective in that it does not support 64-bit integers. Some or > all of the test failures above might be

Re: [sqlite] test failures on cygwin

2007-09-21 Thread drh
"Evans, Mark (Tandem)" <[EMAIL PROTECTED]> wrote: > Hi all, > > I have been lurking on the message board and am in awe of the collective > wisdom. > > I'm just getting my feet wet learning the internals of SQLite, drinking > from the proverbial firehose. I am using cygwin 1.90 as my learning >

RE: [sqlite] test failures on cygwin

2007-09-21 Thread Evans, Mark (Tandem)
When I run just autoinc.test alone, I get the following summary output: 54 errors out of 66 tests Failures on these tests: autoinc-6.1 autoinc-1.1 autoinc-1.2 autoinc-1.3 autoinc-1.4 autoinc-1.6 autoinc-2.1 autoinc-2.2 autoinc-2.3 autoinc-2.4 autoinc-2.5 autoinc-2.6 autoinc-2.7 autoinc-2.8

[sqlite] test failures on cygwin

2007-09-21 Thread Evans, Mark (Tandem)
Hi all, I have been lurking on the message board and am in awe of the collective wisdom. I'm just getting my feet wet learning the internals of SQLite, drinking from the proverbial firehose. I am using cygwin 1.90 as my learning platform and I have built SQLite 3.5.0. I ran 'make test'

Re: [sqlite] SQLite and html character entities

2007-09-21 Thread Clark Christensen
Wow! Excellent summary, Trevor. - Original Message From: Trevor Talbot <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Thursday, September 20, 2007 11:35:42 PM Subject: Re: [sqlite] SQLite and html character entities On 9/20/07, P Kishor <[EMAIL PROTECTED]> wrote: > On 9/20/07,

RE: [sqlite] Insertion and Search at a same time is it possible?

2007-09-21 Thread Sreedhar.a
Hi John Stanton, Thankyou very much, I will try in this method. Best Regards, A.Sreedhar. -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 6:20 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Insertion and Search at a same time is

Re: [sqlite] Insertion and Search at a same time is it possible?

2007-09-21 Thread John Stanton
You can read and write to the database concurrently provided that your program can handle SQLITE_BUSY events. Sreedhar.a wrote: Hi Everyone, I am implementing server database using sqlite. I will be having the multiple clients browsing the database. At the same time the database can also

RE: [sqlite] FTS3 where ?

2007-09-21 Thread Andre du Plessis
I am indeed using Delphi, BUT, I have quite a few programs which are using my library I put together for Delphi, it would be quite a large change to convert to DISQLite3 at this point, plus this same program uses Python and ASP.net Which means that fts3.dll as a standalone would definitely be

Re: [sqlite] FTS3 where ?

2007-09-21 Thread Ralf Junker
Hello Andre du Plessis, If you are using Delphi, FTS3 is already included in the latest DISQLite3 (Pro and Personal). Download is available from http://www.yunqa.de/delphi/. The source code is available from CVS. You will find FTS3 in the /ext/ directory. Ralf >Fts3 which everyone is talking

[sqlite] FTS3 where ?

2007-09-21 Thread Andre du Plessis
Fts3 which everyone is talking about, I cannot see any mention of it on the download page, does it mean that its just the development sourcecode which people are compiling at this point or are there some prebuilt dll's available, or has it not been officially released yet? Thanks.

Re: [sqlite] SQLite and html character entities

2007-09-21 Thread Trevor Talbot
I should also mention, a text editor I like to use is SubEthaEdit (I have the old 2.2 version), and it supports switching encodings via the Format menu. If you're switching to find the encoding of an existing file, just choose Reinterpret when it asks.

Re: [sqlite] SQLite and html character entities

2007-09-21 Thread Trevor Talbot
On 9/20/07, P Kishor <[EMAIL PROTECTED]> wrote: > On 9/20/07, Trevor Talbot <[EMAIL PROTECTED]> wrote: > > On 9/20/07, P Kishor <[EMAIL PROTECTED]> wrote: > > > Lucknow:~/Data/ecoservices punkish$ less foo.csv > > > "the first record" > > > "\351 \347 \361 \356" > > > "more from 3rd row" > > >