Günter Greschenz wrote:
hi,
thanks for the quick answer :-)
i always thought there is always an index for "rowid" ? thats the
reason why i implemented it like this...
i need to store a maximum amount of data in the database (e.b. max
10 entries or max 10 days)
any idea how i could impleme
hi,
thanks for the quick answer :-)
i always thought there is always an index for "rowid" ? thats the reason
why i implemented it like this...
i need to store a maximum amount of data in the database (e.b. max
10 entries or max 10 days)
any idea how i could implement it in another way ?
y
Günter Greschenz <[EMAIL PROTECTED]> wrote:
i've created this table and trigger (no index !):
CREATE TABLE msgs (date ntext, type ntext, dir ntext, s integer, f
integer, msg ntext);
CREATE TRIGGER delete_log after insert on msgs begin delete from
msgs where rowid%10=new.rowid%10 and
3 matches
Mail list logo