implement a trigger that count the number of rows :
if count(rows) = 500
then delete the first row
Julien LEFORT wrote:
Hi,
I would like to implement a log table with a finite dimension, for exemple a
table with 500 records, and when the last record is set in the table I would
like to come back at the first tuplet and write over the previous value
recorded. I think it's the way SQLite journal is implmented.
Is there any way to declare this table with these properties included, so I
don't have to add code to do this function?
Thanks
Julien
----------------------------
Julien LEFORT
Com2gether
16, Allée de la verte vallée
14000 CAEN
tel : +33 2 31 15 61 42
fax : +33 2 31 53 76 14