- Original Message -
From: "nbiggs" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Wednesday, March 01, 2006 10:24 PM
Subject: [sqlite] Failing Transaction Help.
> In my application, I am using a transaction to insert about 10 records
> at a time. The pr
In my application, I am using a transaction to insert about 10 records
at a time. The problem is that if one of the statements in the
transaction fail, commit is not being executed. When I try creating
another transaction, I get a constant error message "can not create a
transaction within a
select name from sqlite_master where type='table'
That will get you the names of tables in the database.
-Original Message-
From: Eugen Stoianovici [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 09, 2006 3:57 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] How to read column names
Are you using SQLite that is built into PHP5? That SQLite version is
2.8.17, or at least it is on my pc. Anyway, you might want to consider
switching to a newer version of SQLite and using PHP's PDO functions
which will allow you to connect to a SQLite3 database.
In my application, I
I get the following error if I try to use the IF NOT EXISTS function.
If I take out the "IF NOT EXISTS", the statement creates the index.
The same happens when I try using IF NOT EXISTS in a CREATE table
statement.
CREATE UNIQUE INDEX IF NOT EXISTS idx_table ON table (field1, field2);
SQL error:
Thanks for everyone's input, that's what I wanted to hear.
-Original Message-
From: Teg [mailto:[EMAIL PROTECTED]
Sent: Friday, January 27, 2006 2:06 PM
To: nbiggs
Subject: Re[2]: [sqlite] Save my harddrive!
Hello nbiggs,
My users typically download between 3 to 40 gigs of data a day
PROTECTED]
Sent: Friday, January 27, 2006 12:06 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Save my harddrive!
- Original Message -
From: "nbiggs" <[EMAIL PROTECTED]>
>
> My application generates about 12 records a second. I have no
problems
> storing the
My application generates about 12 records a second. I have no problems
storing the records into the database, but started thinking that if I
commit every 12 records, will my hard drive eventually die to extreme
usage? During a 24 hour period up to 1 million records will be
generated and
What would be a good example of reusing the statement? Why not just
execute the SQL again?
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 26, 2006 12:21 PM
To: SQLite
Subject: [sqlite] Re: Difference between finalize and reset.
nbiggs <[EM
Thanks
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 26, 2006 12:21 PM
To: SQLite
Subject: [sqlite] Re: Difference between finalize and reset.
nbiggs <[EMAIL PROTECTED]> wrote:
> Can somebody please explain the differenc
Can somebody please explain the difference between the sqlite3_finalize
and sqlite3_reset functions.
Do I just call finalize after calling prepare and step, or do I need to
call reset also? Looking at the source code, it looks like the exec
function just uses prepare, step and finalize.
Can an insert trigger cause an update trigger to be fired also? My
triggers are listed below. I want tgr_on_insert to fire tgr_on_update.
--
Thanks Dennis, I will give that a shot.
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Monday, January 23, 2006 11:20 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Decimal conversion
nbiggs wrote:
>I was using version 3.2.1. I downloaded 3.3.1 and y
and then loaded 3.3.1 from the .sql
files.
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 19, 2006 2:31 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Decimal conversion
nbiggs wrote:
>When I try executing the command I get 'SQL error: n
My query is
as follows:
Select round(field, 1), count(*)
from table
group by round(field, 1);
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 19, 2006 1:31 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Decimal conversion
nbiggs wrote:
>How
How do I convert the number 49.991 to just 49.9 in a select statement?
Using the round(weight, 1) returns 50.0.
Is there a truncate function?
Nathan Biggs
Hello,
I have created some wrappers to call the sqlite3.dll. I just wanted to
make sure that I have all the wrappers I need to use sqlite. It is
working, I just wanted to make sure that I am making all the calls in
the correct order.
To Open:
sqlite3_open
To Execute:
sqlite3_prepare
17 matches
Mail list logo
