Sample Database

4 posts, 0 answers
  1. RAHUL
    RAHUL avatar
    7 posts
    Member since:
    May 2012

    Posted 02 Jun 2012 Link to this post

    Hi
    I have started working on Telerik scheduler few days back.
    I am facing problems in database structure.
    I want to know Whether in Appointments table the RecurrenceParentID is a foreign key to the ID of same table or not? Please clear this with detail of RecurrenceParentID and how can i use it ..
  2. Plamen
    Admin
    Plamen avatar
    3049 posts

    Posted 04 Jun 2012 Link to this post

    Hi Rahul, 

     
    The RecurrenceParentID field is not a foreign key to the ID. You can refer to this help article where is provided more information about the DataBase structure.

    Hope this will be helpful.

    All the best,
    Plamen Zdravkov
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  3. RAHUL
    RAHUL avatar
    7 posts
    Member since:
    May 2012

    Posted 12 Jun 2012 Link to this post

    hi zdrakov
    can you clarify what is the intent behind using RecurrenceParentID. Actually i could not get a clear idea from the help(as in article) .
     if possible please show with  an example.
    What is the significance of the constraint provided in article of DataBase Structure?
    CONSTRAINT [FK_Appointments_ParentAppointments] FOREIGN KEY  
           ([RecurrenceParentID])  
       REFERENCES  
           [Appointments] ([ID]),
  4. Plamen
    Admin
    Plamen avatar
    3049 posts

    Posted 15 Jun 2012 Link to this post

    Hi Rahul,

     
    It seems that I could not understand the questions properly and provided not very clear answer. Please excuse me for that. The RecurrenceParentID  field is used as a foreign field in cases when an exception is created in a recurrence serie. In that moment a new appointment is created in the database that is how this exception is actually connected with the initial recurrence serie.

    You can also refer to this help topic where is explained how to bind a RadScheduler declaratively

    I am attaching a sample project with RadScheduler bound to DataSource. Hope this will explain the issue better.

    Kind regards,
    Plamen Zdravkov
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Back to Top