Re: [sqlite] sql stack using sqlite

2007-05-10 Thread Ken
I think i found an ok solution: (note I've updated my own insert statements from the OP) drop table purg; create temporary table purg (id integer primary key, tbl); -- Use the fact that the Puging tables C unique ID is always after table A's data. insert into purg select distinct

[sqlite] sql stack using sqlite

2007-05-09 Thread Ken
Id like to get your ideas on implementing a stack using sql tables. table a, contains references to b table b contains refernce to a table c contains delete entries for A (but b must also be purged!) My processing forces me to load all of a,b and c. There may be cases where table C