jQuery UI Widgets Forums Grid Uncaught TypeError: Cannot call method ‘toString’ of null

This topic contains 7 replies, has 2 voices, and was last updated by  rjlewis71 12 years, 4 months ago.

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author

  • rjlewis71
    Member

    Hello again,

    I’m using the “datetimeinput” in a grid field and am unable to blank the date out once I put a date in. Say I erroneously enter a date and want to blank it out. When I do I get the “Uncaught TypeError: Cannot call method ‘toString’ of null” error. Any idea what I can do to fix that? I’m using individual cell editing which is working great except for this. Thanks!

    Robert


    Peter Stoev
    Keymaster

    Hi Robert,

    Could you send us a sample which reproduces the reported behavior? You can post the sample here or send it to support@jqwidgets.com. That behavior does not happen on our side while testing with the datetimeinput.

    Looking forward to your reply.

    Best Regards,
    Peter Stoev

    jQWidgets Team
    http://www.jqwidgets.com


    rjlewis71
    Member

    HTML:

    <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="test.aspx.cs" Inherits="DBIW.Tabs.test" %>
    <!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></title>
    <link href="../Includes/CSS/uploadify.css" rel="stylesheet" type="text/css" />
    <link href="../Includes/Themes/base/base.css" rel="stylesheet" type="text/css" />
    <link href="../Includes/CSS/jqx.base.css" rel="stylesheet" type="text/css" />
    <link href="../Includes/CSS/jqx.classic.css" rel="stylesheet" type="text/css" />
    <script src="../Includes/JS/jquery-1.7.1.min.js" type="text/javascript"></script>
    <script src="../Includes/JS/jquery-ui-1.8.18.custom.min.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jquery.global.js" type="text/javascript"></script>
    <script src="../Includes/JS/jquery.ui.widget.js" type="text/javascript"></script>
    <script src="../Includes/JS/jquery.ui.position.js" type="text/javascript"></script>
    <script src="../Includes/JS/jquery.global.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxcore.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxbuttons.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxdata.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxdata.export.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxgrid.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxgrid.pager.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxlistbox.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxdropdownlist.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxgrid.selection.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxmenu.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxscrollbar.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxgrid.aggregates.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxgrid.columnsresize.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxgrid.edit.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxgrid.export.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxgrid.filter.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxgrid.grouping.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxgrid.sort.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxnumberinput.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxdatetimeinput.js" type="text/javascript"></script>
    <script src="../Includes/jqxWidgets/jqxcalendar.js" type="text/javascript"></script>
    <script src="../Includes/JS/jquery.uploadify.min.js" type="text/javascript"></script>
    <script src="../Includes/JS/date.js" type="text/javascript"></script>
    <style type="text/css">
    html,body
    {
    font-family: Tahoma;
    font-size: 10px;
    text-align: left;
    color: #000000;
    height: 98%;
    margin-top: 0;
    padding: 1px;
    margin-left: 0;
    margin-right: 0;
    }
    .dtpicker
    {
    width: 65px;
    }
    /* IE 6 doesn't support max-height
    * we use height instead, but this forces the menu to always be this tall
    */
    * html .ui-autocomplete {
    height: 100px;
    }
    </style>
    <script type="text/javascript">
    $(document).ready(function () { // divUpload
    alert("I am currently working on this page. If you experience errors that is why. ~ MSG Lewis");
    $("#btnAddNew").jqxButton({ width: '80px', height: '25px', theme: 'darkblue' });
    $("#btnAddNew").click(function () {
    $("#dialog-form").dialog("open");
    });
    $(".dtpicker").datepicker();
    $.getJSON("uspfo/log/logajax.aspx?id=getADUsers", function (data) {
    $.each(data, function (key, value) { $("#FROM_USER").append('<option value="' + value + '">' + key + '</option>'); });
    });
    $.getJSON("uspfo/log/logajax.aspx?id=cardHolders", function (data) {
    $.each(data, function (key, value) { $("#CARD_HOLDER").append('<option value="' + value + '">' + key + '</option>'); });
    });
    $("#btnExportExcel").jqxButton({ width: '80px', height: '25px', theme: 'darkblue' });
    $("#btnExportExcel").click(function () {
    $("#jqxgrid").jqxGrid('exportdata', 'xls', 'jqxGrid');
    });
    //Getting the source data with ajax GET request
    source = {
    datatype: "xml",
    datafields: [
    { name: 'DOC_NBR' },
    { name: 'FROM_USER' },
    { name: 'STATUS' },
    { name: 'DATE_RECEIVED', type: 'datetimeinput' },
    { name: 'DATE_FUNDED', type: 'datetimeinput' },
    { name: 'MERCH_RCVD_DATE', type: 'datetimeinput' },
    { name: 'REASON_DELAYED' },
    { name: 'CARD_HOLDER' },
    { name: 'PURCHASE_DESC' },
    { name: 'PURCHASE_AMT', type: 'float' },
    { name: 'REQ_DELIVERY_DATE', type: 'datetimeinput' },
    { name: 'VENDOR_NAME' },
    { name: 'SAG' },
    { name: 'DOC_ID' },
    { name: 'FILES' }
    ],
    async: false,
    record: 'Table',
    url: 'uspfo/log/logajax.aspx?id=ngil715',
    sortcolumn: 'DOC_NBR',
    sortdirection: 'asc',
    data: {
    featureClass: "P",
    style: "full",
    maxRows: 50
    },
    success: function (data) {
    $("#jqxgrid").jqxGrid('updatebounddata');
    },
    sort: function () {
    $("#jqxgrid").jqxGrid('updatebounddata');
    },
    filter: function () {
    // update the grid and send a request to the server.
    $("#jqxgrid").jqxGrid('updatebounddata');
    },
    updaterow: function (rowid, rowdata) {
    var data = "id=ngil715Update" +
    "&DOC_NBR=" + rowdata.DOC_NBR +
    "&FROM_USER=" + rowdata.FROM_USER +
    "&STATUS=" + rowdata.STATUS +
    "&DATE_RECEIVED=" + rowdata.DATE_RECEIVED.toString('MM/dd/yyyy') +
    "&DATE_FUNDED=" + rowdata.DATE_FUNDED.toString('MM/dd/yyyy') +
    "&MERCH_RCVD_DATE=" + rowdata.MERCH_RCVD_DATE.toString('MM/dd/yyyy') +
    "&REASON_DELAYED=" + rowdata.REASON_DELAYED +
    "&CARD_HOLDER=" + rowdata.CARD_HOLDER +
    "&PURCHASE_DESC=" + rowdata.PURCHASE_DESC +
    "&PURCHASE_AMT=" + rowdata.PURCHASE_AMT +
    "&REQ_DELIVERY_DATE=" + rowdata.REQ_DELIVERY_DATE.toString('MM/dd/yyyy') +
    "&VENDOR_NAME=" + rowdata.VENDOR_NAME +
    "&SAG=" + rowdata.SAG +
    "&DOC_ID=" + rowdata.DOC_ID;
    $.ajax({
    url: "uspfo/log/logajax.aspx?" + data,
    type: "POST",
    success: function (message) {
    }, // success: function(),
    error: function (message) {
    $('#divErrorMsg').html('An error occurred:' + message.responseText);
    var modal = $('#divDialog').dialog({
    modal: true,
    closeOnEscape: true,
    title: "SAVE RESULTS"
    }); // var modal = $('#divDialog').dialog(
    $('#divDialog').dialog();
    } // error function()
    }); // $.ajax({
    $("#jqxgrid").jqxGrid('updatebounddata');
    } // updaterow: function (rowid, rowdata) {
    }; // source = {
    // Sorting
    $("#jqxgrid").bind("sort", function (event) {
    var sortinformation = event.args.sortinformation;
    var sortdirection = sortinformation.sortdirection.ascending ? "ascending" : "descending";
    if (!sortinformation.sortdirection.ascending && !sortinformation.sortdirection.descending) { sortdirection = "null"; }
    $("#jqxgrid").jqxGrid('updatebounddata');
    });
    $.ajax({
    url: 'test.aspx/GetTotalRowsCount',
    contentType: 'application/json; charset=utf-8',
    async: false,
    success: function (data) {
    source.totalrecords = data.d;
    }
    });
    var linkrenderer = function (row, column, value) {
    var arrFile = value.split('/');
    var html = '<a href="' + value + '" target="_blank">' + arrFile[arrFile.length - 1] + '</a>';
    return html;
    }
    var dataAdapter = new $.jqx.dataAdapter(source,
    { contentType: 'application/json; charset=utf-8' }
    );
    $("#jqxgrid").jqxGrid({
    source: dataAdapter,
    width: '98%',
    columnsresize: true,
    theme: 'classic',
    pageable: true,
    autoheight: true,
    virtualmode: true,
    sortable: true,
    editable: true,
    selectionmode: 'singlecell',
    sorttogglestates: 1,
    autoshowfiltericon: true,
    filterable: true,
    rendergridrows: function () {
    return dataAdapter.records;
    },
    columns: [
    { text: 'DOC NBR', dataField: 'DOC_NBR', width: 175, sortable: true },
    { text: 'FROM', dataField: 'FROM_USER', width: 150, sortable: true },
    { text: 'STATUS', dataField: 'STATUS', columntype: 'dropdownlist', width: 100, sortable: true },
    { text: 'DATE RECEIVED', dataField: 'DATE_RECEIVED', width: 100, sortable: true,
    columntype: 'datetimeinput', cellsalign: 'right', cellsformat: 'MM/dd/yyyy',
    validation: function (cell, value) {
    var dtEntered = value.toString("MM/dd/yyyy");
    if (Date.parse(dtEntered))
    return true;
    else {
    return { result: false, message: "Invalid date entered" };
    }
    }
    },
    { text: 'DATE FUNDED', dataField: 'DATE_FUNDED', columntype: 'datetimeinput', cellsformat: 'MM/dd/yyyy', width: 100, sortable: true,
    validation: function (cell, value) {
    var dtEntered = value.toString("MM/dd/yyyy");
    if (Date.parse(dtEntered))
    return true;
    else {
    return { result: false, message: "Invalid date entered" };
    }
    }
    },
    { text: 'DATE MERCH RCVD', dataField: 'MERCH_RCVD_DATE', columntype: 'datetimeinput', cellsformat: 'MM/dd/yyyy', width: 100, sortable: true },
    { text: 'REASON DELAYED', dataField: 'REASON_DELAYED', width: 200, sortable: true },
    { text: 'ACTION TAKEN BY', dataField: 'CARD_HOLDER', columntype: 'dropdownlist', width: 150, sortable: true },
    { text: 'PURCHASE DESC', dataField: 'PURCHASE_DESC', width: 200, sortable: true },
    { text: 'PURCHASE AMT', dataField: 'PURCHASE_AMT', width: 100, sortable: true, cellsalign: 'right', cellsformat: 'c2' },
    { text: 'REQ DELIVERY DATE', dataField: 'REQ_DELIVERY_DATE', columntype: 'datetimeinput', cellsformat: 'MM/dd/yyyy', width: 100, sortable: true },
    { text: 'VENDOR NAME', dataField: 'VENDOR_NAME', width: 200, sortable: true },
    { text: 'SAG', dataField: 'SAG', width: 75, sortable: true },
    { text: 'DOC_ID', datafield: 'DOC_ID', width: 25, sortable: false },
    { text: 'FILES (double click to view)', datafield: 'FILES', width: 200, sortable: false, cellsrenderer: linkrenderer }
    ]
    });
    $('#jqxgrid').jqxGrid('hidecolumn', 'DOC_ID');
    $("#jqxgrid").bind('cellendedit', function (event) {
    var args = event.args;
    //if ((args.datafield == "DATE_FUNDED") && (args.value == ""))
    // $("#jqxgrid").jqxDateTimeInput('DATE_FUNDED', null);
    });
    $("#jqxgrid").bind('cellselect', function (event) {
    var columnheader = $("#jqxgrid").jqxGrid('getcolumn', event.args.datafield).text;
    var rowindex = event.args.rowindex;
    var DOC_ID = $('#jqxgrid').jqxGrid('getcellvalue', rowindex, "DOC_ID");
    $('#selectedRow').val(rowindex);
    $('#divUpload').uploadify({
    height: 30,
    buttonText: 'Upload',
    swf: '../Includes/swf/uploadify.swf',
    uploader: '../Includes/swf/uploadify.php',
    width: 120,
    onUploadStart: function (file) {
    var formData = { 'DOC_ID': DOC_ID }
    $('#divUpload').uploadify("settings", "formData", formData);
    },
    onUploadComplete: function (file) {
    $("#jqxgrid").jqxGrid('updatebounddata');
    }
    });
    });
    // Dialog box
    function checkLength(o, n, min, max) {
    if (o.val().length > max || o.val().length < min) {
    o.addClass("ui-state-error");
    updateTips("Length of " + n + " must be between " +
    min + " and " + max + ".");
    return false;
    } else {
    return true;
    }
    }
    var DODAAC = $("#DODAAC"),
    JULIAN = $("#JULIAN"),
    SEQUENCE = $("#SEQUENCE"),
    FROM_USER = $("#FROM_USER"),
    DATE_RECEIVED = $("#DATE_RECEIVED"),
    STATUS = $("#STATUS"),
    CARD_HOLDER = $("#CARD_HOLDER"),
    PURCHASE_DESC = $("#PURCHASE_DESC"),
    PURCHASE_AMT = $("#PURCHASE_AMT"),
    VENDOR_NAME = $("#VENDOR_NAME"),
    REQ_DELIVERY_DATE = $("#REQ_DELIVERY_DATE"),
    SAG = $("#SAG"),
    allFields = $([]).add(DODAAC).add(JULIAN).add(SEQUENCE).add(STATUS).add(FROM_USER).add(DATE_RECEIVED).add(CARD_HOLDER).add(PURCHASE_DESC).add(PURCHASE_AMT).add(VENDOR_NAME).add(REQ_DELIVERY_DATE).add(SAG),
    tips = $(".validateTips");
    function updateTips(t) {
    tips
    .text(t)
    .addClass("ui-state-highlight");
    setTimeout(function () {
    tips.removeClass("ui-state-highlight", 1500);
    }, 500);
    }
    $("#dialog-form").dialog({
    autoOpen: false,
    height: 475,
    width: 525,
    modal: true,
    buttons: {
    "Add Record": function () {
    var bValid = true;
    allFields.removeClass("ui-state-error");
    bValid = bValid && checkLength(DODAAC, "DODAAC", 6, 6);
    bValid = bValid && checkLength(JULIAN, "JULIAN", 4, 4);
    bValid = bValid && checkLength(SEQUENCE, "SEQUENCE", 4, 4);
    bValid = bValid && checkLength(DATE_RECEIVED, "DATE_RECEIVED", 10, 10);
    bValid = bValid && checkLength(PURCHASE_DESC, "PURCHASE_DESC", 5, 255);
    bValid = bValid && checkLength(PURCHASE_AMT, "PURCHASE_AMT", 3, 10);
    bValid = bValid && checkLength(VENDOR_NAME, "VENDOR_NAME", 5, 255);
    bValid = bValid && checkLength(REQ_DELIVERY_DATE, "REQ_DELIVERY_DATE", 10, 10);
    if (bValid) {
    $.ajax({
    url: "uspfo/log/logajax.aspx?id=add715" +
    "&DODAAC=" + $('#DODAAC').val() +
    "&JULIAN=" + $('#JULIAN').val() +
    "&SEQUENCE=" + $('#SEQUENCE').val() +
    "&FROM_USER=" + $('#FROM_USER').find("option:selected").val() +
    "&DATE_RECEIVED=" + $('#DATE_RECEIVED').val() +
    "&STATUS=" + $('#STATUS').find("option:selected").val() +
    "&CARD_HOLDER=" + $('#CARD_HOLDER').find("option:selected").val() +
    "&PURCHASE_DESC=" + $('#PURCHASE_DESC').val() +
    "&PURCHASE_AMT=" + $('#PURCHASE_AMT').val() +
    "&VENDOR_NAME=" + $('#VENDOR_NAME').val() +
    "&REQ_DELIVERY_DATE=" + $('#REQ_DELIVERY_DATE').val() +
    "&SAG=" + $('#SAG').find("option:selected").val(),
    type: "POST",
    success: function (msg) {
    $("#jqxgrid").jqxGrid('updatebounddata');
    $(this).dialog("close");
    },
    error: function (msg) {
    updateTips("Error: " + msg.responseText);
    return false;
    } // error function()
    }); // $.ajax(
    } // if (bValid)
    },
    Cancel: function () {
    $(this).dialog("close");
    }
    },
    close: function () {
    allFields.val("").removeClass("ui-state-error");
    }
    });
    });
    </script>
    </head>
    <body>
    <div id="divOuter" class="ui-dialog ui-widget ui-widget-content ui-corner-all" style="width: 99%; text-align: left; position: relative;">
    <div id="divTitle" class="ui-dialog-titlebar ui-widget-header ui-corner-all ui-helper-clearfix">
    GPC Purchase Request
    </div>
    <div id="divControl" style="width: 99%;" class="ui-dialog-content ui-widget-content" id="dialog">
    <div id="divUses" class="instructions">Uses: Used to track GPC Purchases requests.</div>
    <div id="divInstructions" class="instructions">To add a GPC Purchase request, click
    the &quot;Add&quot; button.&nbsp;
    <br />
    To edit an existing record, just click in the grid where you need to edit, make
    whatever changes are necessary, and then click on a different cell in the grid.&nbsp;
    Updates are saved as you make them.&nbsp;
    <br />
    To upload a supporting document, click any field in the row to which you would
    like to attach the document and then click the upload button.&nbsp; Select the
    file that you wish to upload and then click the &quot;Open&quot; button.&nbsp; Under the
    &quot;Upload&quot; button you will see the upload progress.&nbsp; Once uploaded, the file
    will show up for that record in the &quot;Files&quot; column of that row.</div>
    <hr />
    <table border="0" cellpadding="2" cellspacing="2">
    <tr>
    <td>
    <div id='btnAddNew'><img style='float: left; margin: 4px;'
    src='../Includes/Images/File-New-icon.png' alt="" height="16" width="16" />
    <div style='float: left; margin: 4px;'>Add</div></div>
    </td>
    <td>
    <div id='btnExportExcel'><img style='float: left; margin: 4px;' src='../Includes/Images/iconPDF.gif' alt="" height="16" width="16" />
    <div style='float: left; margin: 4px;'>Export</div></div>
    </td>
    <td>
    <div id='divUpload'></div>
    </td>
    <td>
    <input id="selectedRow" type="text" readonly="readonly"
    style="border-style: none; border-color: #FFFFFF; width: 0px;" /></td>
    </tr>
    </table>
    <div id="jqxgrid"></div>
    </div> <!-- divControl -->
    </div> <!-- divOuter -->
    <div id="divDialog"><div id="divErrorMsg"></div></div>
    <div id="dialog-form" title="Add Record">
    <p class="validateTips">All form fields are required.</p>
    <fieldset>
    <table cellpadding="2" cellspacing="0">
    <tr>
    <td>DOC NBR</td>
    <td>
    <table cellpadding="0" cellspacing="0" style="width: 100%">
    <tr>
    <td style="text-align: center; background-color: #E9E9E9">DODAAC</td>
    <td style="text-align: center; background-color: #E9E9E9">Julian Date</td>
    <td style="text-align: center; background-color: #E9E9E9">Sequence</td>
    </tr>
    <tr>
    <td style="text-align: center"><input type="text" name="DODAAC" id="DODAAC"
    class="text ui-widget-content ui-corner-all" maxlength="6"
    style="width: 75px" /></td>
    <td style="text-align: center">
    <input type="text" name="JULIAN" id="JULIAN"
    class="text ui-widget-content ui-corner-all" maxlength="4"
    style="width: 75px" /></td>
    <td style="text-align: center"><input type="text" name="SEQUENCE" id="SEQUENCE"
    class="text ui-widget-content ui-corner-all" maxlength="4"
    style="width: 75px" /></td>
    </tr>
    </table>
    </td>
    </tr>
    <tr>
    <td>Received From:</td>
    <td>
    <select id="FROM_USER" name="FROM_USER"></select>
    </td>
    </tr>
    <tr>
    <td>Date Received:</td>
    <td>
    <input id="DATE_RECEIVED" class="dtpicker" name="DATE_RECEIVED"
    style="width: 100px" type="text" maxlength="10" />
    </td>
    </tr>
    <tr>
    <td>Status:</td>
    <td>
    <select id="STATUS">
    <option value="PENDING">PENDING</option>
    <option value="APPROVED">APPROVED</option>
    <option value="DISAPPROVED">DISAPPROVED</option>
    <option value="HELD">HELD</option>
    </select>
    </td>
    </tr>
    <tr>
    <td>Card Holder:</td>
    <td><select id="CARD_HOLDER"></select></td>
    </tr>
    <tr>
    <td>Purchase Description:</td>
    <td><textarea id="PURCHASE_DESC" cols="1" rows="5" style="width: 250px"></textarea></td>
    </tr>
    <tr>
    <td>Purchase Amount:</td>
    <td><input type="text" name="PURCHASE_AMT" id="PURCHASE_AMT" class="text ui-widget-content ui-corner-all" maxlength="9"/></td>
    </tr>
    <tr>
    <td>Vendor Name:</td>
    <td>
    <input type="text" name="VENDOR_NAME" id="VENDOR_NAME"
    class="text ui-widget-content ui-corner-all" maxlength="254"
    style="width: 250px"/></td>
    </tr>
    <tr>
    <td>Req Delivery Date:</td>
    <td>
    <input type="text" name="REQ_DELIVERY_DATE" id="REQ_DELIVERY_DATE"
    class="dtpicker" maxlength="10" style="width: 100px"/></td>
    </tr>
    <tr>
    <td>SAG:</td>
    <td><select id="SAG">
    <option value="111">111</option>
    <option value="112">112</option>
    <option value="113">113</option>
    <option value="114">114</option>
    <option value="115">115</option>
    <option value="116">116</option>
    <option value="OTHER">OTHER</option>
    </select></td>
    </tr>
    </table>
    </fieldset>
    </div>
    </body>
    </html>

    Data:

    <NewDataSet>
    <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="Table" msdata:UseCurrentLocale="true">
    <xs:complexType>
    <xs:choice minOccurs="0" maxOccurs="unbounded">
    <xs:element name="Table">
    <xs:complexType>
    <xs:sequence>
    <xs:element name="DOC_ID" type="xs:string" minOccurs="0" />
    <xs:element name="DOC_NBR" type="xs:string" minOccurs="0" />
    <xs:element name="FROM_USER" type="xs:string" minOccurs="0" />
    <xs:element name="STATUS" type="xs:string" minOccurs="0" />
    <xs:element name="DATE_RECEIVED" type="xs:string" minOccurs="0" />
    <xs:element name="DATE_FUNDED" type="xs:string" minOccurs="0" />
    <xs:element name="MERCH_RCVD_DATE" type="xs:string" minOccurs="0" />
    <xs:element name="REASON_DELAYED" type="xs:string" minOccurs="0" />
    <xs:element name="CARD_HOLDER" type="xs:string" minOccurs="0" />
    <xs:element name="PURCHASE_DESC" type="xs:string" minOccurs="0" />
    <xs:element name="PURCHASE_AMT" type="xs:string" minOccurs="0" />
    <xs:element name="REQ_DELIVERY_DATE" type="xs:string" minOccurs="0" />
    <xs:element name="VENDOR_NAME" type="xs:string" minOccurs="0" />
    <xs:element name="SAG" type="xs:string" minOccurs="0" />
    <xs:element name="FILES" type="xs:string" minOccurs="0" />
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    </xs:choice>
    </xs:complexType>
    </xs:element>
    </xs:schema>
    <Table>
    <DOC_ID>395331120100940</DOC_ID>
    <DOC_NBR>WYDEE0-0300-0301</DOC_NBR>
    <FROM_USER>renee.waller</FROM_USER>
    <STATUS>APPROVED</STATUS>
    <DATE_RECEIVED>11/01/2010</DATE_RECEIVED>
    <DATE_FUNDED>10/04/2012</DATE_FUNDED>
    <MERCH_RCVD_DATE />
    <REASON_DELAYED />
    <CARD_HOLDER>patricia.turner1</CARD_HOLDER>
    <PURCHASE_DESC>UNIT CRESTS</PURCHASE_DESC>
    <PURCHASE_AMT>569</PURCHASE_AMT>
    <REQ_DELIVERY_DATE />
    <VENDOR_NAME>SUPPLY ROOM</VENDOR_NAME>
    <SAG>116</SAG>
    <FILES>https://ngilc2spi740b22.ng.ds.army.mil/tabs/uspfo/715_1/395331120100940/ServicemembersRightandBenefits.pdf</FILES>
    </Table>
    <Table>
    <DOC_ID>3953181120101347</DOC_ID>
    <DOC_NBR>WY7490-0313-0301</DOC_NBR>
    <FROM_USER>fray.f.figueroa</FROM_USER>
    <STATUS>APPROVED</STATUS>
    <DATE_RECEIVED>11/10/2010</DATE_RECEIVED>
    <DATE_FUNDED>11/22/2010</DATE_FUNDED>
    <MERCH_RCVD_DATE />
    <REASON_DELAYED />
    <CARD_HOLDER>michele.l.purcell</CARD_HOLDER>
    <PURCHASE_DESC>COINS</PURCHASE_DESC>
    <PURCHASE_AMT>420</PURCHASE_AMT>
    <REQ_DELIVERY_DATE />
    <VENDOR_NAME>MTM</VENDOR_NAME>
    <SAG>NULL</SAG>
    <FILES />
    </Table>
    <Table>
    <DOC_ID>3953181120101355</DOC_ID>
    <DOC_NBR>WY7490-0306-0301</DOC_NBR>
    <FROM_USER>pearlie.aaron</FROM_USER>
    <STATUS>PENDING</STATUS>
    <DATE_RECEIVED>11/16/2010</DATE_RECEIVED>
    <DATE_FUNDED>10/04/2012</DATE_FUNDED>
    <MERCH_RCVD_DATE />
    <REASON_DELAYED />
    <CARD_HOLDER>patricia.turner1</CARD_HOLDER>
    <PURCHASE_DESC>MAGNET CALENDAR AND MISC. </PURCHASE_DESC>
    <PURCHASE_AMT>2624.68</PURCHASE_AMT>
    <REQ_DELIVERY_DATE />
    <VENDOR_NAME>GSA MAGNATAG VISIBLE SYSTEMS</VENDOR_NAME>
    <SAG>NULL</SAG>
    <FILES />
    </Table>
    <Table>
    <DOC_ID>395328120111057</DOC_ID>
    <DOC_NBR>WPBGC0-1028-0301</DOC_NBR>
    <FROM_USER>keith.rogers1</FROM_USER>
    <STATUS>PENDING</STATUS>
    <DATE_RECEIVED>01/28/2011</DATE_RECEIVED>
    <DATE_FUNDED>10/04/2012</DATE_FUNDED>
    <MERCH_RCVD_DATE />
    <REASON_DELAYED />
    <CARD_HOLDER>unassigned</CARD_HOLDER>
    <PURCHASE_DESC>IDT LODGING</PURCHASE_DESC>
    <PURCHASE_AMT>1276.8</PURCHASE_AMT>
    <REQ_DELIVERY_DATE />
    <VENDOR_NAME>HAMPTON INN OF CARBONDALE</VENDOR_NAME>
    <SAG />
    <FILES />
    </Table>
    <Table>
    <DOC_ID>395329112011145633</DOC_ID>
    <DOC_NBR>W9AH3F-1333-0301</DOC_NBR>
    <FROM_USER>phil.tuttle</FROM_USER>
    <STATUS>PENDING</STATUS>
    <DATE_RECEIVED>11/29/2011</DATE_RECEIVED>
    <DATE_FUNDED />
    <MERCH_RCVD_DATE />
    <REASON_DELAYED />
    <CARD_HOLDER>UNASSIGNED</CARD_HOLDER>
    <PURCHASE_DESC>IDT LODGING</PURCHASE_DESC>
    <PURCHASE_AMT>1368</PURCHASE_AMT>
    <REQ_DELIVERY_DATE />
    <VENDOR_NAME>FAIRFIELD INN</VENDOR_NAME>
    <SAG />
    <FILES />
    </Table>
    <Table>
    <DOC_ID>395314220111423</DOC_ID>
    <DOC_NBR>W9AH3F-1035-0301</DOC_NBR>
    <FROM_USER>gary.cunningham5</FROM_USER>
    <STATUS>APPROVED</STATUS>
    <DATE_RECEIVED>02/11/2011</DATE_RECEIVED>
    <DATE_FUNDED>02/14/2011</DATE_FUNDED>
    <MERCH_RCVD_DATE />
    <REASON_DELAYED />
    <CARD_HOLDER>rhonda.gilbert3</CARD_HOLDER>
    <PURCHASE_DESC>IDT LODGING</PURCHASE_DESC>
    <PURCHASE_AMT>957.6</PURCHASE_AMT>
    <REQ_DELIVERY_DATE />
    <VENDOR_NAME>FAIRFIELD INN</VENDOR_NAME>
    <SAG>Other</SAG>
    <FILES />
    </Table>
    <Table>
    <DOC_ID>395328120110732</DOC_ID>
    <DOC_NBR>W9AH3F-1014-0301</DOC_NBR>
    <FROM_USER>gary.cunningham5</FROM_USER>
    <STATUS>APPROVED</STATUS>
    <DATE_RECEIVED>01/25/2011</DATE_RECEIVED>
    <DATE_FUNDED>01/26/2011</DATE_FUNDED>
    <MERCH_RCVD_DATE />
    <REASON_DELAYED />
    <CARD_HOLDER>rhonda.gilbert3</CARD_HOLDER>
    <PURCHASE_DESC>IDT LODGING</PURCHASE_DESC>
    <PURCHASE_AMT>1026</PURCHASE_AMT>
    <REQ_DELIVERY_DATE />
    <VENDOR_NAME>FAIRFIELD INN</VENDOR_NAME>
    <SAG>Other</SAG>
    <FILES />
    </Table>
    <Table>
    <DOC_ID>395361220101539</DOC_ID>
    <DOC_NBR>W9AH3F-0340-0301</DOC_NBR>
    <FROM_USER>gary.cunningham5</FROM_USER>
    <STATUS>PENDING</STATUS>
    <DATE_RECEIVED>12/06/2010</DATE_RECEIVED>
    <DATE_FUNDED />
    <MERCH_RCVD_DATE />
    <REASON_DELAYED />
    <CARD_HOLDER>UNASSIGNED</CARD_HOLDER>
    <PURCHASE_DESC>IDT LODGING</PURCHASE_DESC>
    <PURCHASE_AMT>1368</PURCHASE_AMT>
    <REQ_DELIVERY_DATE />
    <VENDOR_NAME>FAIRFIELD INN</VENDOR_NAME>
    <SAG />
    <FILES />
    </Table>
    <Table>
    <DOC_ID>3953241120101047</DOC_ID>
    <DOC_NBR>W9AH3F-0328-0301</DOC_NBR>
    <FROM_USER>gary.cunningham5</FROM_USER>
    <STATUS>PENDING</STATUS>
    <DATE_RECEIVED>11/24/2010</DATE_RECEIVED>
    <DATE_FUNDED />
    <MERCH_RCVD_DATE />
    <REASON_DELAYED />
    <CARD_HOLDER>UNASSIGNED</CARD_HOLDER>
    <PURCHASE_DESC>IDT LODGING</PURCHASE_DESC>
    <PURCHASE_AMT>1231.2</PURCHASE_AMT>
    <REQ_DELIVERY_DATE />
    <VENDOR_NAME>FAIRFIELD INN</VENDOR_NAME>
    <SAG />
    <FILES />
    </Table>
    <Table>
    <DOC_ID>395391120100738</DOC_ID>
    <DOC_NBR>W9AH3F-0312-0301</DOC_NBR>
    <FROM_USER>gary.cunningham5</FROM_USER>
    <STATUS>PENDING</STATUS>
    <DATE_RECEIVED>11/09/2010</DATE_RECEIVED>
    <DATE_FUNDED />
    <MERCH_RCVD_DATE />
    <REASON_DELAYED />
    <CARD_HOLDER>UNASSIGNED</CARD_HOLDER>
    <PURCHASE_DESC>IDT LODGING</PURCHASE_DESC>
    <PURCHASE_AMT>820.8</PURCHASE_AMT>
    <REQ_DELIVERY_DATE />
    <VENDOR_NAME>FAIRFIELD INN</VENDOR_NAME>
    <SAG />
    <FILES />
    </Table>
    </NewDataSet>

    Peter Stoev
    Keymaster

    Hi Robert,

    Thanks for the code. How do you clear the entered Date? Select all text and click Del or something else?

    Best Regards,
    Peter Stoev

    jQWidgets Team
    http://www.jqwidgets.com


    rjlewis71
    Member

    Peter,

    Yes, I usually select it all and then click delete.

    Robert


    rjlewis71
    Member

    Any update on this?

    Robert


    Peter Stoev
    Keymaster

    Hi Robert,

    There are no updates on this topic. We haven’t released any new versions.

    Best Regards,
    Peter Stoev

    jQWidgets Team
    http://www.jqwidgets.com


    rjlewis71
    Member

    So it isn’t possible to delete a date once input into the grid (in edit mode)? I saw a post on the DateTimeInput forum that talked about that functionality and that it had been added to the control itself. I thought perhaps I was just doing something wrong (which is most likely). 🙂

    Robert

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic.