> > SELECT * FROM Files WHERE extension IN (:extension)
Do you bind extensions as follows?
sqlite3_bind_text16( stmt, 1, L"'mp3','avi','ogg'" );
-
To unsubscribe, send email to [EMAIL PROTECTED]
I have a table and indices as follows;
CREATE TABLE employee(name TEXT,salary INTEGER,job TEXT);
CREATE INDEX idx_emp_salary_job ON employee(salary,job);
CREATE INDEX idx_emp_job ON employee(job);
When I use the following query, SQLite seems to use idx_emp_salary_job
for both WHERE and GROUP
TED]>:
On Sat, 2007-03-10 at 14:11 +0900, Brownie wrote:
> Hi,
>
> I have two questions about shared cache mode of SQLite.
>
> 1. When is shared cache of SQLite deallocated?
> A last call of sqlite3_close()? Or end of thread procedure?
The former. The shared cache (and shared schem
Hi,
I have two questions about shared cache mode of SQLite.
1. When is shared cache of SQLite deallocated?
A last call of sqlite3_close()? Or end of thread procedure?
2. Can I use read_uncommitted isolation in the following case?
(Connection1 and Connection2 is established by the same thread
It would be nice if sqlite stored a change count in the database that was
easily accessible.
CREATE TABLE counter_table(n INTEGER);
INSERT INTO counter_table VALUES(0);
CREATE TRIGGER counter_trigger_insert
AFTER INSERT ON yourtable
FOR EACH ROW BEGIN
UPDATE counter_table SET n = n + 1;
END;
Currently, SQLite uses UNICODE version of Win32 API on Windows implementation.
But a lot of APIs of UNICODE version was not provided for Win95/98.
So, you cannot use SQLite on Win95.
Regards,
-
To unsubscribe, send
I tried this call. It works. But, the db file is created only with the first
character name
and the extenstion is also missing. (its like 't')
I think that your compiler's wchar_t is 32bit.
But sqlite3_open16() requires 16bit characters.
Try the following code.
sqlite3_open16(
7 matches
Mail list logo