Missing bindvariable

2 posts, 0 answers
  1. Mirko
    Mirko avatar
    1 posts
    Member since:
    Jun 2015

    Posted 30 Oct 2015 Link to this post

    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

  2. Plamen
    Admin
    Plamen avatar
    2733 posts

    Posted 04 Nov 2015 Link to this post

    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
  3. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top