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

Missing bindvariable

1 Answer 19 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Mirko
Top achievements
Rank 1
Mirko asked on 30 Oct 2015, 10:37 AM

Hello!

I am trying to get the sheduler working with a Oracle 11g database. While the select of data works great, inserting / updating produces the error:

 'ORA 01006 missing bind variables'

 While all examples use the @ for the prepared statements, oracle uses a ":". My Insertcommand looks like this:

 InsertCommand="INSERT INTO KALENDER (KALENDER_NR, ZEITPUNKT, ZEITPUNKT_BIS, FIRMENNAME) VALUES (KALENDER_SEQ.nextval, SYSDATE, SYSDATE, :FIRMENNAME)"

 while KALENDER_SEQ is the sequence for creating a unique id, SYSDATE is for the test only, :FIRMENNAME is mapped as subject and works atleast in "readingmode" => The appointments show all given information.

sqldatasourceparamters (select,insert,update):

     <asp:Parameter Name="FIRMENNAME" Direction="InputOutput" Type="String" />

 

Sheduler:

<telerik:RadScheduler runat="server" ID="RadScheduler1"  OnAppointmentCommand="RadScheduler1_AppointmentCommand" OnAppointmentInsert="RadScheduler1_OnAppointmentInsert"
                Width="1250px" Height="1400px" OnFormCreated="RadScheduler1_FormCreated"
                DataKeyField="KALENDER_NR" DataSubjectField="FIRMENNAME" DataStartField="ZEITPUNKT" DataEndField="ZEITPUNKT_BIS" Culture="de-DE" DataSourceID="SqlDataSource1"  Skin="Bootstrap" RowHeight="30px" EnableCustomAttributeEditing="True">
                   <AdvancedForm EnableCustomAttributeEditing="True" ></AdvancedForm>​

...

div id="InlineInsertTemplate">
                        <asp:TextBox ID="TitleTextBox" runat="server" Text='<%# Bind("FIRMENNAME") %>' TextMode="MultiLine"></asp:TextBox>
                        <asp:LinkButton ID="InsertButton" runat="server" CommandName="Insert">Insert</asp:LinkButton>AdvancedEditTemplate:

                        <div>
                            <asp:Label ID="Label2" AssociatedControlID="StartInput" runat="server">Start time:</asp:Label>
                            &nbsp;&nbsp;
                        <telerik:RadDateInput ID="StartInput" SelectedDate='<%# Bind("FIRMENNAME") %>' runat="server"></telerik:RadDateInput><br />
                        </div>​...

 

I have tried many things, as @ ? for the prepared Statements, but nothing works. I hope somebody who has a project with an oracle database and different key-names for subject,start,end can help me with a example project.

Thank you very much and best regards,

Mirko

1 Answer, 1 is accepted

Sort by
0
Plamen
Telerik team
answered on 04 Nov 2015, 07:53 AM
Hi,

The issue seems to be connected with the way you use the SQLDataSource rather than in RadScheduler. One possible way to workaround this commands is to use custom provider and as for example it is done in this demo project and get, insert and update the appointmetns programmatically.


Regards,
Plamen
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Scheduler
Asked by
Mirko
Top achievements
Rank 1
Answers by
Plamen
Telerik team
Share this question
or