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,
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
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
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,
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
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
-
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
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
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
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
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.
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);
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
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);
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
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"
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
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
25 matches
Mail list logo