Re: [sqlite] How to update wiki? date/time page misprint

2005-08-16 Thread Kurt Welgehausen
> strftime ... for the %j format ... should specify > 001-366 instead of 000-366 You're correct. You should be able to edit the page by clicking on Edit just below the main heading. Regards

Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.

2005-08-16 Thread Edwin Knoppert
Hmm, my previous post got not posted because the correct address wasn't set. Can't get a grip on this board yet :) A duplicate is not created if there was an error. And if the name already exists but that would generate an error as well. You might have been mistaken since there is a sort in the t

Re: [sqlite] make test fails at tcl-10.5

2005-08-16 Thread Hari Kodungallur
Works now. Thanks much! -Hari On Tue, 2005-08-16 at 07:11 -0400, D. Richard Hipp wrote: > On Mon, 2005-08-15 at 19:40 -0700, Hari Kodungallur wrote: > > Hi, > > > > I am using the latest from the CVS. While doing "make test", it fails at > > tcl-10.5 with a segmentation fault. > > > > Can you

[sqlite] How to update wiki? date/time page misprint

2005-08-16 Thread Bob Dankert
I'm not sure if it is possible for myself to update the SQLite wiki, but on the Date and Time Functions page, http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions, the text for the format of strftime is incorrect for the %j format. I believe this should specify 001-366 instead of 000-366.

Re: [sqlite] Linking libsqlite statically

2005-08-16 Thread Clay Dowling
D. Kettler said: > When I add the -static flag to my g++ command it gives me 'undefined > reference to' errors for every instance where I attempt to use a sqlite > function. > > This is on a Debian (testing) system and yes I have both libsqlite3 and > libsqlite3-dev installed. There are libsqlit

RE: [sqlite] Convert / Import

2005-08-16 Thread Griggs, Donald
-Original Message- From: administrator [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 5:01 AM To: sqlite-users@sqlite.org Subject: [sqlite] Convert / Import Does anybody know a good/quick way to convert from V.Fox 8 .dbf to sqlite format ? I tried to export to .csv from Visua

Re: [sqlite] Have ever anybody port SQLite to WinCE

2005-08-16 Thread Mateusz Łoskot
Noel Frankinet napisał(a): > jason zhang wrote: > >> Hi, >> Thank you. >> How about the performance of this library? - Original Message >> > > very good, I even use it for graphic display (GIS). > I use sqlite on Windows CE too and as Noel I use it for GIS applications. I can say it is

[sqlite] The total when using LIMIT clause

2005-08-16 Thread Ligesh
Hi, How do we know the total number of results, when we are using LIMIT? is there any parameter that returns the real number of matches? Thanks in advance. -- :: Ligesh

Re: [sqlite] make test fails at tcl-10.5

2005-08-16 Thread D. Richard Hipp
On Mon, 2005-08-15 at 19:40 -0700, Hari Kodungallur wrote: > Hi, > > I am using the latest from the CVS. While doing "make test", it fails at > tcl-10.5 with a segmentation fault. > > Can you please guide me on how I can debug the issue? http://www.sqlite.org/cvstrac/chngview?cn=2596. Do "cvs

Re[2]: [sqlite] Convert / Import

2005-08-16 Thread Sergey Startsev
Hello administrator, Tuesday, August 16, 2005, 6:06:41 PM, you wrote: a> Thank you ! That did it in 17 minutes. Not at all! -- Best regards Sergey Startsev SQLite Analyzer - SQLite database management tool with GUI. http://www.kraslabs.com/sqlite_analyzer.html

Re: [sqlite] Convert / Import

2005-08-16 Thread administrator
Thank you ! That did it in 17 minutes. - Original Message - From: "Sergey Startsev" <[EMAIL PROTECTED]> To: "administrator" Sent: Tuesday, August 16, 2005 12:08 PM Subject: Re: [sqlite] Convert / Import > Hello administrator, > > Tuesday, August 16, 2005, 5:01:23 PM, you wrote: > > a>

Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.

2005-08-16 Thread Edwin Knoppert
Sent.. - Original Message - From: "Andrew Brampton" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 16, 2005 10:38 AM Subject: Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote. Sure I'll help out. Andrew - Original Message - From: "Edwin Knoppert"

Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.

2005-08-16 Thread Edwin Knoppert
Only Windows i'm affraid. (Virtual PC?) - Original Message - From: "Dr Gerard Hammond" <[EMAIL PROTECTED]> To: Cc: "Edwin Knoppert" <[EMAIL PROTECTED]> Sent: Tuesday, August 16, 2005 10:51 AM Subject: Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote. At 9:2

Re: [sqlite] Convert / Import

2005-08-16 Thread Sergey Startsev
Hello administrator, Tuesday, August 16, 2005, 5:01:23 PM, you wrote: a> Does anybody know a good/quick way to convert from V.Fox 8 .dbf to sqlite a> format ? I tried to export to .csv from Visual Fox , then to import into .db a> using SQLite Database Browser but it just takes to much time (runn

[sqlite] Convert / Import

2005-08-16 Thread administrator
Does anybody know a good/quick way to convert from V.Fox 8 .dbf to sqlite format ? I tried to export to .csv from Visual Fox , then to import into .db using SQLite Database Browser but it just takes to much time (running for 2h50m now and still going, a ~ 2.000.000. rows each with 32 fields ) and

Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.

2005-08-16 Thread Dr Gerard Hammond
At 9:29 AM +0200 16/8/05, Edwin Knoppert wrote: I only need a list what i need to correct like critical errors, not what to change like gui changes or similar. It's a freeware tool and not being released before it had a better test than i did. Mail me if you want to help. App consists from ex

Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.

2005-08-16 Thread Andrew Brampton
Sure I'll help out. Andrew - Original Message - From: "Edwin Knoppert" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 16, 2005 8:29 AM Subject: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote. I only need a list what i need to correct like critical errors, not

[sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.

2005-08-16 Thread Edwin Knoppert
I only need a list what i need to correct like critical errors, not what to change like gui changes or similar. It's a freeware tool and not being released before it had a better test than i did. Mail me if you want to help. App consists from exe, hlp and sqlite3 dll. hope you'll look into t

Re: [sqlite] Have ever anybody port SQLite to WinCE

2005-08-16 Thread jason zhang
Thank you! you are so kind. - Original Message - From: "Noel Frankinet" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 16, 2005 3:17 PM Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE > jason zhang wrote: > >>Hi, >> Thank you. >> How about the performance of this librar

Re: [sqlite] Have ever anybody port SQLite to WinCE

2005-08-16 Thread Noel Frankinet
jason zhang wrote: Hi, Thank you. How about the performance of this library? - Original Message - From: "Noel Frankinet" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 16, 2005 2:57 PM Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE jason zhang wrote:

Re: [sqlite] Have ever anybody port SQLite to WinCE

2005-08-16 Thread jason zhang
Hi, Thank you. How about the performance of this library? - Original Message - From: "Noel Frankinet" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 16, 2005 2:57 PM Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE > jason zhang wrote: > >>Hi, >> Thank you.I jus