ReportName = Units Scheduled Services ReportGroup = Maintenance object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.ScheduledServices NoDataBehaviors = [ndBlankReport] PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Report' PrinterSetup.PaperName = 'Letter' PrinterSetup.PrinterName = 'Default' PrinterSetup.mmMarginBottom = 6350 PrinterSetup.mmMarginLeft = 6350 PrinterSetup.mmMarginRight = 6350 PrinterSetup.mmMarginTop = 6350 PrinterSetup.mmPaperHeight = 279401 PrinterSetup.mmPaperWidth = 215900 PrinterSetup.PaperSize = 1 SaveAsTemplate = True Template.DatabaseSettings.DataPipeline = dpReports Template.DatabaseSettings.Name = 'Units Scheduled Services' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Units Scheduled Services.rtm' Template.SaveTo = stDatabase Template.Format = ftASCII AllowPrintToFile = True DeviceType = 'Screen' OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = False OutlineSettings.Visible = True PreviewFormSettings.ZoomSetting = zs100Percent TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True Left = 218 Top = 155 Version = '7.03' mmColumnWidth = 0 DataPipelineName = 'ScheduledServices' object ppTitleBand1: TppTitleBand mmBottomOffset = 0 mmHeight = 14552 mmPrintPosition = 0 object ppLabel1: TppLabel UserName = 'Label1' Caption = 'Unit Scheduled Services' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 20 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 8213 mmLeft = 1323 mmTop = 1323 mmWidth = 70697 BandType = 1 end object ppDBText9: TppDBText UserName = 'DBText9' AutoSize = True DataField = 'CompanyName' DataPipeline = dpCompanyInfo Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 16 Font.Style = [fsBold, fsItalic] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True DataPipelineName = 'dpCompanyInfo' mmHeight = 6562 mmLeft = 166868 mmTop = 1323 mmWidth = 35010 BandType = 1 end object ppLabel12: TppLabel UserName = 'Params' Caption = 'RecordNumber: 5' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4149 mmLeft = 1323 mmTop = 10054 mmWidth = 25315 BandType = 1 end end object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 12435 mmPrintPosition = 0 object ppLine3: TppLine UserName = 'Line3' Weight = 0.75 mmHeight = 1852 mmLeft = 121444 mmTop = 3704 mmWidth = 35454 BandType = 0 end object ppLine1: TppLine UserName = 'Line1' Pen.Color = clNavy Pen.Width = 2 Weight = 1.5 mmHeight = 3969 mmLeft = 1323 mmTop = 11113 mmWidth = 200555 BandType = 0 end object ppLabel2: TppLabel UserName = 'Label2' AutoSize = False Caption = 'Service' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4233 mmLeft = 10054 mmTop = 5821 mmWidth = 56621 BandType = 0 end object ppLabel4: TppLabel UserName = 'Label4' Caption = 'Interval' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4233 mmLeft = 90223 mmTop = 5821 mmWidth = 11642 BandType = 0 end object ppLabel5: TppLabel UserName = 'Label5' Caption = 'Period' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4233 mmLeft = 104511 mmTop = 5821 mmWidth = 9525 BandType = 0 end object ppLabel6: TppLabel UserName = 'Label6' Caption = 'Scheduled' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4233 mmLeft = 120915 mmTop = 5821 mmWidth = 15081 BandType = 0 end object ppLabel7: TppLabel UserName = 'Label7' Caption = 'Performed' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4106 mmLeft = 141891 mmTop = 5821 mmWidth = 15536 BandType = 0 end object ppLabel8: TppLabel UserName = 'Label8' Caption = 'FromNow' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4233 mmLeft = 165100 mmTop = 5821 mmWidth = 14817 BandType = 0 end object ppLabel9: TppLabel UserName = 'Label9' Caption = 'Performed' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4106 mmLeft = 186341 mmTop = 5821 mmWidth = 15536 BandType = 0 end object ppLabel10: TppLabel UserName = 'Label10' Caption = 'Date Based' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] mmHeight = 4106 mmLeft = 129646 mmTop = 1588 mmWidth = 16552 BandType = 0 end object ppLine4: TppLine UserName = 'Line4' Weight = 0.75 mmHeight = 1852 mmLeft = 165629 mmTop = 3704 mmWidth = 35719 BandType = 0 end object ppLabel11: TppLabel UserName = 'Label101' Caption = 'Count Based' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] mmHeight = 4233 mmLeft = 173038 mmTop = 1588 mmWidth = 18785 BandType = 0 end object ppLabel3: TppLabel UserName = 'Label3' Caption = 'Status' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4106 mmLeft = 71702 mmTop = 5821 mmWidth = 8975 BandType = 0 end end object ppDetailBand1: TppDetailBand mmBottomOffset = 0 mmHeight = 3969 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' DataField = 'Service' DataPipeline = daADOQueryDataView1.ScheduledServices Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 3175 mmLeft = 10054 mmTop = 529 mmWidth = 60325 BandType = 4 end object ppDBText3: TppDBText UserName = 'DBText3' AutoSize = True DataField = 'Interval' DataPipeline = daADOQueryDataView1.ScheduledServices DisplayFormat = '#,0;-#,0' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 3260 mmLeft = 92593 mmTop = 529 mmWidth = 9271 BandType = 4 end object ppDBText4: TppDBText UserName = 'DBText4' AutoSize = True DataField = 'Period' DataPipeline = daADOQueryDataView1.ScheduledServices Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 3260 mmLeft = 104511 mmTop = 529 mmWidth = 8170 BandType = 4 end object ppDBText5: TppDBText UserName = 'DBText5' AutoSize = True DataField = 'ScheduledDate' DataPipeline = daADOQueryDataView1.ScheduledServices DisplayFormat = 'mm/dd/yyyy' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 3260 mmLeft = 121444 mmTop = 529 mmWidth = 19346 BandType = 4 end object ppDBText6: TppDBText UserName = 'DBText6' AutoSize = True DataField = 'LastPerformedDate' DataPipeline = daADOQueryDataView1.ScheduledServices DisplayFormat = 'mm/dd/yyyy' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 3260 mmLeft = 132831 mmTop = 529 mmWidth = 24596 BandType = 4 end object ppDBText7: TppDBText UserName = 'DBText7' AutoSize = True DataField = 'FromNow' DataPipeline = daADOQueryDataView1.ScheduledServices DisplayFormat = '#,0;-#,0' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 3260 mmLeft = 167683 mmTop = 529 mmWidth = 12234 BandType = 4 end object ppDBText8: TppDBText UserName = 'DBText8' AutoSize = True DataField = 'LastPerformedMiles' DataPipeline = daADOQueryDataView1.ScheduledServices DisplayFormat = '#,0;-#,0' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 3260 mmLeft = 176646 mmTop = 529 mmWidth = 25231 BandType = 4 end object ppDBText10: TppDBText UserName = 'DBText10' DataField = 'Status' DataPipeline = daADOQueryDataView1.ScheduledServices Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 3175 mmLeft = 71702 mmTop = 529 mmWidth = 17198 BandType = 4 end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 7144 mmPrintPosition = 0 object ppLine2: TppLine UserName = 'Line2' Pen.Color = clGray Pen.Width = 2 Weight = 1.5 mmHeight = 3969 mmLeft = 1323 mmTop = 5821 mmWidth = 200555 BandType = 8 end object ppSystemVariable1: TppSystemVariable UserName = 'SystemVariable1' VarType = vtPrintDateTime Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 4487 mmLeft = 1323 mmTop = 1323 mmWidth = 17187 BandType = 8 end object ppSystemVariable2: TppSystemVariable UserName = 'SystemVariable2' VarType = vtPageNoDesc Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 4487 mmLeft = 184680 mmTop = 1323 mmWidth = 17187 BandType = 8 end end object ppSummaryBand1: TppSummaryBand mmBottomOffset = 0 mmHeight = 5292 mmPrintPosition = 0 object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' AutoSize = True DataField = 'Service' DataPipeline = daADOQueryDataView1.ScheduledServices DisplayFormat = 'Total Number of Records: #####0' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [] Transparent = True DBCalcType = dcCount DataPipelineName = 'ScheduledServices' mmHeight = 4149 mmLeft = 1588 mmTop = 529 mmWidth = 21463 BandType = 7 end end object ppGroup1: TppGroup BreakName = 'UnitName' DataPipeline = daADOQueryDataView1.ScheduledServices KeepTogether = True OutlineSettings.CreateNode = True UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'ScheduledServices' object ppGroupHeaderBand1: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 6879 mmPrintPosition = 0 object ppDBText2: TppDBText UserName = 'DBText2' AutoSize = True DataField = 'Name' DataPipeline = daADOQueryDataView1.ScheduledServices Font.Charset = DEFAULT_CHARSET Font.Color = clBlue Font.Name = 'ARIAL' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 4106 mmLeft = 1588 mmTop = 2117 mmWidth = 23241 BandType = 3 GroupNo = 0 end end object ppGroupFooterBand1: TppGroupFooterBand mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_ScheduledServices' Height = 289 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 306 AutoSearchTabOrder = 0 object ScheduledServices: TppChildDBPipeline AutoCreateFields = False UserName = 'ScheduledServices' object ppField1: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 80 DisplayWidth = 80 Position = 0 TableName = 'Units' end object ppField2: TppField FieldAlias = 'Unit' FieldName = 'Unit' FieldLength = 25 DisplayWidth = 25 Position = 1 TableName = 'Units' end object ppField3: TppField FieldAlias = 'ItemSeq' FieldName = 'ItemSeq' FieldLength = 0 IsDetail = True DataType = dtDouble DisplayWidth = 0 Position = 2 TableName = 'Servitem' end object ppField4: TppField FieldAlias = 'FromNow' FieldName = 'FromNow' FieldLength = 5 IsDetail = True DataType = dtDouble DisplayWidth = 5 Position = 3 TableName = 'Servitem' end object ppField5: TppField FieldAlias = 'Interval' FieldName = 'Interval' FieldLength = 5 IsDetail = True DataType = dtDouble DisplayWidth = 5 Position = 4 TableName = 'Servitem' end object ppField6: TppField FieldAlias = 'LastPerformedDate' FieldName = 'LastPerformedDate' FieldLength = 0 IsDetail = True DataType = dtDateTime DisplayWidth = 0 Position = 5 TableName = 'Servitem' end object ppField7: TppField FieldAlias = 'LastPerformedMiles' FieldName = 'LastPerformedMiles' FieldLength = 5 IsDetail = True DataType = dtDouble DisplayWidth = 5 Position = 6 TableName = 'Servitem' end object ppField8: TppField FieldAlias = 'Period' FieldName = 'Period' FieldLength = 6 IsDetail = True DisplayWidth = 6 Position = 7 TableName = 'Servitem' end object ppField9: TppField FieldAlias = 'Scheduled' FieldName = 'Scheduled' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 8 TableName = 'Servitem' end object ppField10: TppField FieldAlias = 'ScheduledDate' FieldName = 'ScheduledDate' FieldLength = 0 IsDetail = True DataType = dtDateTime DisplayWidth = 0 Position = 9 TableName = 'Servitem' end object ppField11: TppField FieldAlias = 'Service' FieldName = 'Service' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 10 TableName = 'Servitem' end object ppField12: TppField FieldAlias = 'SeparateWO' FieldName = 'SeparateWO' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 11 TableName = 'Servitem' end object ppField13: TppField FieldAlias = 'UnitName' FieldName = 'UnitName' FieldLength = 80 IsDetail = True DisplayWidth = 80 Position = 12 TableName = 'Servitem' end object ppField14: TppField FieldAlias = 'Status' FieldName = 'Status' FieldLength = 8 IsDetail = True DisplayWidth = 8 Position = 13 TableName = 'Servitem' end end object daSQL1: TdaSQL DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'ScheduledServices' LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Units.Name, Units.Unit, Servitem.ItemSeq, ' ' Servitem.FromNow, Servitem.Interval, ' ' Servitem.LastPerformedDate, ' ' Servitem.LastPerformedMiles, ' ' Servitem.Period, Servitem.Scheduled, ' ' Servitem.ScheduledDate, Servitem.Service, ' ' Servitem.SeparateWO, Servitem.UnitName, ' ' Servitem.Status' 'FROM Units Units INNER JOIN Servitem Servitem ON ' ' (Servitem.Unit = Units.RecordNumber)' 'ORDER BY Units.Name, Servitem.ItemSeq, ' ' Servitem.Scheduled') SQLType = sqSQL2 object daField1: TdaField Alias = 'Name' DisplayWidth = 80 FieldAlias = 'Name' FieldLength = 80 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField2: TdaField Alias = 'Unit' DisplayWidth = 25 FieldAlias = 'Unit' FieldLength = 25 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField3: TdaField Alias = 'ItemSeq' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'ItemSeq' FieldLength = 0 FieldName = 'ItemSeq' IsDetail = True SQLFieldName = 'ItemSeq' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField4: TdaField Alias = 'FromNow' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'FromNow' FieldLength = 5 FieldName = 'FromNow' IsDetail = True SQLFieldName = 'FromNow' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField5: TdaField Alias = 'Interval' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'Interval' FieldLength = 5 FieldName = 'Interval' IsDetail = True SQLFieldName = 'Interval' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField6: TdaField Alias = 'LastPerformedDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'LastPerformedDate' FieldLength = 0 FieldName = 'LastPerformedDate' IsDetail = True SQLFieldName = 'LastPerformedDate' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField7: TdaField Alias = 'LastPerformedMiles' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'LastPerformedMiles' FieldLength = 5 FieldName = 'LastPerformedMiles' IsDetail = True SQLFieldName = 'LastPerformedMiles' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField8: TdaField Alias = 'Period' DisplayWidth = 6 FieldAlias = 'Period' FieldLength = 6 FieldName = 'Period' IsDetail = True SQLFieldName = 'Period' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField9: TdaField Alias = 'Scheduled' DisplayWidth = 10 FieldAlias = 'Scheduled' FieldLength = 10 FieldName = 'Scheduled' IsDetail = True SQLFieldName = 'Scheduled' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField10: TdaField Alias = 'ScheduledDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'ScheduledDate' FieldLength = 0 FieldName = 'ScheduledDate' IsDetail = True SQLFieldName = 'ScheduledDate' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField11: TdaField Alias = 'Service' DisplayWidth = 50 FieldAlias = 'Service' FieldLength = 50 FieldName = 'Service' IsDetail = True SQLFieldName = 'Service' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField12: TdaField Alias = 'SeparateWO' DisplayWidth = 1 FieldAlias = 'SeparateWO' FieldLength = 1 FieldName = 'SeparateWO' IsDetail = True SQLFieldName = 'SeparateWO' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField13: TdaField Alias = 'UnitName' DisplayWidth = 80 FieldAlias = 'UnitName' FieldLength = 80 FieldName = 'UnitName' IsDetail = True SQLFieldName = 'UnitName' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField14: TdaField Alias = 'Status' DisplayWidth = 8 FieldAlias = 'Status' FieldLength = 8 FieldName = 'Status' IsDetail = True SQLFieldName = 'Status' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField15: TdaField ChildType = 2 Alias = 'Name' DisplayWidth = 80 FieldAlias = 'Name' FieldLength = 80 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField16: TdaField ChildType = 2 Alias = 'ItemSeq' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'ItemSeq' FieldLength = 0 FieldName = 'ItemSeq' SQLFieldName = 'ItemSeq' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField17: TdaField ChildType = 2 Alias = 'Scheduled' DisplayWidth = 10 FieldAlias = 'Scheduled' FieldLength = 10 FieldName = 'Scheduled' SQLFieldName = 'Scheduled' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daTable1: TdaTable ChildType = 5 Alias = 'Units' JoinType = dajtNone SQLAlias = 'Units' TableAlias = 'Units' TableName = 'Units' end object daTable2: TdaTable ChildType = 5 Alias = 'Servitem' SQLAlias = 'Servitem' TableAlias = 'Servitem' TableName = 'Servitem' object daTableJoin1: TdaTableJoin ChildType = 6 object daField19: TdaField ChildType = 3 Alias = 'Unit' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Unit' FieldLength = 0 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField18: TdaField ChildType = 4 Alias = 'RecordNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'RecordNumber' FieldLength = 0 FieldName = 'RecordNumber' SQLFieldName = 'RecordNumber' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end end end end end end object ppParameterList1: TppParameterList end end