keithwilson1
asked on
Modal Popup for Editing a row changes a data type of bit ('0') to a text 'False' and causes an abort on a Save.
This is the modal
Below is the table definition from SQL
The-Edit-Modal.docx
teFields.sql
<div id="mdlEdit" class="modal fade" data-backdrop="false" style="background-color: rgba(0, 0, 0, 0.5);">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title" id="hdrEdit" runat="server"></h4>
</div>
<div class="modal-body">
<div class="form-group">
<label for="iID" class="control-label col-xs-5"><span class= >* </span>ID</label>
<div>
<input type="number" class="form-control" id="iID" placeholder="Enter ID" runat="server" maxlength="30" name="iID" />
</div>
</div>
<div class="form-group">
<label for="iTableID" class="control-label col-xs-5"><span class="required">* </span>Table ID</label>
<div>
<input type="number" class="form-control" id="iTableID" placeholder="Enter Table ID" runat="server" maxlength="10" name="iTableID" />
</div>
</div>
<div class="form-group">
<label for="iFieldName" class="control-label col-xs-5"><span class="required">* </span>Field Name</label>
<div>
<input type="text" class="form-control" id="iFieldName" placeholder="Enter FieldName" runat="server" maxlength="30" name="iFieldName" />
</div>
</div>
<div class="form-group">
<label for="iIsKey" class="control-label col-xs-5"><span class="required">* </span>IsKey (0-False 1-True)</label>
<div>
<input type="text" class="form-control" id="iIsKey" placeholder="Enter IsKey" runat="server" maxlength="1" name="iIsKey" />
</div>
</div>
<div class="form-group">
<label for="icanEdit" class="control-label col-xs-5"><span class="required">* </span>canEdit (0-False 1-True)</label>
<div>
<input type="text" class="form-control" id="icanEdit" placeholder="Enter canEdit" runat="server" maxlength="1" name="icanEdit" />
</div>
</div>
<div class="form-group">
<label for="icanFilter" class="control-label col-xs-5"><span class="required">* </span>canFilter (0-False 1-True)</label>
<div>
<input type="text" class="form-control" id="icanFilter" placeholder="Enter canFilter" runat="server" maxlength="1" name="icanFilter" />
</div>
</div>
</div>
<div class="form-group">
<label for="iFilterTypeID" class="control-label col-xs-5"><span class="required">* </span>FilterT ype ID (2 for Textbox</label>
<div>
<input type="number" class="form-control" id="iFilterTypeID" placeholder="Enter FilterTypeID" runat="server" maxlength="1" name="iFilterTypeID" />
</div>
</div>
<div class="form-group">
<label for="iSortOrder" class="control-label col-xs-5"><span class="required">* </span>SortOrder</label>
<div>
<input type="text" class="form-control" id="iSortOrder" placeholder="Enter SortOrder" runat="server" maxlength="30" name="iSortOrder" />
</div>
</div>
<div class="form-group">
<label for="iActive" class="control-label col-xs-5"><span class="required">* </span>Active (0-False 1-True)</label>
<div>
<input type="text" id="iActive" placeholder="Enter Active" runat="server" maxlength="1" name="iActive" />
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default btn-sm" data-dismiss="modal">Close</button>
<button type="button" class="btn btn-primary btn-sm" runat="server" id="BtnSave" onclick="return save()">Save</button>
</div>
<div class="text-danger" runat="server" id="div1" visible="false">
<strong>Update Not Saved! </strong><div runat="server" id="div2"></div>
</div>
</div>
</div>
</div>
Below is the table definition from SQL
The-Edit-Modal.docx
teFields.sql
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.