RE: [sqlite] import

dos2unix, unix2dos tools will do the conversion -Original Message- From: Randall [mailto:[EMAIL PROTECTED] Sent: Monday, February 20, 2006 1:33 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] import PS I can do vbscript readline/ writeline as a workaround, not too slow... But I

Re: [sqlite] import

PS I can do vbscript readline/ writeline as a workaround, not too slow... But I would prefer not. Randall Hi, I think it is asc=10, so "LF" rather than "CRLF", but I don't want to have to re-open , say a 80Mb or 0.5gig text file with a text editor, nor re-process the lines! Surely there is

[sqlite] SQLite 3 file format changed?

Hi, I use PHP PDO_SQLITE extension with SQLite 3.2.8 library, I try to open a database version 3 which I use SQLiteSpy 1.5.2 with SQLite 3.3.4 library, then PDO said error message like "unsupported file format". I tried to use sqlite3 console which is version 3.2.6 for open it, same error message

Re: [sqlite] Managing trees in the database

On Sat, Feb 18, 2006 at 05:34:45PM -0800, Jim Dodgen wrote: > I really miss the oracle "connect by" operator. I first used it for a > postal application back in 1992. I am surprised that this feature has > not made it into to the standard or any other RDBMS. Maybe we should Although

Re: [sqlite] using sqlite3 in php

You can use the PDO extension. http://php.net/pdo http://www.php.net/manual/en/ref.pdo-sqlite.php Maurício M. Maia www.semjanelas.net jack wu wrote: apparently sqlite3 is not available in php5. i am wondering if there is anyway to work around it. i have a c++ program which works with

Re: [sqlite] Managing trees in the database

Jim C. Nasby wrote: On Thu, Feb 16, 2006 at 08:23:43PM +0100, Philipp Kn?sel wrote: SanjayK schrieb: Since SQLite is perfect for use in single-user desktop utility applications and since such applications typically store hierarchial data (tree) in a single table, it would be nice to

[sqlite] Older sources

Hi there. I would need the sources of an older version (3.1.2) of SQLite. Are they still available for download? Best regards, Manfred ___ Telefonate ohne weitere Kosten vom PC zum PC:

Re: [sqlite] import

Hi, I think it is asc=10, so "LF" rather than "CRLF", but I don't want to have to re-open , say a 80Mb or 0.5gig text file with a text editor, nor re-process the lines! Surely there is an option, or this can be modified in the ".output" command..? It is already OK in the ".dump" for

[sqlite] using sqlite3 in php

apparently sqlite3 is not available in php5. i am wondering if there is anyway to work around it. i have a c++ program which works with sqlite3, but i would also like my php script to use the same database. jack.

Re: [sqlite] import

On Mon, 20 Feb 2006, Randall wrote: [...] I cannot get ".output" to work reliably to give me a correct "EOL", so, say, notepad sees the "EOL". [...] Hello, this may sound stupid, but is it possible that you get a file with UNIX line endings instead of Windows ones? If that's the case, any

Re: [sqlite] import

Hi, please open this again; I cannot get ".output" to work reliably to give me a correct "EOL", so, say, notepad sees the "EOL". Can anyone help? [Wrapper was not the problem, I believe] Thanks, Randall Sorry; Ignore this for now; I see ".output" works OK; my wrapper was stripping

[sqlite] 3.3.4 build with MinGW/MSYS

A brief report on building sqlite-3.3.4 with MinGW/MSYS and tcl84 on WinXP... 1. After configure, a small edit was necessary to the Makefile; for some reason libtool doesn't put .lo objects into .libs subdirectory anymore; there was also an issue reported on the mailing list with stripping the

Re: [sqlite] import

Sorry; Ignore this for now; I see ".output" works OK; my wrapper was stripping something, I think; Best, Randall

Re: [sqlite] Disable index?

one simple trick I first started using with oracle and also use with sqlite is to do the following on the where clause for numerics where filda = fldb+0 for strings where flda = fldb||"" this would cause a index on fldb to be ignored during optimization Jim Dennis Cote wrote: On 2/18/06,

Re: [sqlite] import

Am 19.2.06 um 15:06 schrieb Randall: Hi, Sorry for the basic queries here... If I ".output" with .mode "tabs" , "lines" etc, the resulting text file or csv file cannot be ".imported" by import, as the EOL is not read? Can I fix this easily? Thanks, Randall You didn't tell what you want

[sqlite] import

Hi, Sorry for the basic queries here... If I ".output" with .mode "tabs" , "lines" etc, the resulting text file or csv file cannot be ".imported" by import, as the EOL is not read? Can I fix this easily? Thanks, Randall

Re: [sqlite] Disable index?

Op zondag 19 februari 2006 13:23, schreef Nemanja Corlija: > On 2/19/06, SanjayK <[EMAIL PROTECTED]> wrote: > > I am using a virtual tree control to display columns dynamically when > > needed from the sqlite database. While it works ok for display purposes, > > in certain other operations, I need

Re: [sqlite] Disable index?

On 2/19/06, SanjayK <[EMAIL PROTECTED]> wrote: > > I am using a virtual tree control to display columns dynamically when needed > from the sqlite database. While it works ok for display purposes, in certain > other operations, I need to improve the speed. I found that the new sqlite > random

[sqlite] sqlite, odbc, any gotchas?

If read a bit already and see limitations and benefits in SQlite. Our office still wants to use the GUI present in MS-Access. I like the simplicity of maintaining SQLite plus it's rollback features etc. Later, there are aspirations for a webbrowser interface to same database. Anyone have