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

insert datetime - customadvancedTemplate

6 Answers 114 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Rubihno
Top achievements
Rank 1
Rubihno asked on 16 Sep 2008, 06:37 AM
Hi,

I have this table

ID
Subject
Start
End
Recurrence_rule
Data_Storage

Date_Insert  -> datetime
Date_Update -> datetime

I use a customadvanceTemplate with sqldatasource

How i make to insert a datetime insert or a date_update when i insert an appointment?I would like to insert automatically the datetime...is possible with a hidden  field?or another solution?

6 Answers, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 16 Sep 2008, 11:28 AM
Hello Rubihno,

Please, review the Customizing the Advanced Template example and this help topic. The user control which implments the start and end time functionality is SchedulerDefaultForm.


Kind regards,
Peter
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Rubihno
Top achievements
Rank 1
answered on 16 Sep 2008, 12:48 PM
yes the insert appointment run, but if i want to insert a datetime insert?

example isnert

ID - 1
Subject - test
Start -  12/8/2008 - 13:00
End-  12/8/2008 - 14:00
Recurrence_rule  -
Data_storage -
Datetime_insert - 16:05 -> is the datetime when i have maked the insert appointment
but how i make to develop this?
0
Peter
Telerik team
answered on 16 Sep 2008, 01:34 PM
Hello Rubihno,

Now I see what you mean.

You can call the GetDate() method in your insert statement:

INSERT INTO MyTable (colA) VALUES (GetDate())



Peter
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Rubihno
Top achievements
Rank 1
answered on 16 Sep 2008, 01:40 PM
this getdate() get into a  insert sqlstatment of sqldatasource...

Thanks
0
Peter
Telerik team
answered on 16 Sep 2008, 01:45 PM

Were you able to get it to work as needed?


Peter
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Rubihno
Top achievements
Rank 1
answered on 16 Sep 2008, 05:24 PM
yes, now run
Tags
Scheduler
Asked by
Rubihno
Top achievements
Rank 1
Answers by
Peter
Telerik team
Rubihno
Top achievements
Rank 1
Share this question
or