Query = "select Parts.Number as 'Number', Parts.Quan_Avail as 'Quan_Avail', Parts.Factory_Part_Number as 'Factory_Part_Number', Parts.BIN as 'BIN', Parts.Description as 'Description', Parts.Price as 'Price' from Parts"; } else { // Query used in table view $x->Query = "select Parts.Quan_Avail as ' Quan_Avail ', Parts.Factory_Part_Number as ' Factory_Part_Number ', Parts.BIN as ' BIN ', Parts.Description as ' Description ', Parts.Price as ' Price ' from Parts"; } // handle date sorting correctly // end of date sorting handler $x->DataHeight = 375; $x->AllowSelection = 0; $x->AllowDelete = 0; $x->AllowInsert = 0; $x->AllowUpdate = 0; $x->AllowFilters = 0; $x->AllowSavingFilters = 0; $x->AllowSorting = 1; $x->AllowNavigation = 1; $x->AllowPrinting = 0; $x->HideTableView = 0; $x->RecordsPerPage = 50; $x->QuickSearch = 3; $x->QuickSearchText = $Translation["quick search"]; $x->ScriptFileName = "Parts_view.php"; $x->TableTitle = "Parts"; $x->PrimaryKey = "Parts.Number"; $x->ColWidth[] = 8; $x->ColWidth[] = 25; $x->ColWidth[] = 20; $x->ColWidth[] = 250; $x->ColWidth[] = 15; $x->Template = 'Parts_templateTV.html'; $x->SelectedTemplate = 'Parts_templateTVS.html'; $x->ShowTableHeader = 1; $x->ShowRecordSlots = 1; $x->HighlightColor = '#EEE1B5'; $x->Render(); include(dirname(__FILE__)."/header.php"); echo $x->HTML; include(dirname(__FILE__)."/footer.php"); ?>