[sqlite] No stdio.h

Hi, I noticed sqlite uses an os abstraction layer, but also uses stdio at the same time (vdbe.c and others). I'm building on an embedded system with a filesystem, but no stdio. Does converting the stdio calls to sqliteOsXXX sound like a good plan? Perhaps we can use dummy filenames for s

[sqlite] cursor

hi is there sth like cursors ? (DECLARE CURSOR FOR SELECT ;) and FETCH,MOVE ? thanks bye ivan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] qualified join

I had a similar problem recently, the way I solved it looks like that (it might not be pretty, but it works) SELECT t1.name, t2.deleted FROM t2 INNER JOIN ( SELECT t2.id, MAX(t2.time) AS last_time FROM t2 GROUP BY t2.id ) AS t3 ON t2.id = t3

[sqlite] qualified join

I have the following two table defs: CREATE TABLE t1(id INTEGER PRIMARY KEY,name VARCHAR(64)); CREATE TABLE t2(id INTEGER,time INTEGER,deleted INTEGER(1) PRIMARY KEY(id,time)); My question is, how can I: "select t1.name,t2.deleted from t1 join t2 using id" but only keep each row where t2.time is

Re: [sqlite] integer primary key initial value

Michael Hunley wrote: This may be a totally rooky question, but better safe than sorry If I declare a table with an INTEGER PRIMARY KEY field s.t. it is an auto-increment, do the first INSERT into it and call sqlite_last_insert_rowid(), will I get back a 0 or something else? Will I ever ge

[sqlite] integer primary key initial value

This may be a totally rooky question, but better safe than sorry If I declare a table with an INTEGER PRIMARY KEY field s.t. it is an auto-increment, do the first INSERT into it and call sqlite_last_insert_rowid(), will I get back a 0 or something else? Will I ever get 0 back (in case it w

RE: [sqlite] Functions & Keywords

Hello again, So is there no way of replicating the SYSDATE keyword in SQLite? I am not too concerned about the underlying mechanics of what it will do, but it would very useful to be able to call user-defined functions taking no parameters without the parentheses... Thanks, Steve -Origin