RE: [sqlite] ANN: Sqlite3Explorer

2005-03-29 Thread Cariotoglou Mike
I am afraid not. the components I am using do not port to Linux. > -Original Message- > From: Leif Jensen [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 30, 2005 7:56 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] ANN: Sqlite3Explorer > >Any chance for a Linux version

Re: [sqlite] sqlitebrowser alternative

2005-03-29 Thread Noel Frankinet
Andrea Giammarchi wrote: Noel Frankinet wrote: I was not able to do anything, the rogram crashed immediately, I have several machine and virtual machine here, same result. It doesn't need any virtual machine, it's a stand alone executable program, however, 46 downloads and only you have this pro

RE: [sqlite] sqlitebrowser alternative

2005-03-29 Thread Eric Pankoke
I gave it a try, and it told me a DLL was missing. So I put that DLL (msvcr71.dll, I believe) in my Windows\System32 directory, then it told me another DLL was missing, so at that point I gave up. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message---

Re: [sqlite] sqlitebrowser alternative

2005-03-29 Thread Andrea Giammarchi
Noel Frankinet wrote: I was not able to do anything, the rogram crashed immediately, I have several machine and virtual machine here, same result. It doesn't need any virtual machine, it's a stand alone executable program, however, 46 downloads and only you have this problem. Well, I don't know w

Re: [sqlite] working with dates

2005-03-29 Thread Randall Randall
On Mar 29, 2005, at 11:17 PM, Charles Mills wrote: How have people writing SQLite bindings (or in general) dealt with inserting/binding and selecting time values? I find it helpful to use the julianday representation in timestamp fields, since it sorts correctly and SQLite can convert it to prett

Re: [sqlite] ANN: Sqlite3Explorer

2005-03-29 Thread Leif Jensen
Any chance for a Linux version ? Or a web version ? Greetings, Leif Cariotoglou Mike wrote: New version is out. Since the problem with size limits was not lifted from contrib, I created a home site for the program. You will now be able to get latest version from http://www.singular.gr/sqlite

[sqlite] working with dates

2005-03-29 Thread Charles Mills
How have people writing SQLite bindings (or in general) dealt with inserting/binding and selecting time values? Some issues are * sort order * equivalence * recognizing time values when selecting from a database * allowing users to manipulate time values using SQL (specifically SQLite's built in

[sqlite] Deleting journal files

2005-03-29 Thread Aaron Schneider
Hello all, We've been using SQLite for our database needs in our new program version, and unfortunately, we've run into some corruption issues. We believe that the corruption has been caused by deleting journal files. The program is a music manager and when managing a portable device, we copy

[sqlite] ANN: Sqlite3Explorer

2005-03-29 Thread Cariotoglou Mike
New version is out. Since the problem with size limits was not lifted from contrib, I created a home site for the program. You will now be able to get latest version from http://www.singular.gr/sqlite Latest is 1.1 , 24/3/2005 (ignore the typo in the date) Regards,mike

[sqlite] A questionable bit of code

2005-03-29 Thread Kyle Jessup
I have been trying to track down a crasher in my multi-threaded sqlite 3.2.0 application. I was seeing crashes in highly contentious situations where many threads are opening and closing a database frequently. The crash was consistently in the following bit of code: src/main.c in sqlite_close s

Re: [sqlite] sqlitebrowser alternative

2005-03-29 Thread Noel Frankinet
Andrea Giammarchi wrote: Noel Frankinet wrote: windows 2000 prof. well, I have tried on windows 2000 prof. SP4 right now ... it works perfectly, are you sure to have opened an uncorrupted sqlite *version 2 *file ??? Really strange if you are sure, anyone should tell me if this program works cor

Re: [sqlite] sqlitebrowser alternative

2005-03-29 Thread Andrea Giammarchi
Noel Frankinet wrote: windows 2000 prof. well, I have tried on windows 2000 prof. SP4 right now ... it works perfectly, are you sure to have opened an uncorrupted sqlite *version 2 *file ??? Really strange if you are sure, anyone should tell me if this program works correctly ? See you, andr

[sqlite] Version 3.2.1

2005-03-29 Thread D. Richard Hipp
SQLite version 3.2.1 is now available on the website. This release fixes a few problems with the new ADD COLUMN command. Upgrade only if you plan to use ADD COLUMN. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] sqlitebrowser alternative

2005-03-29 Thread Noel Frankinet
Andrea Giammarchi wrote: Hello andrea, Thank you Noel Frankinet for this repot , I just use this application to manage my sqlite database files ... well, Windows XP SP2 and flash player 7, no problema with a lot of database files .. -very heavy download I am working to have a better host ...

Re: [sqlite] sqlitebrowser alternative

2005-03-29 Thread Andrea Giammarchi
Thank you Noel Frankinet for this repot , I just use this application to manage my sqlite database files ... well, Windows XP SP2 and flash player 7, no problema with a lot of database files .. -very heavy download I am working to have a better host ... I am sorry, I know this is slow ... -

Re: [sqlite] RegEx w/ sqlite, yet?

2005-03-29 Thread Martins Mozeiko
In PHP it's very easy to create user defined functions. Just look in manual: http://lv2.php.net/manual/en/function.sqlite-create-function.php There you can find an example how to create sort of md5 function in SQLite as a callback. In similar way you can in very simple way create preg_match/ereg f

Re: [sqlite] ALTER TABLE ... ADD COLUMN crashes with too many columns

2005-03-29 Thread D. Richard Hipp
On Tue, 2005-03-29 at 03:13 -0800, Andy Lutomirski wrote: > I can crash sqlite3 like this: > > % cat test.sql > create table a (id INTEGER PRIMARY KEY); > alter table a add column f1 TEXT; > alter table a add column f2 TEXT; > alter table a add column f3 TEXT; > alter table a add column f4 TEXT; >

Re: [sqlite] concatenation of row with NULLS suppresses all values

2005-03-29 Thread D. Richard Hipp
On Mon, 2005-03-28 at 21:38 -0800, Jim Dodgen wrote: > thanks Derrell , > I guess I expect to see just the null values suppressed and the values that > exist to show up > > something like this: > > 1-- > 2-- > 3-33-333 > NULL concatenated with anything is still NULL. So the output should be

Re: [sqlite] sqlitebrowser alternative

2005-03-29 Thread Noel Frankinet
Andrea Giammarchi wrote: I have just uploaded an "SQLITEBROWSER like" application made in Python and Flash 7. This application requires windows ( it's an exe file ) and Flash Player 7 installed. It works perfectly with all sqlite 2.X database files and it's easy to use ( I hope ). Please tell me

[sqlite] ALTER TABLE ... ADD COLUMN crashes with too many columns

2005-03-29 Thread Andy Lutomirski
I can crash sqlite3 like this: % cat test.sql create table a (id INTEGER PRIMARY KEY); alter table a add column f1 TEXT; alter table a add column f2 TEXT; alter table a add column f3 TEXT; alter table a add column f4 TEXT; alter table a add column f5 TEXT; alter table a add column f6 TEXT; alter ta

[sqlite] sqlitebrowser alternative

2005-03-29 Thread Andrea Giammarchi
I have just uploaded an "SQLITEBROWSER like" application made in Python and Flash 7. This application requires windows ( it's an exe file ) and Flash Player 7 installed. It works perfectly with all sqlite 2.X database files and it's easy to use ( I hope ). Please tell me what do you think about