-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Gilles Ganault wrote: > I need to write an application to manage appointments. Most of them > are recurrent, with no end-date, while others are one-shots, and the > user must be able to schedule reccurent appointments but be able to > tweak some of them if need be.
BTW the way most apps, phones and even standards manage this is by storing a list of events each of which has start and end dates for repeating, and a list of exceptions. A one shot event would have no start or end date. An event that repeats forever would have a start date but no end date. The exceptions override existing repeating events. For example say you have an event that repeats every Tuesday at 3pm. If I want it to be 4pm for next Tuesday then I'd create an exception event pointing at the original but with a different time. You also need exception events that can cancel an existing one. In your user interface or equivalent you have to establish when a user is editing a repeating event whether they are changing just that one instance or the series. The former edits/creates exceptions and the later edits the original. Most applications just flat out ask you when editting which one it is. You should also look into vCalendar/iCalendar standards since that will make import/export easier and make your life easier if you structure your data similar to what they require. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFIvMA1mOOfHg372QQRAmY4AJ9JC2Muslq/ollOwCBuVK2nBRTJvgCfYKBM LnYj+ZCEXTIDK0Dzios7yKI= =5wtg -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users