What's teh best way to do this?
Posted on 1998-06-09
I'm creating a reminders system, in which I've stored the date an time in a
Paradox TimeStamp field called "Date". There is also a logical field
(called Shown) in the table that will keep track of whether the user wants
to see the reminder again after it is displayed. I'd like to do three
1) Display a message when the date & time in the timestamp filed equals Now
(or less than now if "Shown" equals False)
2) Re-display the message in 15 minutes if the user want's to continue to
be reminded. (without changing the value in the Date field if possible).
I know I can use TTimer to check if the data in the timestamp field equals
Now, but suppose I have 20 reminders in the table. It would be very
inefficient scroll through the table every time the OnTimer event kicked
Maybe adding the Date field's data (where Shown = False AND where Date <=
Today) to a StringField at startup, then check the contents through the
OnTimer event??? Don't know if that made nay sense so any suggestions would