This is a migrated thread and some comments may be shown as answers.

Sample Database

3 Answers 119 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
RAHUL
Top achievements
Rank 1
RAHUL asked on 02 Jun 2012, 07:55 AM
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 ..

3 Answers, 1 is accepted

Sort by
0
Plamen
Telerik team
answered on 04 Jun 2012, 09:32 AM
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.
0
RAHUL
Top achievements
Rank 1
answered on 12 Jun 2012, 12:14 PM
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]),
0
Plamen
Telerik team
answered on 15 Jun 2012, 10:31 AM
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.
Tags
Scheduler
Asked by
RAHUL
Top achievements
Rank 1
Answers by
Plamen
Telerik team
RAHUL
Top achievements
Rank 1
Share this question
or