#13 Automatic cleanup options requested

[Anonymous]

Exported from Bugzilla, issue 3274.

--- Comment added on 6/6/02 8:53:20 AM ---
From ng thread:

Are expired events automatically removed from the "events.ff2" database for
VPI? If not how do we do this in code?

Expired events are not automatically removed from the database. You can
easily do this by executing an SQL statement on the Events table i.e.

DELETE FROM Events WHERE ResourceId = :pmResource AND RepeatCode = 0 AND
EndTime < :pmDate

So if I understand you correctly I just treat those VPI databases like I
normally would for any database I am using which I guess makes sense, if not
more then a bit disappointing. I guess I had expected more "automation" from
VPI then apparently is there. As a side note the manual while good on the
tech side in mentioning properties, methods, etc really does not give you a
good feel for how it all comes together and is used in normal operation and
tends to be more confusing then helpful.

An "Auto Cleanup" procedure would be a useful addition perhaps to the VPI
wishlist here especially since as I understand it VPI is loading into memory
and traversing the data anyway. Perhaps a boolean property option called
"AutoClean" which when set to TRUE would trigger an automatic deletion for
any records that are earlier then the present date or time when the data is
loaded from the events table.

Thanks for your time and reply.

--- Comment added on 6/7/02 3:19:12 PM ---
I think that this is the developers responsibility. That said, maybe in the
future, this can be added as canned functionality but I have too much to do
without worrying about this.