Hi,
I have a problem which I am hoping someone can help me with.
I am writing an application with a Memo function. Basically an electronic post-it note - the idea being that a user can write a note reminding them (or someone else to do something at a specific time). My hope is to attach a 'trigger time' to each memo, so that it only becomes active after it is triggered.
The way I envisioned accomplishing this was to store a boolean field 'active' within the table holding the memos, which would become yes - i.e. the memo would activate - once the trigger time was reached.
I am having trouble working out how to do this however, so any suggestions would be welcome.
P.S. Ideally I would like this to be all automatic, rather than the user having to click a button to update.
I have a problem which I am hoping someone can help me with.
I am writing an application with a Memo function. Basically an electronic post-it note - the idea being that a user can write a note reminding them (or someone else to do something at a specific time). My hope is to attach a 'trigger time' to each memo, so that it only becomes active after it is triggered.
The way I envisioned accomplishing this was to store a boolean field 'active' within the table holding the memos, which would become yes - i.e. the memo would activate - once the trigger time was reached.
I am having trouble working out how to do this however, so any suggestions would be welcome.
P.S. Ideally I would like this to be all automatic, rather than the user having to click a button to update.
