Navigation bar
  Home Print document Start Previous page
 66 of 234 
Next page End  

Gravitybox Schedule Primer
Page 64 
1998-2004 Gravitybox Software LLC
  Next i
  'Deallocate objects
  Call Db.Close
  Set Db = Nothing
End Sub
The Categories screen is setup in a very similar way. This only difference being
that it has the extra property of “Color” defined. The loading and saving of the
categories is almost identical. Though not a part of this database example, a Providers
collection could also be defined similarly. Each ScheduleItem on the schedule has a
“Provider” property that may be mapped to an element in the schedule’s “Providers”
collection. This is used to define a set of people associated with a schedule. They too
may have a related color, that displays in the appointment’s left margin, if need be. 
This concludes the database example. There are many ways to implement this
functionality. The proposed methods are only guidelines. There are schemes that differ
in complexity but accomplish the same task: database saves and loads. This was
simple scheme and may not scale well. However for most applications there may be no
advantage to spending countless weeks optimizing convoluted algorithms. Then again
may be there will be for your situation.
http://www.purepage.com