The way this table works is that when an insert is made, the trigger is activated. The trigger looks to see if there are more than a set number of records. If so, the oldest record(s) are deleted by the trigger. This is accomplished using an auto increment field. This number increases by one on each insert. Therefore I know that if the key field is greater than my limit I can safely delete any record whose key field is less than the max key minus the limit. Hope this helps.
Chris _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users