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 recomm
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 access
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
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
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 t
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, S
Thanks for your time;
You didn't tell what you want the re-import for, but if it's just for
I am trying to produce a text and/or csv file of data, not of SQL commands,
, available for notepad and/or excel, with routine EOL markers (what does
output use!?...)
I do want to be able to read it ag
Sorry;
Ignore this for now; I see ".output" works OK; my wrapper was stripping
something, I think;
Best, Randall
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 DLL
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
somet
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 de
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.
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 instance?
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: http://messenge
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 hav
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 sqlite3
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 useful,
sqlite3 is available in 5.1 using the pdo extensions.
have a look at www.php.net/pdo
I had the same problem with an app I wrote in delphi to insert records and
used php front end to select records
Lloyd
- Original Message -
From: "jack wu" <[EMAIL PROTECTED]>
To:
Sent: Monday, Febru
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
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 an
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 woul
21 matches
Mail list logo
