Re: [sqlite] SQLITE_DEFAULT_FOREIGN_KEYS support please

Yes. I want too that default. But I still need it in de ODBC driver because I don't have a way to enable foreign keys with MS Access via ODBC. > Currently the code base supports SQLITE_DEFAULT_RECURSIVE_TRIGGERS > which controls the default setting for PRAGMA recursive_triggers. > > Can someone

Re: [sqlite] SQlite query performs 10 times slower than MS Access query

Why you change the query? Use de Access version or someone without joining a subquery. Is preferible to join table to table (to more tables) than join table to subqueries. Emilio Doyel5 escribió: > I have a 800MB MS Access database that I migrated to SQLite. The structure of > the database is

Re: [sqlite] how do I use more than one column as a "combined key"?

I don't undertand what is your question? a) You know to do it in SQL but you don't in SQLite or b) You dont know how to do it in any SQL yaconsult escribió: > SQL newbie here. Sqlite has been a fantastic tool for analyzing, comparing > and correcting lots of account information. But I've hit a

Re: [sqlite] problem with sqlite in c#.net

do you try a COMMIT? manp escribió: > when i execute a query like this > UPDATE setting SET value="red" WHERE name="color" > the row will update temporary while app is running , when i close app noting > appear in DB > i use ManagedSQLite dll ___

Re: [sqlite] Default text column values

Are you sure? Send us yours commands that prove that. I wrote: CREATE TABLE CurrentValues ( Time_Stamp DATETIME DEFAULT CURRENT_TIMESTAMP, Sensor_ID WORD DEFAULT 1 NOT NULL, Sensor_Name VARCHAR(20), Sensor_Type VARCHAR(8), Sensor_Value FLOAT DEFAULT 0 NOT NULL, Sensor_Units VARCHAR(15)

Re: [sqlite] Index and ORDER BY

(sorry about my poor english) I think that the problem doesn't correct by creating a DESC index. The problema was at de 'where clausula': (events.eid<=3261976) For some reason SQLITE doesn't optimize the query to use the index to locate the last index item that have type=22 and eid<=3261976.

Re: [sqlite] concatenation operator

You must use || (doble pipe) to concatenate strings or what ever. Note that || don't concatenate nulls 'CHE' || null is null sorry about my poor english Joanne Pham escribió: > Hi All, > I had the table, appMapTable as defined below: > appId, appName, appType > 1, appname, 2 > 2, appname, 3 >

Re: [sqlite] Insert date

try inserting year/month/day Emilio > > I have the following table > CREATE TABLE Sighting ( > SightingIdinteger PRIMARY KEY AUTOINCREMENT NOT NULL, > SpeciesId integer, > LocationIdinteger, > SightingDate date, > Note nvarchar(100) > ); > > and the following

Re: [sqlite] paged query in sqlite

another aproach is to use OFFSET and LIMIT in your select queries: select * from table limit 100 offset 1 then select * from table limit 100 offset 101 then select * from table limit 100 offset 201 etc. Shailesh Madhukar Birari escribió: > Does Sqlite support Paged query? what I mean is on

Re: [sqlite] UPDATE in multiple same table

Thank's It works also in PostgreSQL! Emilio Platzer Igor Tandetnik escribió: > "Emilio Platzer" <[EMAIL PROTECTED]> wrote > in message > news:[EMAIL PROTECTED] >> I try (and not works): >> >> CREATE TABLE nodes( >> id integer primary key, >

Re: [sqlite] UPDATE in multiple same table

Thanks > "Emilio Platzer" <[EMAIL PROTECTED]> wrote > in message > news:[EMAIL PROTECTED] >> I want to UPDATE a field of one table with data of rows of the same >> table. >> >> For example to calculate the depth of a node in a tree >> >

[sqlite] UPDATE in multiple same table

I want to UPDATE a field of one table with data of rows of the same table. For example to calculate the depth of a node in a tree update nodes as s set s.depth= (select f.depth+1 from nodes as f where f.id=s.father_id) where s.depth is null; I could do this in a ugly