Eric Pankoke a e'crit :
The best way is to just check if the file exists in whatever language
you're using before you call sqlite3_open.
Eric Pankoke
Founder
Point Of Light Software
http://www.polsoftware.com/
-Original Message-
From: fred238 [mailto:[EMAIL PROTECTED]
Sent: Friday, Au
The best way is to just check if the file exists in whatever language
you're using before you call sqlite3_open.
Eric Pankoke
Founder
Point Of Light Software
http://www.polsoftware.com/
-Original Message-
From: fred238 [mailto:[EMAIL PROTECTED]
Sent: Friday, August 10, 2007 11:28 PM
To:
hello,
Is there a way to not create a database while the db file is not found with the
sqlite3_open function ?
Why don't just create a create_table function instead of ?
regards,
fred.
-
To unsubscribe, send email t
On 8/10/07, Brickl Roland <[EMAIL PROTECTED]> wrote:
> where can i find information about how the config-file should look like and
> what is possible?
There is no ~/sqliterc or config file. SQLite is an embedded database
engine; applications use it in application-specific ways.
---
Hi Ralf
Thanks for the tip.
I checked it out, and it's a bit complex, but looks very clean. I'll
probably update to that component set at a later date.
-Henrik
2007/8/10, Ralf Junker <[EMAIL PROTECTED]>:
>
> Hello Henrik Ræder,
>
> >I'm trying to load the FTS2 extension in Delphi, u
Is there a good way/tool to determine what went wrong in a database file
reporting SQLITE_CORRUPT?
The details I have so far are: machine (running Windows XP) locked up hard
while executing our application. Repeatable hard-lock at a certain point.
(Hard lock is defined as no mouse, no keyboard,
I'm looking for your help solving a performance issue:
Master db and an attached db. called A
Table x and table Y are identical in both the master and Attached database.
table Z is built to determine the set of rows to copy and has an index on the
id field.
The goal is to move data from many a
I have solved the failed tests reported a few days ago, and I have now
the proof that none of them is blamed on sqlite.
For what it is worth, here are the details:
The source is sqlite 3.4.1 last updated on August 9
The platforms and compilers are:
- Enterprise 3, 32 and 64 bits, gcc 3.2.3
- En
Brickl Roland <[EMAIL PROTECTED]> wrote:
>
> "Feature Request": Column-definition INT should be parsed
> as INTEGER in sql-code.
>
It is. At least it is for the purpose of computing column
affinity. For the INTEGER PRIMARY KEY you are required to
spell out "INTEGER". We cannot change the latt
Hallo,
where can i find information about how the config-file should look like and
what is possible?
And is there a site with informations about sqlite in other languages avaible?
"Feature Request": Column-definition INT should be parsed as INTEGER in
sql-code.
Sincerely,
Brickl Roland
On Fri, 2007-08-10 at 09:28 -0700, Scott Baker wrote:
> Internally does sqlite store the following SQL statements differently?
>
>
> INSERT INTO table (foo) VALUES (1024);
>
> vs
>
> INSERT INTO table (foo) VALUES ('1024');
Depends on the type specified for 'foo' in the CREATE
TABLE statement.
Scott Baker wrote:
Internally does sqlite store the following SQL statements differently?
INSERT INTO table (foo) VALUES (1024);
vs
INSERT INTO table (foo) VALUES ('1024');
SQLite doesn't store statements. I guess you are asking how the value is
stored.
That depens on how the column was
Internally does sqlite store the following SQL statements differently?
INSERT INTO table (foo) VALUES (1024);
vs
INSERT INTO table (foo) VALUES ('1024');
--
Scott Baker - Canby Telcom
RHCE - System Administrator - 503.266.8253
-
Hello Henrik Ræder,
>I'm trying to load the FTS2 extension in Delphi, using the Aducom
>components. Am really close, but still stuck, and thinking it's a problem
>with the parameter to sqlite3_enable_load_extension().
DISQLite3 (http://www.yunqa.de/delphi/sqlite3/) does not expose such problems.
You might find that using one thread and accessing the four data sets
sequentially yields you a better result. You will use the one Sqlite
cache and get some benefit from not creating and detroying multiple
caches and connections.
Bharath Booshan L wrote:
Hello All,
I am using SQLite in on
Sqlite has a feature where you can contanenate SQL statements and
prepare and step them in a loop. Prepare returns a pointer to the start
of the next statement.
The basic prepare/step/reset activity requires that there be a loop to
handle multiple rows, busy returns and possible errors.
Ste
Stephen Sutherland wrote:
okay i'm trying to use preparestatement and step and finalize.
I have some quick questions about this legacy.c code.
First I notice that it has a while loop within a while loop.
Question: when I implement this prepared statement, will I also need a while loo
Hi
I'm trying to load the FTS2 extension in Delphi, using the Aducom
components. Am really close, but still stuck, and thinking it's a problem
with the parameter to sqlite3_enable_load_extension().
In declaration:
procedure sqlite3_enable_load_extension(db: string; onoff: integer);
stdcall;
On Fri, 2007-08-10 at 11:28 +0200, Jef Driesen wrote:
> When using sqlite3_bind_text() (or a similar function) with
> SQLITE_STATIC, how long does the pointer have to remain valid? As long
> as the sqlite3_stmt is not finalized?
Pretty much. It has to be valid during all subsequent calls to
sql
When using sqlite3_bind_text() (or a similar function) with
SQLITE_STATIC, how long does the pointer have to remain valid? As long
as the sqlite3_stmt is not finalized?
It is clear to me the following will cause no problem:
sqlite3_bind_text (stmt, column, "some text", -1, SQLITE_STATIC);
But
Suppose I have a simple table with an integer primary key:
CREATE TABLE table (
id INTEGER PRIMARY KEY NOT NULL,
name TEXT
);
and insert values without supplying a value for the primary key:
INSERT INTO table (name) VALUES (@name);
Is it guaranteed that the primary key is always positi
Hi, guys.
Dennis Cote wrote:
Stephen,
You should look into using the newer prepare/step API functions
instead of the callback mechanism. It will make your code clearer, and
will probably execute faster as well.
I don't think so. Prepare/step mechanism can invoke productivity of
"INSERT" or
22 matches
Mail list logo