Very cool! Congrats!
On 8/4/05, Mike Owens <[EMAIL PROTECTED]> wrote:
> This was posted previously, but in case you missed the subject line,
> here is a restatement.
>
> Google and O'Reilly honored five open source people whose
> contributions over the past year have been exceptional in five
> ca
This was posted previously, but in case you missed the subject line,
here is a restatement.
Google and O'Reilly honored five open source people whose
contributions over the past year have been exceptional in five
categories: Communicator, Evangelist, Diplomat, Integrator, and
Hacker. Richard was a
you can build a .lib from the .def - please read your compilers
documentation. (vc++ comes with lib.exe)
On 8/4/05, Bo Chen <[EMAIL PROTECTED]> wrote:
>
> Hello there,
>
>
> I need sqlite .lib file and .dll file in Windows. I downloaded
> precompiled binaries for Windows. The package only cont
There's a version of the source code download that is configured for
Windows. Just add all the files to a DLL project and compile. If you
don't use TCL (we don't), then just remove tclsqlite.c from the project.
Don't forget to define THREADSAFE in your preprocessor defines!
(Or you could learn
Hello there,
I need sqlite .lib file and .dll file in Windows. I downloaded
precompiled binaries for Windows. The package only contains a .dll file
and a .def file. I also downloaded the source code. However, it does not
include Makefile and other utility files. Does anyone have idea where I
Also the column is a tinyint..Guess that shouldnt matter..But just FYI...
On 8/4/05, R S <[EMAIL PROTECTED]> wrote:
> Hi,
> I have a table with a large # of indices (almost as the # of
> columns) in the table. SQLite works beautifully with most constraints
> and magically takes a long time for a
Andrew,
I though I should point out a couple of problem with my proposed case
statement before you run into them. A case expression can only return a
single value, so you can't return name and otherdata at the same time,
you can only get one field (otherdata in this case). Also the subselects
Hi,
I have a table with a large # of indices (almost as the # of
columns) in the table. SQLite works beautifully with most constraints
and magically takes a long time for a query with constraints on the
column with its index last created. Any limitations on the max # of
indices allowed for a tabl
Cool! When the same answers appear so quickly, it must be correct! Thanks to
Donald & Christian.
On 8/4/05, Griggs, Donald <[EMAIL PROTECTED]> wrote:
>
>
> Re: how do I convert databases?
>
> --
> The command-line utility (for both versions) has a nice ".du
Re: how do I convert databases?
--
The command-line utility (for both versions) has a nice ".dump" command, and
you just feed sqlite3 on it's output. If you don't need to keep the .dump
output file you can just pipe it:
sqlite OLD.DB .dump | sqlite3 NEW.DB
Hi Dan,
I think we need to know this here:
How do your SELECT statements look like?
What's the keyword your international clients use - to find what data?
And what's the data in the table?
What might be already a help is:
" The LIKE operator is not case sensitive and will match upper case
ch
On 8/4/05, Dan Wellisch <[EMAIL PROTECTED]> wrote:
> Are you saying that 8859-1 encoding does not work with these
> international versions of MS Windows, so we would need to ensure
> that we are putting UTF-8 chars in the data? This would make sense
> if the OS uses UTF-8 chars. in the WHERE clause
On Thu, 4 Aug 2005, Ray Mosley wrote:
>I started using 2.8 because I still have Tcl 8.3; If I convert to Tcl 8.4 to
>go to SQlite 3, how do I convert databases?
Use the sqlite/sqlite3 shells to dump then restore the database in SQL
statement format:
$ sqlite sqlite2db .dump | sqlite3 sqlite3db
Austin:
Are you saying that 8859-1 encoding does not work with these
international versions of MS Windows, so we would need
to ensure that we are putting UTF-8 chars in the data? This would make
sense if the OS uses UTF-8 chars. in the WHERE
clause so that it is searching against 8859-1 chars.
I started using 2.8 because I still have Tcl 8.3; If I convert to Tcl 8.4 to
go to SQlite 3, how do I convert databases?
--
Ray Mosley
D. Richard Hipp wrote:
On Thu, 2005-08-04 at 12:59 -0700, L. S. wrote:
What is the prescribed way to create the complete documentation (without
having to learn yet another scripting language--or whatever it is)?
make doc
Thanks!
On 8/4/05, Dan Wellisch <[EMAIL PROTECTED]> wrote:
> We just put a SQLlite application in production. It handles the
> display of ISO 8859-1characters just fine if they appear in the
> search results.
>
> However, users that are running German, French, etc. versions of
> Microsoft Windows are comp
Dear all,
I have a "meta" application that's a bit like the sqlite shell (except
it's not interactive) in which people write statements that are parsed
by Perl that contain SQL statements that are passed *unparsed* by Perl
to SQLite via DBD::SQLite.
Some of the queries are long.
To save time, us
Hello:
We just put a SQLlite application in production. It handles the display
of ISO 8859-1characters just fine if they appear in the search
results.
However, users that are running German, French, etc. versions of
Microsoft Windows are complaining that search results are coming
back with 0
On Thu, 2005-08-04 at 12:59 -0700, L. S. wrote:
> What is the prescribed way to create the complete documentation (without
> having to learn yet another scripting language--or whatever it is)?
>
make doc
--
D. Richard Hipp <[EMAIL PROTECTED]>
Ralf Junker wrote:
Hello L. S.,
you can create a HTML version by running the TCL scripts which are part of the
tarball sources.
And how do I do that? I found enough info about TCL to do...
'tclsh foo.tcl > foo.html'
but that fails on some files.
What is the prescribed way to create t
Andrew Gatt wrote:
A ha! This seems perfect, one quick question, when you say "id values
are small enough", are we talking about an integer size limit hard
coded into sqlite? I mean with the *10 is the value of id ultimately
limited to 6553? This may cause an issue, however if we are talking 3
>>Donald,
>>
>>Thanks for your reply, its all a bit new to me, so i'm still trying to get my
>>head round it and hopefully be able to explain myself better.
>>
>>I'm actually creating the unique ids, it is just a number.
>>
>>I now think my understanding of an attached database is wrong, my first
Andrew Gatt wrote:
Donald,
Thanks for your reply, its all a bit new to me, so i'm still trying to get my
head round it and hopefully be able to explain myself better.
I'm actually creating the unique ids, it is just a number.
I now think my understanding of an attached database is wrong, my
I would just like to offer my congratulations to D. Richard Hipp for
receiving the Open Source Integrator Award for SQLite.
http://osdir.com/Article6677.phtml
Your work is appreciated.
enjoy,
-jeremy
--
Jeremy Hine
Aaron Schneider wrote:
Hello All,
I've using SQLite 2.8.16 with a music management application, and I'm
trying out why certain queries take a long time and to figure out how
SQLite uses my indexes. I've got a master "media" table with a couple
of auxiliary tables like "artists", "albums", and
On 8/3/05, Walter Meerschaert <[EMAIL PROTECTED]> wrote:
> As a courtesy to my users, I wish to pop up a message thingy telling the user
> when the program is waiting for the database to not be busy. Right now I
> register a busy handler, and so I know how long I have been waiting, because
> we
> I now want to be able to give the option of opening a second database file,
> with the same table structure - which i believe is acheived using the ATTACH
> command. However the ids sent to the client still need to be unique, it is my
> understanding that a SELECT command will treat both datab
Donald,
Thanks for your reply, its all a bit new to me, so i'm still trying to get my
head round it and hopefully be able to explain myself better.
I'm actually creating the unique ids, it is just a number.
I now think my understanding of an attached database is wrong, my first
thoughts were t
Hi Andrew,
Perhaps I shouldn't be replying since I don't think I'm understanding your
question fully.
When you wrote:
"with each entry having a unique id"
did you mean that you are creating a unique identifier, or instead that you
are making use of the ROWID within sqlite?
Regarding:
"it
how do you tell sqlite the request? Maybe it's just the terminating
semicolon that's missing:
Hum... Ok, I'm a bit ashamed right now... I guess this is expected from
too much MySQL bad habits... Thanks anyway, it works.
Did any of you use sqlite with zeoslib ? I'm experiencing some
unexpecte
hi all
I am new to sqlite and to tcl as well. I have tried to install dgSQLite3 and it
returns the following error
---
Error in startup script
---
wrong # args: should be "load fileName ?packageName? ?interp?"
while executing
"load C:/Document
--- R S <[EMAIL PROTECTED]> wrote:
> Hi,
>I have a requirement where I need to update 2 tables in 2 separate
> DBs within a transaction. Do I need to attach the second table to the
> first at the start of the transaction? As I understand SQLite commits
> a transaction across a single DB only
Hi,
I'm not sure if what i am trying to acheive is possible, but if i explain what
i'm trying to do someone may be able to point me in the right direction.
I have a database table that holds some information, with each entry having a
unique id. So when i query the database i can get a list of i
Boris Herbinière-Sève wrote:
> Incomplete SQL: SELECT r.Id, r.IdParams, r.SagN2, r.SagL2, r.SagN3,
how do you tell sqlite the request? Maybe it's just the terminating
semicolon that's missing:
> $ echo "select * from t1 as tab where tab.domain='dom1'" | sqlite3 test.db
> Incomplete SQL: select *
Hello,
I try to use SQLite (2.8) for a project, and ran into (what seems to be)
a little problem.
A MySQL-valid SELECT request only output 'Incomplete SQL' with SQLite. I
guess my SQL isn't standard enough, but I can't find what's wrong.
Incomplete SQL: SELECT r.Id, r.IdParams, r.SagN2, r.S
36 matches
Mail list logo