Several reasons. Main one is that we won't be allowed as this is a third
party application clinical database. The other one is that it would cause
too much slow-down of the regular clinical front-end application.
This is reporting software and apart from some rare exceptions there is no
writing
Hi Dan,
Thanks for your suggestion.
If you have any choice in the matter, don't use threads. Run all 5
queries from the same thread. You can either run them sequentially,
Running sequentially might trouble me as I have to update more sets of
information at a cause of single event.
or
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
On Fri, 2007-08-10 at 11:25 +0530, Bharath Booshan L wrote:
Hello All,
I am using SQLite in one my application and I require to retrieve around
4-5 sets of information simultaneously. I have opted to run the queries in
separate threads which seems obvious choice here.
However, I came to
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 latter
Scott Baker bakers-464hKcSrpMpWk0Htik3J/[EMAIL PROTECTED] 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
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
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
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);
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
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
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
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.
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
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,
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, using
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.
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
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
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,
20 matches
Mail list logo
