hi DAniel
i had similar probme and at the end i had to build my own
tool to migrate from csv to sql ...
maybe it will solve your problem too?
regards
e.
Цитат на писмо от Daniel de Matos Alves
<[EMAIL PROTECTED]>:
> PLEASE, read my e-mail, i really need help ;-)
>
>
> I am trying to import dat
PLEASE, read my e-mail, i really need help ;-)
I am trying to import data from a file using sqlite3 command line, and
the tcl bind. But I aways get error about the Number of Columns. Sqlite
always says that I am trying to put less columns than the number of
columns defined in the table.
I
Robert L Cochran wrote:
I have a database I created in SQLite 3.2.5, then updated with
subsequent versions up to 3.2.7. There are several tables.
Version 3.3.1 has a new file format and I'd like to convert the database
file to this new format. How do I do that?
sqlite3 olddatabase .dump | sq
Robert L Cochran <[EMAIL PROTECTED]> wrote:
> I have a database I created in SQLite 3.2.5, then updated with
> subsequent versions up to 3.2.7. There are several tables.
>
> Version 3.3.1 has a new file format and I'd like to convert the database
> file to this new format. How do I do that?
>
I have a database I created in SQLite 3.2.5, then updated with
subsequent versions up to 3.2.7. There are several tables.
Version 3.3.1 has a new file format and I'd like to convert the database
file to this new format. How do I do that?
Thanks
Bob Cochran
Greenbelt, Maryland, USA
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
SQLite was tested in the same configuration that it appears on the
website. It was compiled with -O6 optimization and with the -DNDEBUG=1
switch which disables the many "assert()" statements in the SQLite
code. The -DNDEBUG=1 compiler option ro
Darren Duncan <[EMAIL PROTECTED]> wrote:
>
> Alternately, and probably more elegantly,
>
>SELECT name FROM people WHERE name LIKE '%' || ? || '%'
>
Yes, it is mome elegant. Unfortunately, SQLite is stupid and
does not optimize this well. It computes the concatenation once
per row instead
At 10:10 AM -0700 1/18/06, Robert Simpson wrote:
- Original Message - From: "Marvin K. Bellamy"
<[EMAIL PROTECTED]>
I want to prepare a statement like this one:
SELECT name FROM people WHERE name LIKE '%?%'
But, it looks like host parameters inside string literals aren't
parsed. Any
- Original Message -
From: "Marvin K. Bellamy" <[EMAIL PROTECTED]>
I want to prepare a statement like this one:
SELECT name FROM people WHERE name LIKE '%?%'
But, it looks like host parameters inside string literals aren't
parsed. Any clues as to how I pull this off or if the paramete
I want to prepare a statement like this one:
SELECT name FROM people WHERE name LIKE '%?%'
But, it looks like host parameters inside string literals aren't
parsed. Any clues as to how I pull this off or if the parameter really
will be parsed?
Hallo maxi musterfrau, am Mittwoch, 18. Januar 2006 17:15 schriebst du:
> Hi Jan,
>
Ah, thanks for your answer. I already thought I was misbehaving as anybody
else ignored my question.
> i had a similar problem. After a long debug session i found out that the
> error cames from btree.c (+- line
Hi Jan,
i had a similar problem. After a long debug session i found out that the error
cames from btree.c (+- line 1000) after the call get2bytes (if res > ...)
return ... .
so in my database i saw that there are a lot of FFŽs - anyway.
here are the code snippet.
btree.c
--
On 1/18/06, Steve O'Hara <[EMAIL PROTECTED]> wrote:
> if you did, then you'd notice that for regression testing, a flag is set
> that forces the random() function to be seeded on the same number each
> time.
I hope it's a run time flag... ;)
Thanks for the info.
[EMAIL PROTECTED] wrote:
> hi guys,
>
> this query works in sqlite 3.x
>
> SELECT * FROM logs LIMIT (SELECT lmt FROM base);
>
> but in sqlite2.8.17 it generates error .. near to ( ! Is
> this normal??
>
SQLite version 2.x required that LIMIT and OFFSET be integer
constants.
--
D. Richard Hipp
hi guys,
this query works in sqlite 3.x
SELECT * FROM logs LIMIT (SELECT lmt FROM base);
but in sqlite2.8.17 it generates error .. near to ( ! Is
this normal??
regards
e.
-
Slon.bg ™
Симпатичният магазин за
книги, DVD, игри и музика
http://www.slon.bg
Thank you.
After running VACUUM, "pragma integrity check" now simply returns "OK"
(although some of the data in the DB appears to be corrupt).
Anyway it was just a test database and no important information was lost, I
posted my message just to learn about the odd output from "pragma integrity
che
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg] On Behalf Of Paolo Vernazza
Sent: 18 January 2006 11:30
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] [RBL] [sqlite] Randomly ordering results
Steve O'Hara ha scritto:
> From:
[EMAIL PROTECTED]
>
[mailto:[EMAIL PROTECTED]
> rg] On Behalf Of
Hi All,
I am a newer for using the SQLite library. I want to
using the library for an embedded project.
There are some limitation in our project.
heap size is: 6M Bytes
I'm using Sqlite 3.2.8 on a neither unix nor windows platform.
I have overwrited the malloc()/free()/realloc() functions.
I me
Zibetti Paolo <[EMAIL PROTECTED]> wrote:
> I have an SQLite 3 database for which the "pragma integrity check" returns:
>
> integrity_check
> *** in database main ***
> On tree page 17 cell 0: 2nd reference to page 164
> Page 50 is never used
> Page 53 is never used
> Page 57 is never used
> Page 5
Steve O'Hara ha scritto:
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg] On Behalf Of [EMAIL PROTECTED]
Sent: 17 January 2006 17:37
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] [RBL] [sqlite] Randomly ordering results
"Steve O'Hara" <[EMAIL PROTECTED]> wrote:
The standard SQLite f
Hello Carl Jacobs,
You are using Delphi? Have you checked out my DISQLite3 Delphi port which
does not require the sqlite3.dll but compiles directly into any executable:
http://www.yunqa.de/delphi/sqlite3/
I have not seen any of the IDE problems you described when running / debugging
applic
Hello Cariotoglou Mike,
I can confirm your findings for 3.3.1.
Mike, mabe it is worth posting a bug tickt before the next release? Or have you
done so already?
Ralf
>can you verify and fix, pls?
I have an SQLite 3 database for which the "pragma integrity check" returns:
integrity_check
*** in database main ***
On tree page 17 cell 0: 2nd reference to page 164
Page 50 is never used
Page 53 is never used
Page 57 is never used
Page 58 is never used
Page 59 is never used
Page 60 is never used
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg] On Behalf Of [EMAIL PROTECTED]
Sent: 17 January 2006 17:37
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] [RBL] [sqlite] Randomly ordering results
"Steve O'Hara" <[EMAIL PROTECTED]> wrote:
> The standard SQLite function random() is actually
Take it easy Jay, being a little sensitive aren't we.
I'm merely pointing you to the "trivia" within the SQLite package that
actually solves the problem - as it states in the SQLite doco, the
source code is a major part of the documentation. So, if you don't look
at the source code you're going to
25 matches
Mail list logo
