Hello,
Le 22-nov.-06 à 21:08, Igor Tandetnik a écrit :
Pyramide-Ingenierie Developer List
<[EMAIL PROTECTED]> wrote:
I try to use "sqlite3_reset()" and/or "sqlite3_clear_bindings()"
before "re-binds" and "re-step" but I always get an error 21
(SQLITE_MISUSE) when I am calling them on a
hello,
i just notice something strange in sqlite. i have a db
file which is a copy of another one(not a symlink).
when i delete one row from a table in one db file and
the same row got delete from the same table in the
other db file as well. this happens when i tried
dropping a table.
this is
Thanks for your help!
Sorry for just used an improper example for my question ;-) . That
example dosen't have any logical meanings.
I'd just like to know how to make the UNION occurs before the INTERSECT
operation.
Your advice is to import an extra SELECT clause on the UNION results.
Will this
What is the fastest way in VB to transfer an ADO recordset to a SQLite .db
file? I am using the dll from TerraInformatica, SQLiteDb.dll.
This is what I have now:
Set oSQLConn = New SQLiteDb.Connection
With oSQLConn
.ConnectionString = "Data Source=" & strReadSQLiteDB
.Open
Pyramide-Ingenierie Developer List wrote:
Hello,
I am using SQLite 3.3.8 library on Mac OS X using XCode 2.4.1 (gcc
4.0)...
I try to compile only once an SQL instruction like "INSERT INTO Book
(author_fk,title,date,time,price,created) VALUES (?,?,?,?,?,?);" and
insert multiple rows through
Hello,
Le 22-nov.-06 à 20:00, Igor Tandetnik a écrit :
I try to use "sqlite3_reset()" and/or "sqlite3_clear_bindings()"
before "re-binds" and "re-step" but I always get an error 21
(SQLITE_MISUSE) when I am calling them on a already used
sqlite3_stmt...
sqlite3_reset should work. You are
I think it would be a good addition to the SQLite API.
Make a ticket, post the patch and see if DRH accepts it.
As far as "circumventing" the API goes, for your use in RSQLite
just make a copy of the function in question, rename it, have the
function accept just a single argument (const char*
Pyramide-Ingenierie Developer List
<[EMAIL PROTECTED]> wrote:
I try to compile only once an SQL instruction like "INSERT INTO Book
(author_fk,title,date,time,price,created) VALUES (?,?,?,?,?,?);" and
insert multiple rows through a (sqlite3_bind_xxx / sqlite3_bind_step)
loop but I everytime got
Dixon Hutchinson
wrote:
Consider the sequence below with SQLite 3.3.7 on Windows:
sqlite> CREATE TABLE xyzzy
...> (
...> comp TEXT,
...> parent INTEGER,
...> ROWID INTEGER PRIMARY KEY AUTOINCREMENT,
...> UNIQUE(parent, comp)
...> );
sqlite> .indices
Hello,
I am using SQLite 3.3.8 library on Mac OS X using XCode 2.4.1 (gcc
4.0)...
I try to compile only once an SQL instruction like "INSERT INTO Book
(author_fk,title,date,time,price,created) VALUES (?,?,?,?,?,?);" and
insert multiple rows through a (sqlite3_bind_xxx /
Consider the sequence below with SQLite 3.3.7 on Windows:
sqlite> CREATE TABLE xyzzy
...> (
...> comp TEXT,
...> parent INTEGER,
...> ROWID INTEGER PRIMARY KEY AUTOINCREMENT,
...> UNIQUE(parent, comp)
...> );
sqlite> .indices xyzzy
Joe Wilson <[EMAIL PROTECTED]> writes:
> This is the internal code that sqlite uses to convert the
> declaration type to the REAL, INT, TEXT, BLOB types.
>
> Happy hacking...
Thanks for the pointer. I can create the appropriate struct and call
sqlite3AffinityType and this gives me a solution.
In VB with an ODBC connection to an Interbase database it is possible to
move data from Interbase to Access with a SQL construction like this:
INSERT INTO
ACCESSTABLE (SUBJECT_TYPE, READ_CODE, TERM30, TERM60)
SELECT
IB.SUBJECT_TYPE, IB.READ_CODE, IB.TERM30, IB.TERM60
FROM
IBTABLE IB IN
[ODBC;
On 21/nov/06, at 17:07, Christian Smith wrote:
Sergio 'OKreZ' Agosti uttered:
Hi, I've a performance problem with an application written in
realbasic, using a sqlite db: some of the tables have UNIQUE
fields, and I've no problem with the default COLLATE mode
(BINARY); but if I set
Nan Ye wrote:
If I used UNION and INTERSECT in compound SELECTs, how to change
the
default priority?
For example,
SELECT id FROM sample_a WHERE value > 3.0 INTERSECT SELECT id
FROM sample_b WHERE value < 4.0 UNION SELECT id FROM
Hi Rama!
Unfortunatelly I haven't any experience with Linux. But I reproduce
situation on my system (Win XP), and have noticed that after kiliing
Process A files
~testDb.db3
~testDb.db3-journal
are usable for Process B. Process B just reuse file ~testDb.db3-journal
file for own needs, and
Hi,
If I used UNION and INTERSECT in compound SELECTs, how to change the
default priority?
For example,
SELECT id FROM sample_a WHERE value > 3.0 INTERSECT SELECT id
FROM sample_b WHERE value < 4.0 UNION SELECT id FROM sample_b WHERE
value > 7.0;
The default results is that it
17 matches
Mail list logo