Link to home
Start Free TrialLog in
Avatar of keithwilson1
keithwilson1Flag for United States of America

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
<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">&times;</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= >*&nbsp;</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">*&nbsp;</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">*&nbsp;</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">*&nbsp;</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">*&nbsp;</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">*&nbsp;</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">*&nbsp;</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">*&nbsp;</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">*&nbsp;</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>

Open in new window


Below is the table definition from SQL
The-Edit-Modal.docx
teFields.sql
SOLUTION
Avatar of Leonidas Dosas
Leonidas Dosas
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial