2. ASPRunner.NET General questions
  3. Oracl Edit error
This topic is locked

Oracl Edit error

 		1/10/2008 5:20:44 PM
ASPRunner.NET General questions
L
 liangjou author

I have an edit page and try to edit an Oracle field (Varchar2 is the column data type) and I get error all the time if I have any values in the edit field. But it works fine if I leave the field blank, the update action will go through with no error. Plus, it works if I edit a number field. Any solution ? Thanks.
Eugene 1/11/2008

Could you please send me build version of ASPRunner.NET wizard and more detailed description of error that you've got.
L
 		liangjou author 1/11/2008

Could you please send me build version of ASPRunner.NET wizard and more detailed description of error that you've got.


Eugene
Here is the HTML code.

  1. If I update SAIL_ITIN_CD_NEW field with NULL value, it went through.
  2. If I update SAIL_ITIN_CD_NEW with any value, it came with Error description: ORA-12571: TNS:packet writer failure. (This could be a wrong message which the network was fine during the process.)

    this can be something to do with the datatype conversion ?
    Thanks.
    ****

    *****
    <%@ Page Language="vb" autoeventwireup="true" codefile="SAIL_DIM_ITIN_CD_OVERWRITE_VW_edit.aspx.vb" Inherits="CSAIL_DIM_ITIN_CD_OVERWRITE_VW_Edit" %>

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">;

    <html xmlns="http://www.w3.org/1999/xhtml">;

    <head runat="server">

    <title>DS_RPT.SAIL_DIM_ITIN_CD_OVERWRITE_VW - Edit</title> &lt;script language="JavaScript" src="include/calendar.js"></script>

    <link href="include/style.css" type="text/css" rel="stylesheet" />

    <style>

    .visible { VISIBILITY: visible }

    .hide { VISIBILITY: hidden }

    </style>

    </head>

    <body>

    <form id="editform" runat="server">

    <asp:Label id="lblUpdate" runat="server" font-bold="True">Table: DS_RPT.SAIL_DIM_ITIN_CD_OVERWRITE_VW, Edit

    record</asp:Label>

    <hr width="100%" size="1" />

    <asp:hyperlink id="lnkBackToList" runat="server" NavigateUrl="SAIL_DIM_ITIN_CD_OVERWRITE_VW_list.aspx">Back to list</asp:hyperlink>

    <p>

    <asp:Label id="lblMessage" runat="server" cssclass="message"></asp:Label>

    <asp:validationsummary id="vsUpdatePage" runat="server" Height="32px" ShowSummary="False" ShowMessageBox="True"></asp:validationsummary>

    <asp:SqlDataSource id="SAIL_DIM_ITIN_CD_OVERWRITE_VWSqlDataSource" runat="server" ProviderName="<%$ ConnectionStrings:Project1ConnectionString.providerName%>" ConnectionString="<%$ ConnectionStrings:Project1ConnectionString%>" OnUpdating="SAIL_DIM_ITIN_CD_OVERWRITE_VWSqlDataSource_Updating" OnUpdated="SAIL_DIM_ITIN_CD_OVERWRITE_VWSqlDataSource_Updated" OnSelected="SAIL_DIM_ITIN_CD_OVERWRITE_VWSqlDataSource_Selected" UpdateCommand='update "DS_RPT"."SAIL_DIM_ITIN_CD_OVERWRITE_VW" set "SAIL_ITIN_CD_NEW"=:SAIL_ITIN_CD_NEW where "SYN_SAIL_KEY"=:SYN_SAIL_KEY' SelectCommand='select "SYN_SAIL_KEY", "SAIL_ITIN_CD_NEW" from "DS_RPT"."SAIL_DIM_ITIN_CD_OVERWRITE_VW" where "SYN_SAIL_KEY"=:SYN_SAIL_KEY'>

    <SelectParameters>

    <asp:QueryStringParameter QueryStringField="SYN_SAIL_KEY" Name="SYN_SAIL_KEY" Type="Decimal" DefaultValue="-1" />

    </SelectParameters>

    <UpdateParameters>

    <asp:Parameter Name="SAIL_ITIN_CD_NEW" Type="String" />

    <asp:QueryStringParameter QueryStringField="SYN_SAIL_KEY" Name="SYN_SAIL_KEY" Type="Decimal" DefaultValue="-1" />

    </UpdateParameters>

    </asp:SqlDataSource>

    <asp:DetailsView id="SAIL_DIM_ITIN_CD_OVERWRITE_VWDetailsView" runat="server" RowStyle-CssClass="" GridLines="None" DefaultMode="Edit" AutoGenerateEditButton="True" OnItemUpdating="SAIL_DIM_ITIN_CD_OVERWRITE_VWDetailsView_ItemUpdating" OnDataBound="SAIL_DIM_ITIN_CD_OVERWRITE_VWDetailsView_DataBound" DataSourceID="SAIL_DIM_ITIN_CD_OVERWRITE_VWSqlDataSource" DataKeyNames="SYN_SAIL_KEY" AutoGenerateRows="False">

    <FieldHeaderStyle cssclass="shade" />

    <Fields>

    <asp:TemplateField HeaderText="SYN_SAIL_KEY">

    <EditItemTemplate>

    <asp:TextBox id="fldSYN_SAIL_KEY" ReadOnly="True" Text='<%# Bind("SYN_SAIL_KEY") %>' runat="server" />

    Â <img alt="Key field" src="images/icon_key.gif" />

    <asp:RegularExpressionValidator runat="server" ErrorMessage="SYN_SAIL_KEY: Must be a Floating point value" Display="None" ControlToValidate="fldSYN_SAIL_KEY" ValidationExpression="^\s([-\+])?(\d+)?[\.\,]{0,1}(\d+)?\s$" ID="revSYN_SAIL_KEY" />

    </EditItemTemplate>

    </asp:TemplateField>

    <asp:TemplateField HeaderText="SAIL_ITIN_CD_NEW">

    <EditItemTemplate>

    <asp:TextBox id="fldSAIL_ITIN_CD_NEW" Text='<%# Bind("SAIL_ITIN_CD_NEW") %>' runat="server" />

    Â

    </EditItemTemplate>

    </asp:TemplateField>

    </Fields>

    </asp:DetailsView>

    </p>

    </form>

    </body>

    </html>
Eugene 1/14/2008

Could you please send me your project (including project file, output directory and database backup) on support@xlinesoft.com? I will investigate it on my box.