// setup the select statement for the fields table

 private void setupFieldTableSelect( String rptName ) {

 FieldTable.setSelectSql("SELECT ReportName, " +

 "TableName, " + 

 "ColumnName, " + 

 "ColumnHeader, " + 

 "PrintOrder, " + 

 "PrintWidth, " + 

 "SortOrder, " + 

 "PrintWrap, " + 

 "SelectionItem, " + 

 "GroupItem, " + 

 "HavingItem, " + 

 "SuppressDetail, " + 

 "SummaryType, " + 

 "DateCreated, " + 

 "DateUpdated, " + 

 "CreatedBy, " + 

 "UpdatedBy " + 

 "FROM ReportColumns " +

 "WHERE ReportName = '" + rptName + "'" );

 }

 --------------------

 // Update the changes based on Report Name/TableName/ColumnName.

 // Notice DateCreated and CreatedBy are not updated

 FieldTable.addUpdateSql("UPDATE ReportColumns SET TableName=?, " + 

 "ColumnName=?, " + 

 "ColumnHeader=?, " + 

 "PrintOrder=?, " + 

 "PrintWidth=?, " + 

 "SortOrder=?, " + 

 "PrintWrap=?, " + 

 "SelectionItem=?, " + 

 "GroupItem=?, " + 

 "HavingItem=?, " + 

 "SuppressDetail=?, " + 

 "SummaryType=?, " + 

 "DateUpdated=?, " + 

 "UpdatedBy=? " + 

 "WHERE ReportName=? " +

 "AND TableName=? " +

 "AND ColumnName=?", // Update Statement 

 "2,3,4,5,6,7,8,8,10,11,12,13,15,17,1,2,3", // Column order in statement

 new int[]{1,2,3} ); // Primary key column number.