Missing bindvariable

[Mirko]

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

[Plamen]

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