object Report: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.Kurs_Tabelle PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Kursliste_pro_S_mit_Endn_und_Teill_und_Fehlstd_para_Klasse_KurzB' + 'ez_ASDJgg.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 6350 PrinterSetup.mmMarginLeft = 12350 PrinterSetup.mmMarginRight = 4000 PrinterSetup.mmMarginTop = 6350 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 SaveAsTemplate = True Template.FileName = 'C:\SchILD-NRW\SchILD-Reports\Wbk_Bochum_Reports_SPR\0_Special\Te' + 'illeistungen\Kursliste_pro_S_mit_Endn_und_Teill_und_Fehlstd_para' + '_Klasse_KurzBez_ASDJgg.rtm' Template.Format = ftASCII Units = utMillimeters AllowPrintToArchive = True AllowPrintToFile = True ArchiveFileName = '($MyDocuments)\ReportArchive.raf' DeviceType = 'Screen' DefaultFileDeviceType = 'PDF' EmailSettings.ReportFormat = 'PDF' EmailSettings.DeleteFile = False EmailSettings.Enabled = True EmailSettings.PreviewInEmailClient = False EmailSettings.ShowEmailDialog = True Icon.Data = { 0000010001002020100000000000E80200001600000028000000200000004000 0000010004000000000080020000000000000000000000000000000000000000 000000008000008000000080800080000000800080008080000080808000C0C0 C0000000FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF000000 0000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000 00000000C00000CC00000000000000000000000C0C000C00C000000000000000 0000000C00CCC00000000000000000000000000C000000000000000000000000 00007777C7770000000000000000000000007BBBCBB7000F0000000000000000 00007BCCBBB700FFF00000000000000000007BBBBBB700FFF000000000000000 00007BBBBBB700FF770000000000000000007333BBB7000F7B00000000000000 000070003BB70007B7700000000000000000999903B700007B70000000000000 0001999990770000B7B700000000000000019999900000000B77000000000000 0001999990000000000010000000000000011999900000000071700000000000 0000111100000000001710000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000 000000000000000000000000000000000000000000000000000000000000FFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF7 CFFFFFEBB7FFFFEC3FFFFFEF9FFFFF008FFFFF0087FFFF0083FFFF0083FFFF00 81FFFF00C1FFFF00C0FFFE00E0FFFC00E07FFC03F07FFC03F03FFC03F83FFE07 F83FFF0FFC7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF} LanguageID = 'Default' OpenFile = False OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = True OutlineSettings.Visible = True ThumbnailSettings.Enabled = True ThumbnailSettings.Visible = True ThumbnailSettings.DeadSpace = 30 PDFSettings.Author = 'Schild-NRW' PDFSettings.EmbedFontOptions = [] PDFSettings.EncryptSettings.AllowCopy = True PDFSettings.EncryptSettings.AllowInteract = True PDFSettings.EncryptSettings.AllowModify = True PDFSettings.EncryptSettings.AllowPrint = True PDFSettings.EncryptSettings.Enabled = False PDFSettings.EncryptSettings.KeyLength = kl40Bit PDFSettings.FontEncoding = feAnsi PDFSettings.ImageCompressionLevel = 25 PreviewFormSettings.ZoomSetting = zs100Percent PreviewFormSettings.SinglePageOnly = True RTFSettings.DefaultFont.Charset = DEFAULT_CHARSET RTFSettings.DefaultFont.Color = clWindowText RTFSettings.DefaultFont.Height = -15 RTFSettings.DefaultFont.Name = 'Arial' RTFSettings.DefaultFont.Style = [] TextFileName = '($MyDocuments)\Report.pdf' TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True XLSSettings.AppName = 'ReportBuilder' XLSSettings.Author = 'ReportBuilder' XLSSettings.Subject = 'Report' XLSSettings.Title = 'Report' Left = 128 Top = 8 Version = '15.05' mmColumnWidth = 193650 DataPipelineName = 'Kurs_Tabelle' object ppDetailBand1: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 5821 mmPrintPosition = 0 object ppDBText3: TppDBText UserName = 'DBText3' DataField = 'KurzBez' DataPipeline = daADOQueryDataView1.Kurs_Tabelle Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 7 Font.Style = [] Transparent = True VerticalAlignment = avCenter DataPipelineName = 'Kurs_Tabelle' mmHeight = 3704 mmLeft = 19844 mmTop = 1058 mmWidth = 14288 BandType = 4 LayerName = Foreground1 end object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' DataPipeline = daADOQueryDataView1.Kurs_Tabelle Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 7 Font.Style = [] ResetGroup = ppGroup6 TextAlignment = taRightJustified Transparent = True DBCalcType = dcCount DataPipelineName = 'Kurs_Tabelle' mmHeight = 3260 mmLeft = 0 mmTop = 1585 mmWidth = 4000 BandType = 4 LayerName = Foreground1 end object ppLine4: TppLine UserName = 'Line4' Weight = 0.750000000000000000 mmHeight = 1058 mmLeft = 0 mmTop = 0 mmWidth = 187855 BandType = 4 LayerName = Foreground1 end object ppLine5: TppLine UserName = 'Line5' ParentHeight = True Position = lpLeft Weight = 0.750000000000000000 mmHeight = 5821 mmLeft = 0 mmTop = 0 mmWidth = 1000 BandType = 4 LayerName = Foreground1 end object ppLine6: TppLine UserName = 'Line6' ParentHeight = True Position = lpLeft Weight = 0.750000000000000000 mmHeight = 5821 mmLeft = 4763 mmTop = 0 mmWidth = 1058 BandType = 4 LayerName = Foreground1 end object ppLine28: TppLine UserName = 'Line28' ParentHeight = True Position = lpRight Weight = 0.750000000000000000 mmHeight = 5821 mmLeft = 186267 mmTop = 0 mmWidth = 1588 BandType = 4 LayerName = Foreground1 end object ppLine12: TppLine UserName = 'Line12' ParentHeight = True Position = lpRight Weight = 0.750000000000000000 mmHeight = 5821 mmLeft = 51594 mmTop = 0 mmWidth = 1058 BandType = 4 LayerName = Foreground1 end object ppDBText8: TppDBText UserName = 'DBT_Note' DataField = 'NotenKrz' DataPipeline = daADOQueryDataView1.Kurs_Tabelle Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'Kurs_Tabelle' mmHeight = 4498 mmLeft = 53181 mmTop = 812 mmWidth = 7408 BandType = 4 LayerName = Foreground1 end object ppLabel14: TppLabel UserName = 'La_Pkt' Caption = 'La_Pkt' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] TextAlignment = taCentered Transparent = True mmHeight = 3704 mmLeft = 60854 mmTop = 813 mmWidth = 8996 BandType = 4 LayerName = Foreground1 end object ppLine9: TppLine UserName = 'Line9' Pen.Width = 2 ParentHeight = True Position = lpRight Weight = 1.500000000000000000 mmHeight = 5821 mmLeft = 67998 mmTop = 0 mmWidth = 2117 BandType = 4 LayerName = Foreground1 end object ppLine11: TppLine UserName = 'Line11' Pen.Style = psDot ParentHeight = True Position = lpRight Weight = 0.750000000000000000 mmHeight = 5821 mmLeft = 88024 mmTop = 0 mmWidth = 2117 BandType = 4 LayerName = Foreground1 end object ppDBText4: TppDBText UserName = 'DBText4' DataField = 'Kursart' DataPipeline = daADOQueryDataView1.Kurs_Tabelle Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 7 Font.Style = [] TextAlignment = taRightJustified Transparent = True VerticalAlignment = avCenter DataPipelineName = 'Kurs_Tabelle' mmHeight = 3704 mmLeft = 45773 mmTop = 1232 mmWidth = 5821 BandType = 4 LayerName = Foreground1 end object ppLine3: TppLine UserName = 'Line3' Pen.Width = 2 ParentHeight = True Position = lpRight Weight = 1.500000000000000000 mmHeight = 5821 mmLeft = 107419 mmTop = 0 mmWidth = 2117 BandType = 4 LayerName = Foreground1 end object ppSubReport2: TppSubReport UserName = 'Kl2' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentPrinterSetup = False ParentWidth = False TraverseAllData = False DataPipelineName = 'Kl_2' mmHeight = 4763 mmLeft = 76991 mmTop = 793 mmWidth = 5292 BandType = 4 LayerName = Foreground1 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport2: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView2.Kl_2 PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = '- Kursliste_mit_Teilleistungen.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 0 PrinterSetup.mmMarginLeft = 0 PrinterSetup.mmMarginRight = 0 PrinterSetup.mmMarginTop = 0 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Offset = 284 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 210000 DataPipelineName = 'Kl_2' object ppDetailBand3: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 4498 mmPrintPosition = 0 object ppDBText6: TppDBText UserName = 'DBT_Kl2' DataField = 'Art_ID' DataPipeline = daADOQueryDataView2.Kl_2 Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'Kl_2' mmHeight = 4498 mmLeft = 95 mmTop = 0 mmWidth = 6208 BandType = 4 LayerName = Foreground2 end end object raCodeModule3: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650610 4442545F4B6C324F6E476574546578740B50726F6772616D54797065070B7474 50726F63656475726506536F75726365066070726F636564757265204442545F 4B6C324F6E476574546578742876617220546578743A20537472696E67293B0D 0A626567696E0D0A0D0A49662074657874203D202727207468656E2074657874 3A3D20272D2D273B0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D65 06074442545F4B6C32094576656E744E616D6506094F6E476574546578740745 76656E7449440235084361726574506F730102010201000000} end object ppDesignLayers3: TppDesignLayers object ppDesignLayer3: TppDesignLayer UserName = 'Foreground2' LayerType = ltBanded Index = 0 end end end end object ppSubReport3: TppSubReport UserName = 'Klges' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentPrinterSetup = False ParentWidth = False TraverseAllData = False DataPipelineName = 'Kl_ges' mmHeight = 4763 mmLeft = 83079 mmTop = 793 mmWidth = 5292 BandType = 4 LayerName = Foreground1 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport3: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView7.Kl_ges PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = '- Kursliste_mit_Teilleistungen.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 0 PrinterSetup.mmMarginLeft = 0 PrinterSetup.mmMarginRight = 0 PrinterSetup.mmMarginTop = 0 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Offset = 284 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 210000 DataPipelineName = 'Kl_ges' object ppDetailBand4: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 4498 mmPrintPosition = 0 object ppDBText7: TppDBText UserName = 'DBT_Klges' DataField = 'Art_ID' DataPipeline = daADOQueryDataView7.Kl_ges Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'Kl_ges' mmHeight = 4498 mmLeft = 95 mmTop = 0 mmWidth = 6208 BandType = 4 LayerName = PageLayer1 end end object raCodeModule4: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650612 4442545F4B6C6765734F6E476574546578740B50726F6772616D54797065070B 747450726F63656475726506536F75726365066270726F636564757265204442 545F4B6C6765734F6E476574546578742876617220546578743A20537472696E 67293B0D0A626567696E0D0A0D0A49662074657874203D202727207468656E20 746578743A3D20272D2D273B0D0A0D0A656E643B0D0A0D436F6D706F6E656E74 4E616D6506094442545F4B6C676573094576656E744E616D6506094F6E476574 54657874074576656E7449440235084361726574506F730102010201000000} end object ppDesignLayers4: TppDesignLayers object ppDesignLayer4: TppDesignLayer UserName = 'PageLayer1' LayerType = ltBanded Index = 0 end end end end object ppSubReport4: TppSubReport UserName = 'So1' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentPrinterSetup = False ParentWidth = False TraverseAllData = False DataPipelineName = 'So_1' mmHeight = 4763 mmLeft = 90627 mmTop = 933 mmWidth = 5292 BandType = 4 LayerName = Foreground1 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport4: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView5.So_1 PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = '- Kursliste_mit_Teilleistungen.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 0 PrinterSetup.mmMarginLeft = 0 PrinterSetup.mmMarginRight = 0 PrinterSetup.mmMarginTop = 0 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Offset = 284 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 210000 DataPipelineName = 'So_1' object ppDetailBand5: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 4498 mmPrintPosition = 0 object ppDBText9: TppDBText UserName = 'DBT_So1' DataField = 'NotenKrz' DataPipeline = daADOQueryDataView5.So_1 Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'So_1' mmHeight = 4498 mmLeft = 95 mmTop = 0 mmWidth = 6208 BandType = 4 LayerName = Foreground3 end end object raCodeModule5: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650610 4442545F536F314F6E476574546578740B50726F6772616D54797065070B7474 50726F63656475726506536F75726365066070726F636564757265204442545F 536F314F6E476574546578742876617220546578743A20537472696E67293B0D 0A626567696E0D0A0D0A49662074657874203D202727207468656E2074657874 3A3D20272D2D273B0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D65 06074442545F536F31094576656E744E616D6506094F6E476574546578740745 76656E7449440235084361726574506F730102010201000000} end object ppDesignLayers5: TppDesignLayers object ppDesignLayer5: TppDesignLayer UserName = 'Foreground3' LayerType = ltBanded Index = 0 end end end end object ppSubReport5: TppSubReport UserName = 'So2' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentPrinterSetup = False ParentWidth = False TraverseAllData = False DataPipelineName = 'So_2' mmHeight = 4763 mmLeft = 96572 mmTop = 793 mmWidth = 5292 BandType = 4 LayerName = Foreground1 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport5: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView6.So_2 PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = '- Kursliste_mit_Teilleistungen.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 0 PrinterSetup.mmMarginLeft = 0 PrinterSetup.mmMarginRight = 0 PrinterSetup.mmMarginTop = 0 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Offset = 284 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 210000 DataPipelineName = 'So_2' object ppDetailBand6: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 4498 mmPrintPosition = 0 object ppDBText10: TppDBText UserName = 'DBT_So2' DataField = 'NotenKrz' DataPipeline = daADOQueryDataView6.So_2 Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'So_2' mmHeight = 4498 mmLeft = 95 mmTop = 0 mmWidth = 6208 BandType = 4 LayerName = PageLayer2 end end object raCodeModule6: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650610 4442545F536F324F6E476574546578740B50726F6772616D54797065070B7474 50726F63656475726506536F75726365066070726F636564757265204442545F 536F324F6E476574546578742876617220546578743A20537472696E67293B0D 0A626567696E0D0A0D0A49662074657874203D202727207468656E2074657874 3A3D20272D2D273B0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D65 06074442545F536F32094576656E744E616D6506094F6E476574546578740745 76656E7449440235084361726574506F730102010201000000} end object ppDesignLayers6: TppDesignLayers object ppDesignLayer6: TppDesignLayer UserName = 'PageLayer2' LayerType = ltBanded Index = 0 end end end end object ppSubReport6: TppSubReport UserName = 'Soges' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentPrinterSetup = False ParentWidth = False TraverseAllData = False DataPipelineName = 'So_ges' mmHeight = 4763 mmLeft = 102658 mmTop = 793 mmWidth = 5292 BandType = 4 LayerName = Foreground1 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport6: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView4.So_ges PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = '- Kursliste_mit_Teilleistungen.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 0 PrinterSetup.mmMarginLeft = 0 PrinterSetup.mmMarginRight = 0 PrinterSetup.mmMarginTop = 0 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Offset = 284 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 210000 DataPipelineName = 'So_ges' object ppDetailBand7: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 4498 mmPrintPosition = 0 object ppDBText11: TppDBText UserName = 'DBT_Soges' DataField = 'NotenKrz' DataPipeline = daADOQueryDataView4.So_ges Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'So_ges' mmHeight = 4498 mmLeft = 95 mmTop = 0 mmWidth = 6208 BandType = 4 LayerName = PageLayer3 end end object raCodeModule7: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650612 4442545F536F6765734F6E476574546578740B50726F6772616D54797065070B 747450726F63656475726506536F75726365066270726F636564757265204442 545F536F6765734F6E476574546578742876617220546578743A20537472696E 67293B0D0A626567696E0D0A0D0A49662074657874203D202727207468656E20 746578743A3D20272D2D273B0D0A0D0A656E643B0D0A0D436F6D706F6E656E74 4E616D6506094442545F536F676573094576656E744E616D6506094F6E476574 54657874074576656E7449440235084361726574506F730102010201000000} end object ppDesignLayers7: TppDesignLayers object ppDesignLayer7: TppDesignLayer UserName = 'PageLayer3' LayerType = ltBanded Index = 0 end end end end object ppSubReport1: TppSubReport UserName = 'Kl1' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentPrinterSetup = False ParentWidth = False TraverseAllData = False DataPipelineName = 'Kl_1' mmHeight = 4763 mmLeft = 70908 mmTop = 793 mmWidth = 5292 BandType = 4 LayerName = Foreground1 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport1: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView3.Kl_1 PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = '- Kursliste_mit_Teilleistungen.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 0 PrinterSetup.mmMarginLeft = 0 PrinterSetup.mmMarginRight = 0 PrinterSetup.mmMarginTop = 0 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Offset = 284 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 210000 DataPipelineName = 'Kl_1' object ppDetailBand2: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 4498 mmPrintPosition = 0 object ppDBText2: TppDBText UserName = 'DBT_Kl1' DataField = 'Art_ID' DataPipeline = daADOQueryDataView3.Kl_1 Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'Kl_1' mmHeight = 4498 mmLeft = 95 mmTop = 0 mmWidth = 6208 BandType = 4 LayerName = Foreground end end object raCodeModule2: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650610 4442545F4B6C314F6E476574546578740B50726F6772616D54797065070B7474 50726F63656475726506536F75726365066270726F636564757265204442545F 4B6C314F6E476574546578742876617220546578743A20537472696E67293B0D 0A626567696E0D0A0D0A2049662074657874203D202727207468656E20746578 743A3D20272D2D273B200D0A0D0A656E643B0D0A0D436F6D706F6E656E744E61 6D6506074442545F4B6C31094576656E744E616D6506094F6E47657454657874 074576656E7449440235084361726574506F730102010203000000} end object ppDesignLayers1: TppDesignLayers object ppDesignLayer1: TppDesignLayer UserName = 'Foreground' LayerType = ltBanded Index = 0 end end end end object ppLabel15: TppLabel UserName = 'La_k1nz' Caption = 'nz' Font.Charset = DEFAULT_CHARSET Font.Color = clGray Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3440 mmLeft = 72231 mmTop = 661 mmWidth = 2646 BandType = 4 LayerName = Foreground1 end object ppLabel16: TppLabel UserName = 'La_k2nz' Caption = 'nz' Font.Charset = DEFAULT_CHARSET Font.Color = clGray Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3440 mmLeft = 78581 mmTop = 661 mmWidth = 2646 BandType = 4 LayerName = Foreground1 end object ppLabel17: TppLabel UserName = 'La_kgesnz' Caption = 'nz' Font.Charset = DEFAULT_CHARSET Font.Color = clGray Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3440 mmLeft = 84667 mmTop = 661 mmWidth = 2646 BandType = 4 LayerName = Foreground1 end object ppLabel18: TppLabel UserName = 'La_so1nz' Caption = 'nz' Font.Charset = DEFAULT_CHARSET Font.Color = clGray Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3440 mmLeft = 92075 mmTop = 661 mmWidth = 2646 BandType = 4 LayerName = Foreground1 end object ppLabel19: TppLabel UserName = 'La_so2nz' Caption = 'nz' Font.Charset = DEFAULT_CHARSET Font.Color = clGray Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3440 mmLeft = 98161 mmTop = 661 mmWidth = 2645 BandType = 4 LayerName = Foreground1 end object ppLabel20: TppLabel UserName = 'La_sogesnz' Caption = 'nz' Font.Charset = DEFAULT_CHARSET Font.Color = clGray Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3440 mmLeft = 104246 mmTop = 661 mmWidth = 2646 BandType = 4 LayerName = Foreground1 end object ppDBText13: TppDBText UserName = 'DBT_Fehlstd' DataField = 'Fehlstd' DataPipeline = daADOQueryDataView1.Kurs_Tabelle Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] Transparent = True DataPipelineName = 'Kurs_Tabelle' mmHeight = 4498 mmLeft = 112449 mmTop = 1058 mmWidth = 12700 BandType = 4 LayerName = Foreground1 end object ppDBText15: TppDBText UserName = 'DBText6' DataField = 'FachKrz' DataPipeline = daADOQueryDataView1.Kurs_Tabelle Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'Kurs_Tabelle' mmHeight = 4498 mmLeft = 7673 mmTop = 1058 mmWidth = 11113 BandType = 4 LayerName = Foreground1 end object ppDBText16: TppDBText UserName = 'DBText7' DataField = 'FachLehrer' DataPipeline = daADOQueryDataView1.Kurs_Tabelle Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 7 Font.Style = [] Transparent = True VerticalAlignment = avCenter DataPipelineName = 'Kurs_Tabelle' mmHeight = 4498 mmLeft = 35190 mmTop = 795 mmWidth = 7408 BandType = 4 LayerName = Foreground1 end object ppDBText5: TppDBText UserName = 'DBText1' AutoSize = True DataField = 'Warnung' DataPipeline = daADOQueryDataView1.Kurs_Tabelle Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 11 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'Kurs_Tabelle' mmHeight = 4762 mmLeft = 131234 mmTop = 793 mmWidth = 14816 BandType = 4 LayerName = Foreground1 end end object ppFooterBand1: TppFooterBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppGroup1: TppGroup BreakName = 'ASDSchulgliederung' DataPipeline = daADOQueryDataView1.Kurs_Tabelle GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True NewColumn = True NewPage = True StartOnOddPage = False UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Kurs_Tabelle' NewFile = False object ppGroupHeaderBand1: TppGroupHeaderBand Background.Brush.Style = bsClear PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 10054 mmPrintPosition = 0 object ppShape1: TppShape UserName = 'Shape1' Brush.Color = cl3DLight Pen.Style = psClear mmHeight = 5821 mmLeft = 0 mmTop = 4233 mmWidth = 187855 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppDBText1: TppDBText UserName = 'DBT_Kurs_FL' DataField = 'Name' DataPipeline = daADOQueryDataView1.Kurs_Tabelle Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [fsBold] Transparent = True DataPipelineName = 'Kurs_Tabelle' mmHeight = 3704 mmLeft = 2117 mmTop = 5233 mmWidth = 34131 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel2: TppLabel UserName = 'La_Jahr_Abs' Caption = 'La_Jahr_Abs' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 171186 mmTop = 0 mmWidth = 16139 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLine14: TppLine UserName = 'Line14' Position = lpRight Weight = 0.750000000000000000 mmHeight = 5821 mmLeft = 50536 mmTop = 4233 mmWidth = 2117 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel5: TppLabel UserName = 'Label4' Caption = '1' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 7 Font.Style = [fsBold] Transparent = True mmHeight = 2910 mmLeft = 73150 mmTop = 6879 mmWidth = 1323 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel3: TppLabel UserName = 'Label3' Caption = '2' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 7 Font.Style = [fsBold] Transparent = True mmHeight = 2910 mmLeft = 79375 mmTop = 6879 mmWidth = 1323 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel4: TppLabel UserName = 'Label1' Caption = 'G' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 7 Font.Style = [fsBold] Transparent = True mmHeight = 2911 mmLeft = 85367 mmTop = 6879 mmWidth = 1587 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel9: TppLabel UserName = 'Label5' Caption = 'Endnote' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 7 Font.Style = [fsBold] Transparent = True mmHeight = 2910 mmLeft = 56621 mmTop = 4498 mmWidth = 8467 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel10: TppLabel UserName = 'Label9' Caption = 'Note' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 7 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True mmHeight = 2910 mmLeft = 54504 mmTop = 6879 mmWidth = 5027 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel11: TppLabel UserName = 'Label10' Caption = 'Pkt' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 7 Font.Style = [fsBold] Transparent = True mmHeight = 2910 mmLeft = 63765 mmTop = 6879 mmWidth = 3175 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel13: TppLabel UserName = 'Label12' Caption = 'SoMi' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 7 Font.Style = [fsBold] Transparent = True mmHeight = 2910 mmLeft = 96838 mmTop = 4498 mmWidth = 5027 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel12: TppLabel UserName = 'Label11' Caption = 'Klausur' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 7 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True mmHeight = 2910 mmLeft = 76465 mmTop = 4498 mmWidth = 7408 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLine8: TppLine UserName = 'Line8' Pen.Width = 2 Position = lpRight Weight = 1.500000000000000000 mmHeight = 5556 mmLeft = 67998 mmTop = 4233 mmWidth = 2117 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLine10: TppLine UserName = 'Line10' Pen.Style = psDot Position = lpRight Weight = 0.750000000000000000 mmHeight = 5556 mmLeft = 87842 mmTop = 4233 mmWidth = 2117 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel1: TppLabel UserName = 'Label6' Caption = '1' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 7 Font.Style = [fsBold] Transparent = True mmHeight = 2910 mmLeft = 92994 mmTop = 6879 mmWidth = 1323 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel6: TppLabel UserName = 'Label7' Caption = '2' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 7 Font.Style = [fsBold] Transparent = True mmHeight = 2910 mmLeft = 98954 mmTop = 6879 mmWidth = 1323 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel7: TppLabel UserName = 'Label8' Caption = 'G' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 7 Font.Style = [fsBold] Transparent = True mmHeight = 2911 mmLeft = 105086 mmTop = 6879 mmWidth = 1588 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLine2: TppLine UserName = 'Line2' Pen.Width = 2 Position = lpRight Weight = 1.500000000000000000 mmHeight = 5556 mmLeft = 107421 mmTop = 4233 mmWidth = 2117 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel8: TppLabel UserName = 'Label13' Caption = 'Noten und Teilleistungen ' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [fsBold] Transparent = True mmHeight = 3704 mmLeft = 0 mmTop = 0 mmWidth = 34131 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel21: TppLabel UserName = 'La_Legende' Caption = '[ nz: Teilleistung nicht zugewiesen]' Font.Charset = DEFAULT_CHARSET Font.Color = clGray Font.Name = 'Calibri' Font.Size = 7 Font.Style = [] Transparent = True mmHeight = 2910 mmLeft = 37042 mmTop = 440 mmWidth = 33602 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel22: TppLabel UserName = 'Label22' Caption = 'Fehlstd. (ue)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [fsBold] Transparent = True mmHeight = 3704 mmLeft = 111919 mmTop = 5292 mmWidth = 16404 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLine7: TppLine UserName = 'Line7' Weight = 0.750000000000000000 mmHeight = 1058 mmLeft = 0 mmTop = 4233 mmWidth = 187855 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLine13: TppLine UserName = 'Line13' Position = lpLeft Weight = 0.750000000000000000 mmHeight = 5843 mmLeft = 0 mmTop = 4189 mmWidth = 1000 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLine15: TppLine UserName = 'Line15' Position = lpRight Weight = 0.750000000000000000 mmHeight = 5843 mmLeft = 186267 mmTop = 4189 mmWidth = 1588 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppDBText12: TppDBText UserName = 'DBT_Klasse_JG' AutoSize = True DataField = 'Klasse' DataPipeline = daADOQueryDataView1.Kurs_Tabelle Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Calibri' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Kurs_Tabelle' mmHeight = 3440 mmLeft = 178330 mmTop = 6546 mmWidth = 7408 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel23: TppLabel UserName = 'Label2' Caption = 'Klasse / Jahrgang' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 7 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True mmHeight = 2910 mmLeft = 168805 mmTop = 4233 mmWidth = 16933 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLabel28: TppLabel UserName = 'Label28' Caption = 'Mahnung' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True mmHeight = 3704 mmLeft = 132557 mmTop = 5292 mmWidth = 12170 BandType = 3 GroupNo = 0 LayerName = Foreground1 end end object ppGroupFooterBand1: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object ppGroup4: TppGroup BreakName = 'ASDJahrgang_2' DataPipeline = daADOQueryDataView1.Kurs_Tabelle GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True StartOnOddPage = False UserName = 'Group4' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Kurs_Tabelle' NewFile = False object ppGroupHeaderBand4: TppGroupHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppGroupFooterBand4: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object ppGroup3: TppGroup BreakName = 'Klasse' DataPipeline = daADOQueryDataView1.Kurs_Tabelle GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True NewPage = True StartOnOddPage = False UserName = 'Group3' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Kurs_Tabelle' NewFile = False object ppGroupHeaderBand3: TppGroupHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppGroupFooterBand3: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object ppGroup6: TppGroup BreakName = 'ID' DataPipeline = daADOQueryDataView1.Kurs_Tabelle GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True NewPage = True StartOnOddPage = False UserName = 'Group6' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Kurs_Tabelle' NewFile = False object ppGroupHeaderBand6: TppGroupHeaderBand Background.Brush.Style = bsClear PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppGroupFooterBand6: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 8996 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' Weight = 0.750000000000000000 mmHeight = 265 mmLeft = 0 mmTop = 0 mmWidth = 187855 BandType = 5 GroupNo = 3 LayerName = Foreground1 end object ppLabel24: TppLabel UserName = 'Label14' Caption = 'Fehlstunden gesamt: ' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3704 mmLeft = 0 mmTop = 1588 mmWidth = 31221 BandType = 5 GroupNo = 3 LayerName = Foreground1 end object ppLabel25: TppLabel UserName = 'Label25' Caption = 'Davon unentschuldigt: ' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3704 mmLeft = 0 mmTop = 5290 mmWidth = 33073 BandType = 5 GroupNo = 3 LayerName = Foreground1 end object ppLabel26: TppLabel UserName = 'La_fehl_ges' AutoSize = False Caption = 'La_fehl_ges' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 32275 mmTop = 1588 mmWidth = 6085 BandType = 5 GroupNo = 3 LayerName = Foreground1 end object ppLabel27: TppLabel UserName = 'La_fehl_u' AutoSize = False Caption = 'La_fehl_u' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 32275 mmTop = 5290 mmWidth = 6085 BandType = 5 GroupNo = 3 LayerName = Foreground1 end end end object ppGroup2: TppGroup BreakName = 'Kurs_ID' DataPipeline = daADOQueryDataView1.Kurs_Tabelle GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False KeepTogether = True OutlineSettings.CreateNode = True StartOnOddPage = False UserName = 'Group2' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Kurs_Tabelle' NewFile = False object ppGroupHeaderBand2: TppGroupHeaderBand Background.Brush.Style = bsClear PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 3175 mmPrintPosition = 0 object ppSubReport7: TppSubReport UserName = 'SubReport1' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentWidth = False TraverseAllData = False DataPipelineName = 'TeilLeist_ges' mmHeight = 3175 mmLeft = 0 mmTop = 0 mmWidth = 35719 BandType = 3 GroupNo = 4 LayerName = Foreground1 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport7: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView8.TeilLeist_ges PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Kursliste_pro_S_mit_Endn_und_Teill_und_Fehlstd_para_Klasse_KurzB' + 'ez_ASDJgg.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 6350 PrinterSetup.mmMarginLeft = 12350 PrinterSetup.mmMarginRight = 4000 PrinterSetup.mmMarginTop = 6350 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 0 DataPipelineName = 'TeilLeist_ges' object ppDetailBand8: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppGroup5: TppGroup BreakName = 'ID' DataPipeline = daADOQueryDataView8.TeilLeist_ges GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True ReprintOnSubsequentPage = False StartOnOddPage = False UserName = 'Group5' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'TeilLeist_ges' NewFile = False object ppGroupHeaderBand5: TppGroupHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppGroupFooterBand5: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object raCodeModule8: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650611 44657461696C4265666F72655072696E740B50726F6772616D54797065070B74 7450726F63656475726506536F757263650CA501000070726F63656475726520 44657461696C4265666F72655072696E743B0D0A626567696E0D0A0D0A202069 66205465696C4C656973745F6765735B2742657A656963686E756E67275D203D 20274B6C2E3127207468656E206B313A3D20747275653B0D0A20206966205465 696C4C656973745F6765735B2742657A656963686E756E67275D203D20274B6C 2E3227207468656E206B323A3D20747275653B0D0A20206966205465696C4C65 6973745F6765735B2742657A656963686E756E67275D203D20274B6C2E676573 27207468656E206B6765733A3D20747275653B0D0A20200D0A20206966205465 696C4C656973745F6765735B2742657A656963686E756E67275D203D2027536F 2E3127207468656E2073313A3D20747275653B0D0A20206966205465696C4C65 6973745F6765735B2742657A656963686E756E67275D203D2027536F2E322720 7468656E2073323A3D20747275653B0D0A20206966205465696C4C656973745F 6765735B2742657A656963686E756E67275D203D2027536F2E67657327207468 656E20736765733A3D20747275653B0D0A20200D0A656E643B0D0A0D436F6D70 6F6E656E744E616D65060644657461696C094576656E744E616D65060B426566 6F72655072696E74074576656E7449440218084361726574506F7301022C020A 000000} end object ppDesignLayers8: TppDesignLayers object ppDesignLayer8: TppDesignLayer UserName = 'Foreground4' LayerType = ltBanded Index = 0 end end end end end object ppGroupFooterBand2: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_Kurs_Tabelle' Height = 675 Left = 512 NameColumnWidth = 148 SizeColumnWidth = 35 SortMode = 0 Top = 146 TypeColumnWidth = 52 Width = 365 AutoSearchTabOrder = 0 object Kurs_Tabelle: TppChildDBPipeline AutoCreateFields = False UserName = 'Kurs_Tabelle' object ppField1: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'Schueler' end object ppField2: TppField FieldAlias = 'ASDSchulgliederung' FieldName = 'ASDSchulgliederung' FieldLength = 3 IsDetail = True DisplayWidth = 3 Position = 1 TableName = 'SchuelerLernabschnittsdaten' end object ppField3: TppField FieldAlias = 'Vorname' FieldName = 'Vorname' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 2 TableName = 'Schueler' end object ppField4: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 3 TableName = 'Schueler' end object ppField5: TppField FieldAlias = 'LehrerKrz' FieldName = 'LehrerKrz' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 4 TableName = 'Kurse' end object ppField6: TppField FieldAlias = 'KurzBez' FieldName = 'KurzBez' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 5 TableName = 'Kurse' end object ppField7: TppField FieldAlias = 'Kurs_ID' FieldName = 'Kurs_ID' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 6 TableName = 'SchuelerLeistungsdaten' end object ppField8: TppField FieldAlias = 'Klasse' FieldName = 'Klasse' FieldLength = 15 IsDetail = True DisplayWidth = 15 Position = 7 TableName = 'Schueler' end object ppField9: TppField FieldAlias = 'ASDJahrgang' FieldName = 'ASDJahrgang' FieldLength = 2 DisplayWidth = 2 Position = 8 TableName = 'Kurse' end object ppField10: TppField FieldAlias = 'Jahrgaenge' FieldName = 'Jahrgaenge' FieldLength = 50 DisplayWidth = 50 Position = 9 TableName = 'Kurse' end object ppField11: TppField FieldAlias = 'Jahrgang' FieldName = 'Jahrgang' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 10 TableName = 'SchuelerLernabschnittsdaten' end object ppField12: TppField FieldAlias = 'ASDSchulform' FieldName = 'ASDSchulform' FieldLength = 3 IsDetail = True DisplayWidth = 3 Position = 11 TableName = 'Schueler' end object ppField13: TppField FieldAlias = 'SchuljahrAbschnitt' FieldName = 'SchuljahrAbschnitt' FieldLength = 0 IsDetail = True DataType = dtLongint DisplayWidth = 10 Position = 12 TableName = 'EigeneSchule' end object ppField14: TppField FieldAlias = 'Schuljahr' FieldName = 'Schuljahr' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 13 TableName = 'EigeneSchule' end object ppField15: TppField FieldAlias = 'Kuerzel' FieldName = 'Kuerzel' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 14 TableName = 'K_Lehrer' end object ppField16: TppField FieldAlias = 'Nachname' FieldName = 'Nachname' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 15 TableName = 'K_Lehrer' end object ppField17: TppField FieldAlias = 'Vorname_Lehrer' FieldName = 'Vorname_2' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 16 TableName = 'K_Lehrer' end object ppField18: TppField FieldAlias = 'ASDJahrgang (2)' FieldName = 'ASDJahrgang_2' FieldLength = 2 IsDetail = True DisplayWidth = 2 Position = 17 TableName = 'SchuelerLernabschnittsdaten' end object ppField19: TppField FieldAlias = 'Kursart' FieldName = 'Kursart' FieldLength = 5 IsDetail = True DisplayWidth = 5 Position = 18 TableName = 'SchuelerLeistungsdaten' end object ppField20: TppField FieldAlias = 'Ausweisnummer' FieldName = 'Ausweisnummer' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 19 TableName = 'Schueler' end object ppField21: TppField FieldAlias = 'Schueler_ID' FieldName = 'Schueler_ID' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 20 TableName = 'SchuelerLernabschnittsdaten' end object ppField22: TppField FieldAlias = 'ID (2)' FieldName = 'ID_2' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 21 TableName = 'K_Lehrer' end object ppField23: TppField FieldAlias = 'Fach_ID' FieldName = 'Fach_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 22 TableName = 'Kurse' end object ppField24: TppField FieldAlias = 'Zeugnisbez' FieldName = 'Zeugnisbez' FieldLength = 130 DisplayWidth = 130 Position = 23 TableName = 'Kurse' end object ppField25: TppField FieldAlias = 'FachLehrer' FieldName = 'FachLehrer' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 24 TableName = 'SchuelerLeistungsdaten' end object ppField26: TppField FieldAlias = 'SchulnrEigner' FieldName = 'SchulnrEigner' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 25 TableName = 'Kurse' end object ppField27: TppField FieldAlias = 'ID (3)' FieldName = 'ID_3' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 26 TableName = 'SchuelerLeistungsdaten' end object ppField28: TppField FieldAlias = 'NotenKrz' FieldName = 'NotenKrz' FieldLength = 2 IsDetail = True DisplayWidth = 2 Position = 27 TableName = 'SchuelerLeistungsdaten' end object ppField29: TppField FieldAlias = 'KursartAllg' FieldName = 'KursartAllg' FieldLength = 5 DisplayWidth = 5 Position = 28 TableName = 'Kurse' end object ppField30: TppField FieldAlias = 'uFehlstd' FieldName = 'uFehlstd' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 29 TableName = 'SchuelerLeistungsdaten' end object ppField31: TppField FieldAlias = 'Fehlstd' FieldName = 'Fehlstd' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 30 TableName = 'SchuelerLeistungsdaten' end object ppField32: TppField FieldAlias = 'FachKrz' FieldName = 'FachKrz' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 31 TableName = 'EigeneSchule_Faecher' end object ppField33: TppField FieldAlias = 'Warnung' FieldName = 'Warnung' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 32 TableName = 'SchuelerLeistungsdaten' end end object daSQL1: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'Kurs_Tabelle' IsCaseSensitive = True LinkColor = clMaroon LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Schueler.ID, ' ' SchuelerLernabschnittsdaten.ASDSchulgliederung, ' ' Schueler.Vorname, Schueler.Name, ' ' Kurse.LehrerKrz, Kurse.KurzBez, ' ' SchuelerLeistungsdaten.Kurs_ID, ' ' Schueler.Klasse, Kurse.ASDJahrgang, ' ' Kurse.Jahrgaenge, ' ' SchuelerLernabschnittsdaten.Jahrgang, ' ' Schueler.ASDSchulform, ' ' EigeneSchule.SchuljahrAbschnitt, ' ' EigeneSchule.Schuljahr, K_Lehrer.Kuerzel, ' ' K_Lehrer.Nachname, ' ' K_Lehrer.Vorname AS Vorname_2, ' ' SchuelerLernabschnittsdaten.ASDJahrgang AS ASDJahrgang_2,' + ' ' ' SchuelerLeistungsdaten.Kursart, ' ' Schueler.Ausweisnummer, ' ' SchuelerLernabschnittsdaten.Schueler_ID, ' ' K_Lehrer.ID AS ID_2, Kurse.Fach_ID, ' ' Kurse.Zeugnisbez, ' ' SchuelerLeistungsdaten.FachLehrer, ' ' Kurse.SchulnrEigner, ' ' SchuelerLeistungsdaten.ID AS ID_3, ' ' SchuelerLeistungsdaten.NotenKrz, ' ' Kurse.KursartAllg, ' ' SchuelerLeistungsdaten.uFehlstd, ' ' SchuelerLeistungsdaten.Fehlstd, ' ' EigeneSchule_Faecher.FachKrz, ' ' SchuelerLeistungsdaten.Warnung' 'FROM ((((((Kurse Kurse' ' INNER JOIN SchuelerLeistungsdaten SchuelerLeistungsdaten O' + 'N ' ' (SchuelerLeistungsdaten.Kurs_ID = Kurse.ID) )' ' INNER JOIN SchuelerLernabschnittsdaten SchuelerLernabschni' + 'ttsdaten ON ' ' (SchuelerLernabschnittsdaten.ID = SchuelerLeistungsdaten.Ab' + 'schnitt_ID) )' ' INNER JOIN Schueler Schueler ON ' ' (Schueler.ID = SchuelerLernabschnittsdaten.Schueler_ID)' ' AND (Schueler.AktSchuljahr = Kurse.Jahr)' ' AND (Schueler.AktAbschnitt = Kurse.Abschnitt) )' ' INNER JOIN EigeneSchule EigeneSchule ON ' ' (EigeneSchule.SchuljahrAbschnitt = SchuelerLernabschnittsda' + 'ten.Abschnitt)' ' AND (EigeneSchule.Schuljahr = SchuelerLernabschnittsdaten.' + 'Jahr) )' ' INNER JOIN K_Lehrer K_Lehrer ON ' ' (K_Lehrer.Kuerzel = SchuelerLeistungsdaten.FachLehrer) )' ' INNER JOIN EigeneSchule_Faecher EigeneSchule_Faecher ON ' ' (EigeneSchule_Faecher.ID = SchuelerLeistungsdaten.Fach_ID) ' + ')' 'WHERE ( Schueler.Status = 2 )' ' AND ( Schueler.Geloescht <> '#39'+'#39' )' 'ORDER BY SchuelerLernabschnittsdaten.ASDJahrgang, ' ' Schueler.Klasse, Schueler.Name, ' ' Schueler.Vorname, ' ' SchuelerLeistungsdaten.Kurs_ID, ' ' SchuelerLernabschnittsdaten.ASDSchulgliederung, ' ' Kurse.ASDJahrgang') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Value = '2' object TdaField Alias = 'Status' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Status' FieldLength = 0 FieldName = 'Status' SQLFieldName = 'Status' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object TdaNumericValue Value = 2.000000000000000000 end end object daCriteria2: TdaCriteria ChildType = 7 Level = 0 Operator = dacoNotEqual Value = '+' object TdaField Alias = 'Geloescht' DisplayWidth = 1 FieldAlias = 'Geloescht' FieldLength = 1 FieldName = 'Geloescht' SQLFieldName = 'Geloescht' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object daCriteria3: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'AuswahlKurs' object TdaField Alias = 'KurzBez' DisplayWidth = 20 FieldAlias = 'KurzBez' FieldLength = 20 FieldName = 'KurzBez' ShowAllValues = True SQLFieldName = 'KurzBez' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end end object daCriteria4: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'Auswahl_ASDJgg' object TdaField Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' ShowAllValues = True SQLFieldName = 'ASDJahrgang' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end object daCriteria5: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'Auswahl_Bildgg' object TdaField Alias = 'ASDSchulgliederung' DisplayWidth = 3 FieldAlias = 'ASDSchulgliederung' FieldLength = 3 FieldName = 'ASDSchulgliederung' ShowAllValues = True SQLFieldName = 'ASDSchulgliederung' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end object daCriteria6: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'Wahl_Klasse' object TdaField Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' ShowAllValues = True SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object daField1: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' IsDetail = True SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField2: TdaField Alias = 'ASDSchulgliederung' DisplayWidth = 3 FieldAlias = 'ASDSchulgliederung' FieldLength = 3 FieldName = 'ASDSchulgliederung' IsDetail = True SQLFieldName = 'ASDSchulgliederung' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField3: TdaField Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' IsDetail = True SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField4: TdaField Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' IsDetail = True SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField5: TdaField Alias = 'LehrerKrz' DisplayWidth = 10 FieldAlias = 'LehrerKrz' FieldLength = 10 FieldName = 'LehrerKrz' IsDetail = True SQLFieldName = 'LehrerKrz' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField6: TdaField Alias = 'KurzBez' DisplayWidth = 20 FieldAlias = 'KurzBez' FieldLength = 20 FieldName = 'KurzBez' IsDetail = True SQLFieldName = 'KurzBez' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField7: TdaField Alias = 'Kurs_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Kurs_ID' FieldLength = 0 FieldName = 'Kurs_ID' IsDetail = True SQLFieldName = 'Kurs_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField8: TdaField Alias = 'Klasse' DisplayWidth = 15 FieldAlias = 'Klasse' FieldLength = 15 FieldName = 'Klasse' IsDetail = True SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField9: TdaField Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' SQLFieldName = 'ASDJahrgang' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField10: TdaField Alias = 'Jahrgaenge' DisplayWidth = 50 FieldAlias = 'Jahrgaenge' FieldLength = 50 FieldName = 'Jahrgaenge' SQLFieldName = 'Jahrgaenge' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField11: TdaField Alias = 'Jahrgang' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahrgang' FieldLength = 0 FieldName = 'Jahrgang' IsDetail = True SQLFieldName = 'Jahrgang' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField12: TdaField Alias = 'ASDSchulform' DisplayWidth = 3 FieldAlias = 'ASDSchulform' FieldLength = 3 FieldName = 'ASDSchulform' IsDetail = True SQLFieldName = 'ASDSchulform' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField13: TdaField Alias = 'SchuljahrAbschnitt' DataType = dtLongint DisplayWidth = 10 FieldAlias = 'SchuljahrAbschnitt' FieldLength = 0 FieldName = 'SchuljahrAbschnitt' IsDetail = True SQLFieldName = 'SchuljahrAbschnitt' TableAlias = 'EigeneSchule' TableName = 'EigeneSchule' TableSQLAlias = 'EigeneSchule' end object daField14: TdaField Alias = 'Schuljahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schuljahr' FieldLength = 0 FieldName = 'Schuljahr' IsDetail = True SQLFieldName = 'Schuljahr' TableAlias = 'EigeneSchule' TableName = 'EigeneSchule' TableSQLAlias = 'EigeneSchule' end object daField15: TdaField Alias = 'Kuerzel' DisplayWidth = 10 FieldAlias = 'Kuerzel' FieldLength = 10 FieldName = 'Kuerzel' IsDetail = True SQLFieldName = 'Kuerzel' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField16: TdaField Alias = 'Nachname' DisplayWidth = 30 FieldAlias = 'Nachname' FieldLength = 30 FieldName = 'Nachname' IsDetail = True SQLFieldName = 'Nachname' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField17: TdaField Alias = 'Vorname_Lehrer' DisplayWidth = 20 FieldAlias = 'Vorname' FieldLength = 20 FieldName = 'Vorname' IsDetail = True SQLFieldName = 'Vorname_2' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField18: TdaField Alias = 'ASDJahrgang (2)' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' IsDetail = True SQLFieldName = 'ASDJahrgang_2' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField19: TdaField Alias = 'Kursart' DisplayWidth = 5 FieldAlias = 'Kursart' FieldLength = 5 FieldName = 'Kursart' IsDetail = True SQLFieldName = 'Kursart' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField20: TdaField Alias = 'Ausweisnummer' DisplayWidth = 30 FieldAlias = 'Ausweisnummer' FieldLength = 30 FieldName = 'Ausweisnummer' IsDetail = True SQLFieldName = 'Ausweisnummer' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField21: TdaField Alias = 'Schueler_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schueler_ID' FieldLength = 0 FieldName = 'Schueler_ID' IsDetail = True SQLFieldName = 'Schueler_ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField22: TdaField Alias = 'ID (2)' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' IsDetail = True SQLFieldName = 'ID_2' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField23: TdaField Alias = 'Fach_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Fach_ID' FieldLength = 0 FieldName = 'Fach_ID' SQLFieldName = 'Fach_ID' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField24: TdaField Alias = 'Zeugnisbez' DisplayWidth = 130 FieldAlias = 'Zeugnisbez' FieldLength = 130 FieldName = 'Zeugnisbez' SQLFieldName = 'Zeugnisbez' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField25: TdaField Alias = 'FachLehrer' DisplayWidth = 10 FieldAlias = 'FachLehrer' FieldLength = 10 FieldName = 'FachLehrer' IsDetail = True SQLFieldName = 'FachLehrer' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField26: TdaField Alias = 'SchulnrEigner' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'SchulnrEigner' FieldLength = 0 FieldName = 'SchulnrEigner' SQLFieldName = 'SchulnrEigner' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField27: TdaField Alias = 'ID (3)' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' IsDetail = True SQLFieldName = 'ID_3' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField28: TdaField Alias = 'NotenKrz' DisplayWidth = 2 FieldAlias = 'NotenKrz' FieldLength = 2 FieldName = 'NotenKrz' IsDetail = True SQLFieldName = 'NotenKrz' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField29: TdaField Alias = 'KursartAllg' DisplayWidth = 5 FieldAlias = 'KursartAllg' FieldLength = 5 FieldName = 'KursartAllg' SQLFieldName = 'KursartAllg' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField30: TdaField Alias = 'uFehlstd' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'uFehlstd' FieldLength = 0 FieldName = 'uFehlstd' IsDetail = True SQLFieldName = 'uFehlstd' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField31: TdaField Alias = 'Fehlstd' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Fehlstd' FieldLength = 0 FieldName = 'Fehlstd' IsDetail = True SQLFieldName = 'Fehlstd' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField32: TdaField Alias = 'FachKrz' DisplayWidth = 20 FieldAlias = 'FachKrz' FieldLength = 20 FieldName = 'FachKrz' IsDetail = True SQLFieldName = 'FachKrz' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField33: TdaField Alias = 'Warnung' DisplayWidth = 1 FieldAlias = 'Warnung' FieldLength = 1 FieldName = 'Warnung' IsDetail = True SQLFieldName = 'Warnung' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField34: TdaField ChildType = 2 Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' SQLFieldName = 'ASDJahrgang' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField35: TdaField ChildType = 2 Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField36: TdaField ChildType = 2 Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField37: TdaField ChildType = 2 Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField38: TdaField ChildType = 2 Alias = 'Kurs_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Kurs_ID' FieldLength = 0 FieldName = 'Kurs_ID' SQLFieldName = 'Kurs_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField39: TdaField ChildType = 2 Alias = 'ASDSchulgliederung' DisplayWidth = 3 FieldAlias = 'ASDSchulgliederung' FieldLength = 3 FieldName = 'ASDSchulgliederung' SQLFieldName = 'ASDSchulgliederung' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField40: TdaField ChildType = 2 Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' SQLFieldName = 'ASDJahrgang' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daTable1: TdaTable ChildType = 5 Alias = 'Kurse' SQLAlias = 'Kurse' TableAlias = 'Kurse' TableName = 'Kurse' object daTableJoin1: TdaTableJoin ChildType = 6 object daField42: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField41: TdaField ChildType = 4 Alias = 'Kurs_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Kurs_ID' FieldLength = 0 FieldName = 'Kurs_ID' SQLFieldName = 'Kurs_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end end object daTable2: TdaTable ChildType = 5 Alias = 'SchuelerLeistungsdaten' SQLAlias = 'SchuelerLeistungsdaten' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' object daTableJoin2: TdaTableJoin ChildType = 6 object daField44: TdaField ChildType = 3 Alias = 'Kurs_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Kurs_ID' FieldLength = 0 FieldName = 'Kurs_ID' SQLFieldName = 'Kurs_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField43: TdaField ChildType = 4 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end end end object daTable3: TdaTable ChildType = 5 Alias = 'SchuelerLernabschnittsdaten' SQLAlias = 'SchuelerLernabschnittsdaten' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' object daTableJoin3: TdaTableJoin ChildType = 6 object daField46: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField45: TdaField ChildType = 4 Alias = 'Abschnitt_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt_ID' FieldLength = 0 FieldName = 'Abschnitt_ID' SQLFieldName = 'Abschnitt_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end end object daTable4: TdaTable ChildType = 5 Alias = 'Schueler' SQLAlias = 'Schueler' TableAlias = 'Schueler' TableName = 'Schueler' object daTableJoin4: TdaTableJoin ChildType = 6 object daField48: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField47: TdaField ChildType = 4 Alias = 'Schueler_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schueler_ID' FieldLength = 0 FieldName = 'Schueler_ID' SQLFieldName = 'Schueler_ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end object daTableJoin5: TdaTableJoin ChildType = 6 object daField50: TdaField ChildType = 3 Alias = 'AktSchuljahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'AktSchuljahr' FieldLength = 0 FieldName = 'AktSchuljahr' SQLFieldName = 'AktSchuljahr' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField49: TdaField ChildType = 4 Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' SQLFieldName = 'Jahr' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end end object daTableJoin6: TdaTableJoin ChildType = 6 object daField52: TdaField ChildType = 3 Alias = 'AktAbschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'AktAbschnitt' FieldLength = 0 FieldName = 'AktAbschnitt' SQLFieldName = 'AktAbschnitt' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField51: TdaField ChildType = 4 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' SQLFieldName = 'Abschnitt' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end end end object daTable5: TdaTable ChildType = 5 Alias = 'EigeneSchule' SQLAlias = 'EigeneSchule' TableAlias = 'EigeneSchule' TableName = 'EigeneSchule' object daTableJoin7: TdaTableJoin ChildType = 6 object daField54: TdaField ChildType = 3 Alias = 'SchuljahrAbschnitt' DataType = dtLongint DisplayWidth = 10 FieldAlias = 'SchuljahrAbschnitt' FieldLength = 0 FieldName = 'SchuljahrAbschnitt' SQLFieldName = 'SchuljahrAbschnitt' TableAlias = 'EigeneSchule' TableName = 'EigeneSchule' TableSQLAlias = 'EigeneSchule' end object daField53: TdaField ChildType = 4 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end object daTableJoin8: TdaTableJoin ChildType = 6 object daField56: TdaField ChildType = 3 Alias = 'Schuljahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schuljahr' FieldLength = 0 FieldName = 'Schuljahr' SQLFieldName = 'Schuljahr' TableAlias = 'EigeneSchule' TableName = 'EigeneSchule' TableSQLAlias = 'EigeneSchule' end object daField55: TdaField ChildType = 4 Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end end object daTable6: TdaTable ChildType = 5 Alias = 'K_Lehrer' SQLAlias = 'K_Lehrer' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' object daTableJoin9: TdaTableJoin ChildType = 6 object daField58: TdaField ChildType = 3 Alias = 'Kuerzel' DisplayWidth = 10 FieldAlias = 'Kuerzel' FieldLength = 10 FieldName = 'Kuerzel' SQLFieldName = 'Kuerzel' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField57: TdaField ChildType = 4 Alias = 'FachLehrer' DisplayWidth = 10 FieldAlias = 'FachLehrer' FieldLength = 10 FieldName = 'FachLehrer' SQLFieldName = 'FachLehrer' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end end object daTable7: TdaTable ChildType = 5 Alias = 'EigeneSchule_Faecher' SQLAlias = 'EigeneSchule_Faecher' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' object daTableJoin10: TdaTableJoin ChildType = 6 object daField60: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField59: TdaField ChildType = 4 Alias = 'Fach_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Fach_ID' FieldLength = 0 FieldName = 'Fach_ID' SQLFieldName = 'Fach_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end end end end object daADOQueryDataView3: TdaADOQueryDataView UserName = 'Query_Kl_1' Height = 290 Left = 39 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 16 TypeColumnWidth = 52 Width = 282 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_Kurs_Tabelle' object Kl_1: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'Kl_1' MasterDataPipelineName = 'Kurs_Tabelle' object ppField1: TppField FieldAlias = 'Art_ID' FieldName = 'Art_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'SchuelerEinzelleistungen' end object ppField2: TppField FieldAlias = 'Bemerkung' FieldName = 'Bemerkung' FieldLength = 100 DisplayWidth = 100 Position = 1 TableName = 'SchuelerEinzelleistungen' end object ppField3: TppField FieldAlias = 'Datum' FieldName = 'Datum' FieldLength = 0 DataType = dtDateTime DisplayWidth = 18 Position = 2 TableName = 'SchuelerEinzelleistungen' end object ppField4: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtLongint DisplayWidth = 10 Position = 3 TableName = 'SchuelerEinzelleistungen' end object ppField5: TppField FieldAlias = 'Lehrer_ID' FieldName = 'Lehrer_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 4 TableName = 'SchuelerEinzelleistungen' end object ppField6: TppField FieldAlias = 'Leistung_ID' FieldName = 'Leistung_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 5 TableName = 'SchuelerEinzelleistungen' end object ppField7: TppField FieldAlias = 'NotenKrz' FieldName = 'NotenKrz' FieldLength = 2 DisplayWidth = 2 Position = 6 TableName = 'SchuelerEinzelleistungen' end object ppField8: TppField FieldAlias = 'SchulnrEigner' FieldName = 'SchulnrEigner' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 7 TableName = 'SchuelerEinzelleistungen' end object ppField9: TppField FieldAlias = 'Bezeichnung' FieldName = 'Bezeichnung' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 8 TableName = 'K_Einzelleistungen' end object ppField10: TppField FieldAlias = 'Sortierung' FieldName = 'Sortierung' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 9 TableName = 'K_Einzelleistungen' end object TppMasterFieldLink MasterFieldName = 'ASDJahrgang_2' GuidCollationType = gcMSAccess DetailFieldName = 'ASDJahrgang' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Klasse' GuidCollationType = gcMSAccess DetailFieldName = 'Klasse' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Name' GuidCollationType = gcMSAccess DetailFieldName = 'Name' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Vorname' GuidCollationType = gcMSAccess DetailFieldName = 'Vorname' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Kurs_ID' GuidCollationType = gcMSAccess DetailFieldName = 'Kurs_ID' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ASDSchulgliederung' GuidCollationType = gcMSAccess DetailFieldName = 'ASDSchulgliederung' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ASDJahrgang' GuidCollationType = gcMSAccess DetailFieldName = 'ASDJahrgang_2' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ID_3' GuidCollationType = gcMSAccess DetailFieldName = 'Leistung_ID' DetailSortOrder = soAscending IsCaseSensitive = True end end object daSQL3: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'Kl_1' IsCaseSensitive = True LinkColor = clGreen LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT SchuelerEinzelleistungen.Art_ID, ' ' SchuelerEinzelleistungen.Bemerkung, ' ' SchuelerEinzelleistungen.Datum, ' ' SchuelerEinzelleistungen.ID, ' ' SchuelerEinzelleistungen.Lehrer_ID, ' ' SchuelerEinzelleistungen.Leistung_ID, ' ' SchuelerEinzelleistungen.NotenKrz, ' ' SchuelerEinzelleistungen.SchulnrEigner, ' ' K_Einzelleistungen.Bezeichnung, ' ' K_Einzelleistungen.Sortierung' 'FROM (' ' SchuelerEinzelleistungen SchuelerEinzelleistungen' ' INNER JOIN K_Einzelleistungen K_Einzelleistungen ON ' ' (K_Einzelleistungen.ID = SchuelerEinzelleistungen.Art_ID) )' 'WHERE ( K_Einzelleistungen.Bezeichnung = '#39'Kl.1'#39' )' 'ORDER BY K_Einzelleistungen.Sortierung') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Value = 'Kl.1' object TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' SQLFieldName = 'Bezeichnung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end end object daField1: TdaField Alias = 'Art_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Art_ID' FieldLength = 0 FieldName = 'Art_ID' SQLFieldName = 'Art_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField2: TdaField Alias = 'Bemerkung' DisplayWidth = 100 FieldAlias = 'Bemerkung' FieldLength = 100 FieldName = 'Bemerkung' SQLFieldName = 'Bemerkung' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField3: TdaField Alias = 'Datum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Datum' FieldLength = 0 FieldName = 'Datum' SQLFieldName = 'Datum' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField4: TdaField Alias = 'ID' DataType = dtLongint DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField5: TdaField Alias = 'Lehrer_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Lehrer_ID' FieldLength = 0 FieldName = 'Lehrer_ID' SQLFieldName = 'Lehrer_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField6: TdaField Alias = 'Leistung_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Leistung_ID' FieldLength = 0 FieldName = 'Leistung_ID' SQLFieldName = 'Leistung_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField7: TdaField Alias = 'NotenKrz' DisplayWidth = 2 FieldAlias = 'NotenKrz' FieldLength = 2 FieldName = 'NotenKrz' SQLFieldName = 'NotenKrz' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField8: TdaField Alias = 'SchulnrEigner' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'SchulnrEigner' FieldLength = 0 FieldName = 'SchulnrEigner' SQLFieldName = 'SchulnrEigner' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField9: TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' IsDetail = True SQLFieldName = 'Bezeichnung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField10: TdaField Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' IsDetail = True SQLFieldName = 'Sortierung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField11: TdaField ChildType = 2 Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' SQLFieldName = 'Sortierung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daTable1: TdaTable ChildType = 5 Alias = 'SchuelerEinzelleistungen' JoinType = dajtNone SQLAlias = 'SchuelerEinzelleistungen' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' end object daTable2: TdaTable ChildType = 5 Alias = 'K_Einzelleistungen' SQLAlias = 'K_Einzelleistungen' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' object daTableJoin1: TdaTableJoin ChildType = 6 object daField13: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField12: TdaField ChildType = 4 Alias = 'Art_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Art_ID' FieldLength = 0 FieldName = 'Art_ID' SQLFieldName = 'Art_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end end end object TdaSQLLink ChildType = 9 object daField14: TdaField ChildType = 10 Alias = 'ID (3)' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' IsDetail = True SQLFieldName = 'ID_3' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField15: TdaField ChildType = 11 Alias = 'Leistung_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Leistung_ID' FieldLength = 0 FieldName = 'Leistung_ID' SQLFieldName = 'Leistung_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end end end end object daADOQueryDataView2: TdaADOQueryDataView UserName = 'Query_Kl_2' Height = 297 Left = 37 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 318 TypeColumnWidth = 52 Width = 286 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_Kurs_Tabelle' object Kl_2: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'Kl_2' MasterDataPipelineName = 'Kurs_Tabelle' object ppField1: TppField FieldAlias = 'Art_ID' FieldName = 'Art_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'SchuelerEinzelleistungen' end object ppField2: TppField FieldAlias = 'Bemerkung' FieldName = 'Bemerkung' FieldLength = 100 DisplayWidth = 100 Position = 1 TableName = 'SchuelerEinzelleistungen' end object ppField3: TppField FieldAlias = 'Datum' FieldName = 'Datum' FieldLength = 0 DataType = dtDateTime DisplayWidth = 18 Position = 2 TableName = 'SchuelerEinzelleistungen' end object ppField4: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtLongint DisplayWidth = 10 Position = 3 TableName = 'SchuelerEinzelleistungen' end object ppField5: TppField FieldAlias = 'Lehrer_ID' FieldName = 'Lehrer_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 4 TableName = 'SchuelerEinzelleistungen' end object ppField6: TppField FieldAlias = 'Leistung_ID' FieldName = 'Leistung_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 5 TableName = 'SchuelerEinzelleistungen' end object ppField7: TppField FieldAlias = 'NotenKrz' FieldName = 'NotenKrz' FieldLength = 2 DisplayWidth = 2 Position = 6 TableName = 'SchuelerEinzelleistungen' end object ppField8: TppField FieldAlias = 'SchulnrEigner' FieldName = 'SchulnrEigner' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 7 TableName = 'SchuelerEinzelleistungen' end object ppField9: TppField FieldAlias = 'Bezeichnung' FieldName = 'Bezeichnung' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 8 TableName = 'K_Einzelleistungen' end object ppField10: TppField FieldAlias = 'Sortierung' FieldName = 'Sortierung' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 9 TableName = 'K_Einzelleistungen' end object TppMasterFieldLink MasterFieldName = 'ASDJahrgang_2' GuidCollationType = gcMSAccess DetailFieldName = 'ASDJahrgang' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Klasse' GuidCollationType = gcMSAccess DetailFieldName = 'Klasse' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Name' GuidCollationType = gcMSAccess DetailFieldName = 'Name' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Vorname' GuidCollationType = gcMSAccess DetailFieldName = 'Vorname' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Kurs_ID' GuidCollationType = gcMSAccess DetailFieldName = 'Kurs_ID' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ASDSchulgliederung' GuidCollationType = gcMSAccess DetailFieldName = 'ASDSchulgliederung' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ASDJahrgang' GuidCollationType = gcMSAccess DetailFieldName = 'ASDJahrgang_2' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ID_3' GuidCollationType = gcMSAccess DetailFieldName = 'Leistung_ID' DetailSortOrder = soAscending IsCaseSensitive = True end end object daSQL3: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'Kl_2' IsCaseSensitive = True LinkColor = clGreen LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT SchuelerEinzelleistungen.Art_ID, ' ' SchuelerEinzelleistungen.Bemerkung, ' ' SchuelerEinzelleistungen.Datum, ' ' SchuelerEinzelleistungen.ID, ' ' SchuelerEinzelleistungen.Lehrer_ID, ' ' SchuelerEinzelleistungen.Leistung_ID, ' ' SchuelerEinzelleistungen.NotenKrz, ' ' SchuelerEinzelleistungen.SchulnrEigner, ' ' K_Einzelleistungen.Bezeichnung, ' ' K_Einzelleistungen.Sortierung' 'FROM (' ' SchuelerEinzelleistungen SchuelerEinzelleistungen' ' INNER JOIN K_Einzelleistungen K_Einzelleistungen ON ' ' (K_Einzelleistungen.ID = SchuelerEinzelleistungen.Art_ID) )' 'WHERE ( K_Einzelleistungen.Bezeichnung = '#39'Kl.2'#39' )' 'ORDER BY K_Einzelleistungen.Sortierung') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Value = 'Kl.2' object TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' SQLFieldName = 'Bezeichnung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end end object daField1: TdaField Alias = 'Art_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Art_ID' FieldLength = 0 FieldName = 'Art_ID' SQLFieldName = 'Art_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField2: TdaField Alias = 'Bemerkung' DisplayWidth = 100 FieldAlias = 'Bemerkung' FieldLength = 100 FieldName = 'Bemerkung' SQLFieldName = 'Bemerkung' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField3: TdaField Alias = 'Datum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Datum' FieldLength = 0 FieldName = 'Datum' SQLFieldName = 'Datum' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField4: TdaField Alias = 'ID' DataType = dtLongint DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField5: TdaField Alias = 'Lehrer_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Lehrer_ID' FieldLength = 0 FieldName = 'Lehrer_ID' SQLFieldName = 'Lehrer_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField6: TdaField Alias = 'Leistung_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Leistung_ID' FieldLength = 0 FieldName = 'Leistung_ID' SQLFieldName = 'Leistung_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField7: TdaField Alias = 'NotenKrz' DisplayWidth = 2 FieldAlias = 'NotenKrz' FieldLength = 2 FieldName = 'NotenKrz' SQLFieldName = 'NotenKrz' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField8: TdaField Alias = 'SchulnrEigner' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'SchulnrEigner' FieldLength = 0 FieldName = 'SchulnrEigner' SQLFieldName = 'SchulnrEigner' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField9: TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' IsDetail = True SQLFieldName = 'Bezeichnung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField10: TdaField Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' IsDetail = True SQLFieldName = 'Sortierung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField11: TdaField ChildType = 2 Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' SQLFieldName = 'Sortierung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daTable1: TdaTable ChildType = 5 Alias = 'SchuelerEinzelleistungen' JoinType = dajtNone SQLAlias = 'SchuelerEinzelleistungen' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' end object daTable2: TdaTable ChildType = 5 Alias = 'K_Einzelleistungen' SQLAlias = 'K_Einzelleistungen' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' object daTableJoin1: TdaTableJoin ChildType = 6 object daField13: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField12: TdaField ChildType = 4 Alias = 'Art_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Art_ID' FieldLength = 0 FieldName = 'Art_ID' SQLFieldName = 'Art_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end end end object TdaSQLLink ChildType = 9 object daField14: TdaField ChildType = 10 Alias = 'ID (3)' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' IsDetail = True SQLFieldName = 'ID_3' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField15: TdaField ChildType = 11 Alias = 'Leistung_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Leistung_ID' FieldLength = 0 FieldName = 'Leistung_ID' SQLFieldName = 'Leistung_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end end end end object daADOQueryDataView4: TdaADOQueryDataView UserName = 'Query_So_ges' Height = 284 Left = 1332 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 623 TypeColumnWidth = 52 Width = 273 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_Kurs_Tabelle' object So_ges: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'So_ges' MasterDataPipelineName = 'Kurs_Tabelle' object ppField1: TppField FieldAlias = 'Art_ID' FieldName = 'Art_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'SchuelerEinzelleistungen' end object ppField2: TppField FieldAlias = 'Bemerkung' FieldName = 'Bemerkung' FieldLength = 100 DisplayWidth = 100 Position = 1 TableName = 'SchuelerEinzelleistungen' end object ppField3: TppField FieldAlias = 'Datum' FieldName = 'Datum' FieldLength = 0 DataType = dtDateTime DisplayWidth = 18 Position = 2 TableName = 'SchuelerEinzelleistungen' end object ppField4: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtLongint DisplayWidth = 10 Position = 3 TableName = 'SchuelerEinzelleistungen' end object ppField5: TppField FieldAlias = 'Lehrer_ID' FieldName = 'Lehrer_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 4 TableName = 'SchuelerEinzelleistungen' end object ppField6: TppField FieldAlias = 'Leistung_ID' FieldName = 'Leistung_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 5 TableName = 'SchuelerEinzelleistungen' end object ppField7: TppField FieldAlias = 'NotenKrz' FieldName = 'NotenKrz' FieldLength = 2 DisplayWidth = 2 Position = 6 TableName = 'SchuelerEinzelleistungen' end object ppField8: TppField FieldAlias = 'SchulnrEigner' FieldName = 'SchulnrEigner' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 7 TableName = 'SchuelerEinzelleistungen' end object ppField9: TppField FieldAlias = 'Bezeichnung' FieldName = 'Bezeichnung' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 8 TableName = 'K_Einzelleistungen' end object ppField10: TppField FieldAlias = 'Sortierung' FieldName = 'Sortierung' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 9 TableName = 'K_Einzelleistungen' end object TppMasterFieldLink MasterFieldName = 'ASDJahrgang_2' GuidCollationType = gcMSAccess DetailFieldName = 'ASDJahrgang' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Klasse' GuidCollationType = gcMSAccess DetailFieldName = 'Klasse' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Name' GuidCollationType = gcMSAccess DetailFieldName = 'Name' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Vorname' GuidCollationType = gcMSAccess DetailFieldName = 'Vorname' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Kurs_ID' GuidCollationType = gcMSAccess DetailFieldName = 'Kurs_ID' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ASDSchulgliederung' GuidCollationType = gcMSAccess DetailFieldName = 'ASDSchulgliederung' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ASDJahrgang' GuidCollationType = gcMSAccess DetailFieldName = 'ASDJahrgang_2' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ID_3' GuidCollationType = gcMSAccess DetailFieldName = 'Leistung_ID' DetailSortOrder = soAscending IsCaseSensitive = True end end object daSQL3: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'So_ges' IsCaseSensitive = True LinkColor = clGreen LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT SchuelerEinzelleistungen.Art_ID, ' ' SchuelerEinzelleistungen.Bemerkung, ' ' SchuelerEinzelleistungen.Datum, ' ' SchuelerEinzelleistungen.ID, ' ' SchuelerEinzelleistungen.Lehrer_ID, ' ' SchuelerEinzelleistungen.Leistung_ID, ' ' SchuelerEinzelleistungen.NotenKrz, ' ' SchuelerEinzelleistungen.SchulnrEigner, ' ' K_Einzelleistungen.Bezeichnung, ' ' K_Einzelleistungen.Sortierung' 'FROM (' ' SchuelerEinzelleistungen SchuelerEinzelleistungen' ' INNER JOIN K_Einzelleistungen K_Einzelleistungen ON ' ' (K_Einzelleistungen.ID = SchuelerEinzelleistungen.Art_ID) )' 'WHERE ' ' ( K_Einzelleistungen.Bezeichnung = '#39'So.ges'#39' )' 'ORDER BY K_Einzelleistungen.Sortierung') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Value = 'So.ges' object TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' SQLFieldName = 'Bezeichnung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end end object daField1: TdaField Alias = 'Art_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Art_ID' FieldLength = 0 FieldName = 'Art_ID' SQLFieldName = 'Art_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField2: TdaField Alias = 'Bemerkung' DisplayWidth = 100 FieldAlias = 'Bemerkung' FieldLength = 100 FieldName = 'Bemerkung' SQLFieldName = 'Bemerkung' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField3: TdaField Alias = 'Datum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Datum' FieldLength = 0 FieldName = 'Datum' SQLFieldName = 'Datum' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField4: TdaField Alias = 'ID' DataType = dtLongint DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField5: TdaField Alias = 'Lehrer_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Lehrer_ID' FieldLength = 0 FieldName = 'Lehrer_ID' SQLFieldName = 'Lehrer_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField6: TdaField Alias = 'Leistung_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Leistung_ID' FieldLength = 0 FieldName = 'Leistung_ID' SQLFieldName = 'Leistung_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField7: TdaField Alias = 'NotenKrz' DisplayWidth = 2 FieldAlias = 'NotenKrz' FieldLength = 2 FieldName = 'NotenKrz' SQLFieldName = 'NotenKrz' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField8: TdaField Alias = 'SchulnrEigner' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'SchulnrEigner' FieldLength = 0 FieldName = 'SchulnrEigner' SQLFieldName = 'SchulnrEigner' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField9: TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' IsDetail = True SQLFieldName = 'Bezeichnung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField10: TdaField Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' IsDetail = True SQLFieldName = 'Sortierung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField11: TdaField ChildType = 2 Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' SQLFieldName = 'Sortierung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daTable1: TdaTable ChildType = 5 Alias = 'SchuelerEinzelleistungen' JoinType = dajtNone SQLAlias = 'SchuelerEinzelleistungen' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' end object daTable2: TdaTable ChildType = 5 Alias = 'K_Einzelleistungen' SQLAlias = 'K_Einzelleistungen' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' object daTableJoin1: TdaTableJoin ChildType = 6 object daField13: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField12: TdaField ChildType = 4 Alias = 'Art_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Art_ID' FieldLength = 0 FieldName = 'Art_ID' SQLFieldName = 'Art_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end end end object TdaSQLLink ChildType = 9 object daField14: TdaField ChildType = 10 Alias = 'ID (3)' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' IsDetail = True SQLFieldName = 'ID_3' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField15: TdaField ChildType = 11 Alias = 'Leistung_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Leistung_ID' FieldLength = 0 FieldName = 'Leistung_ID' SQLFieldName = 'Leistung_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end end end end object daADOQueryDataView5: TdaADOQueryDataView UserName = 'Query_So_1' Height = 284 Left = 1322 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 41 TypeColumnWidth = 52 Width = 278 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_Kurs_Tabelle' object So_1: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'So_1' MasterDataPipelineName = 'Kurs_Tabelle' object ppField1: TppField FieldAlias = 'Art_ID' FieldName = 'Art_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'SchuelerEinzelleistungen' end object ppField2: TppField FieldAlias = 'Bemerkung' FieldName = 'Bemerkung' FieldLength = 100 DisplayWidth = 100 Position = 1 TableName = 'SchuelerEinzelleistungen' end object ppField3: TppField FieldAlias = 'Datum' FieldName = 'Datum' FieldLength = 0 DataType = dtDateTime DisplayWidth = 18 Position = 2 TableName = 'SchuelerEinzelleistungen' end object ppField4: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtLongint DisplayWidth = 10 Position = 3 TableName = 'SchuelerEinzelleistungen' end object ppField5: TppField FieldAlias = 'Lehrer_ID' FieldName = 'Lehrer_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 4 TableName = 'SchuelerEinzelleistungen' end object ppField6: TppField FieldAlias = 'Leistung_ID' FieldName = 'Leistung_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 5 TableName = 'SchuelerEinzelleistungen' end object ppField7: TppField FieldAlias = 'NotenKrz' FieldName = 'NotenKrz' FieldLength = 2 DisplayWidth = 2 Position = 6 TableName = 'SchuelerEinzelleistungen' end object ppField8: TppField FieldAlias = 'SchulnrEigner' FieldName = 'SchulnrEigner' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 7 TableName = 'SchuelerEinzelleistungen' end object ppField9: TppField FieldAlias = 'Bezeichnung' FieldName = 'Bezeichnung' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 8 TableName = 'K_Einzelleistungen' end object ppField10: TppField FieldAlias = 'Sortierung' FieldName = 'Sortierung' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 9 TableName = 'K_Einzelleistungen' end object TppMasterFieldLink MasterFieldName = 'ASDJahrgang_2' GuidCollationType = gcMSAccess DetailFieldName = 'ASDJahrgang' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Klasse' GuidCollationType = gcMSAccess DetailFieldName = 'Klasse' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Name' GuidCollationType = gcMSAccess DetailFieldName = 'Name' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Vorname' GuidCollationType = gcMSAccess DetailFieldName = 'Vorname' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Kurs_ID' GuidCollationType = gcMSAccess DetailFieldName = 'Kurs_ID' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ASDSchulgliederung' GuidCollationType = gcMSAccess DetailFieldName = 'ASDSchulgliederung' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ASDJahrgang' GuidCollationType = gcMSAccess DetailFieldName = 'ASDJahrgang_2' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ID_3' GuidCollationType = gcMSAccess DetailFieldName = 'Leistung_ID' DetailSortOrder = soAscending IsCaseSensitive = True end end object daSQL3: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'So_1' IsCaseSensitive = True LinkColor = clGreen LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT SchuelerEinzelleistungen.Art_ID, ' ' SchuelerEinzelleistungen.Bemerkung, ' ' SchuelerEinzelleistungen.Datum, ' ' SchuelerEinzelleistungen.ID, ' ' SchuelerEinzelleistungen.Lehrer_ID, ' ' SchuelerEinzelleistungen.Leistung_ID, ' ' SchuelerEinzelleistungen.NotenKrz, ' ' SchuelerEinzelleistungen.SchulnrEigner, ' ' K_Einzelleistungen.Bezeichnung, ' ' K_Einzelleistungen.Sortierung' 'FROM (' ' SchuelerEinzelleistungen SchuelerEinzelleistungen' ' INNER JOIN K_Einzelleistungen K_Einzelleistungen ON ' ' (K_Einzelleistungen.ID = SchuelerEinzelleistungen.Art_ID) )' 'WHERE ( K_Einzelleistungen.Bezeichnung = '#39'So.1'#39' )' 'ORDER BY K_Einzelleistungen.Sortierung') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Value = 'So.1' object TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' SQLFieldName = 'Bezeichnung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end end object daField1: TdaField Alias = 'Art_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Art_ID' FieldLength = 0 FieldName = 'Art_ID' SQLFieldName = 'Art_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField2: TdaField Alias = 'Bemerkung' DisplayWidth = 100 FieldAlias = 'Bemerkung' FieldLength = 100 FieldName = 'Bemerkung' SQLFieldName = 'Bemerkung' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField3: TdaField Alias = 'Datum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Datum' FieldLength = 0 FieldName = 'Datum' SQLFieldName = 'Datum' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField4: TdaField Alias = 'ID' DataType = dtLongint DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField5: TdaField Alias = 'Lehrer_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Lehrer_ID' FieldLength = 0 FieldName = 'Lehrer_ID' SQLFieldName = 'Lehrer_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField6: TdaField Alias = 'Leistung_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Leistung_ID' FieldLength = 0 FieldName = 'Leistung_ID' SQLFieldName = 'Leistung_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField7: TdaField Alias = 'NotenKrz' DisplayWidth = 2 FieldAlias = 'NotenKrz' FieldLength = 2 FieldName = 'NotenKrz' SQLFieldName = 'NotenKrz' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField8: TdaField Alias = 'SchulnrEigner' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'SchulnrEigner' FieldLength = 0 FieldName = 'SchulnrEigner' SQLFieldName = 'SchulnrEigner' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField9: TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' IsDetail = True SQLFieldName = 'Bezeichnung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField10: TdaField Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' IsDetail = True SQLFieldName = 'Sortierung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField11: TdaField ChildType = 2 Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' SQLFieldName = 'Sortierung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daTable1: TdaTable ChildType = 5 Alias = 'SchuelerEinzelleistungen' JoinType = dajtNone SQLAlias = 'SchuelerEinzelleistungen' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' end object daTable2: TdaTable ChildType = 5 Alias = 'K_Einzelleistungen' SQLAlias = 'K_Einzelleistungen' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' object daTableJoin1: TdaTableJoin ChildType = 6 object daField13: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField12: TdaField ChildType = 4 Alias = 'Art_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Art_ID' FieldLength = 0 FieldName = 'Art_ID' SQLFieldName = 'Art_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end end end object TdaSQLLink ChildType = 9 object daField14: TdaField ChildType = 10 Alias = 'ID (3)' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' IsDetail = True SQLFieldName = 'ID_3' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField15: TdaField ChildType = 11 Alias = 'Leistung_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Leistung_ID' FieldLength = 0 FieldName = 'Leistung_ID' SQLFieldName = 'Leistung_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end end end end object daADOQueryDataView6: TdaADOQueryDataView UserName = 'Query_So_2' Height = 284 Left = 1327 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 329 TypeColumnWidth = 52 Width = 273 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_Kurs_Tabelle' object So_2: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'So_2' MasterDataPipelineName = 'Kurs_Tabelle' object ppField1: TppField FieldAlias = 'Art_ID' FieldName = 'Art_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'SchuelerEinzelleistungen' end object ppField2: TppField FieldAlias = 'Bemerkung' FieldName = 'Bemerkung' FieldLength = 100 DisplayWidth = 100 Position = 1 TableName = 'SchuelerEinzelleistungen' end object ppField3: TppField FieldAlias = 'Datum' FieldName = 'Datum' FieldLength = 0 DataType = dtDateTime DisplayWidth = 18 Position = 2 TableName = 'SchuelerEinzelleistungen' end object ppField4: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtLongint DisplayWidth = 10 Position = 3 TableName = 'SchuelerEinzelleistungen' end object ppField5: TppField FieldAlias = 'Lehrer_ID' FieldName = 'Lehrer_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 4 TableName = 'SchuelerEinzelleistungen' end object ppField6: TppField FieldAlias = 'Leistung_ID' FieldName = 'Leistung_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 5 TableName = 'SchuelerEinzelleistungen' end object ppField7: TppField FieldAlias = 'NotenKrz' FieldName = 'NotenKrz' FieldLength = 2 DisplayWidth = 2 Position = 6 TableName = 'SchuelerEinzelleistungen' end object ppField8: TppField FieldAlias = 'SchulnrEigner' FieldName = 'SchulnrEigner' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 7 TableName = 'SchuelerEinzelleistungen' end object ppField9: TppField FieldAlias = 'Bezeichnung' FieldName = 'Bezeichnung' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 8 TableName = 'K_Einzelleistungen' end object ppField10: TppField FieldAlias = 'Sortierung' FieldName = 'Sortierung' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 9 TableName = 'K_Einzelleistungen' end object TppMasterFieldLink MasterFieldName = 'ASDJahrgang_2' GuidCollationType = gcMSAccess DetailFieldName = 'ASDJahrgang' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Klasse' GuidCollationType = gcMSAccess DetailFieldName = 'Klasse' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Name' GuidCollationType = gcMSAccess DetailFieldName = 'Name' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Vorname' GuidCollationType = gcMSAccess DetailFieldName = 'Vorname' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Kurs_ID' GuidCollationType = gcMSAccess DetailFieldName = 'Kurs_ID' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ASDSchulgliederung' GuidCollationType = gcMSAccess DetailFieldName = 'ASDSchulgliederung' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ASDJahrgang' GuidCollationType = gcMSAccess DetailFieldName = 'ASDJahrgang_2' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ID_3' GuidCollationType = gcMSAccess DetailFieldName = 'Leistung_ID' DetailSortOrder = soAscending IsCaseSensitive = True end end object daSQL3: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'So_2' IsCaseSensitive = True LinkColor = clGreen LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT SchuelerEinzelleistungen.Art_ID, ' ' SchuelerEinzelleistungen.Bemerkung, ' ' SchuelerEinzelleistungen.Datum, ' ' SchuelerEinzelleistungen.ID, ' ' SchuelerEinzelleistungen.Lehrer_ID, ' ' SchuelerEinzelleistungen.Leistung_ID, ' ' SchuelerEinzelleistungen.NotenKrz, ' ' SchuelerEinzelleistungen.SchulnrEigner, ' ' K_Einzelleistungen.Bezeichnung, ' ' K_Einzelleistungen.Sortierung' 'FROM (' ' SchuelerEinzelleistungen SchuelerEinzelleistungen' ' INNER JOIN K_Einzelleistungen K_Einzelleistungen ON ' ' (K_Einzelleistungen.ID = SchuelerEinzelleistungen.Art_ID) )' 'WHERE ( K_Einzelleistungen.Bezeichnung = '#39'So.2'#39' )' 'ORDER BY K_Einzelleistungen.Sortierung') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Value = 'So.2' object TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' SQLFieldName = 'Bezeichnung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end end object daField1: TdaField Alias = 'Art_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Art_ID' FieldLength = 0 FieldName = 'Art_ID' SQLFieldName = 'Art_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField2: TdaField Alias = 'Bemerkung' DisplayWidth = 100 FieldAlias = 'Bemerkung' FieldLength = 100 FieldName = 'Bemerkung' SQLFieldName = 'Bemerkung' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField3: TdaField Alias = 'Datum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Datum' FieldLength = 0 FieldName = 'Datum' SQLFieldName = 'Datum' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField4: TdaField Alias = 'ID' DataType = dtLongint DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField5: TdaField Alias = 'Lehrer_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Lehrer_ID' FieldLength = 0 FieldName = 'Lehrer_ID' SQLFieldName = 'Lehrer_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField6: TdaField Alias = 'Leistung_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Leistung_ID' FieldLength = 0 FieldName = 'Leistung_ID' SQLFieldName = 'Leistung_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField7: TdaField Alias = 'NotenKrz' DisplayWidth = 2 FieldAlias = 'NotenKrz' FieldLength = 2 FieldName = 'NotenKrz' SQLFieldName = 'NotenKrz' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField8: TdaField Alias = 'SchulnrEigner' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'SchulnrEigner' FieldLength = 0 FieldName = 'SchulnrEigner' SQLFieldName = 'SchulnrEigner' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField9: TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' IsDetail = True SQLFieldName = 'Bezeichnung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField10: TdaField Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' IsDetail = True SQLFieldName = 'Sortierung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField11: TdaField ChildType = 2 Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' SQLFieldName = 'Sortierung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daTable1: TdaTable ChildType = 5 Alias = 'SchuelerEinzelleistungen' JoinType = dajtNone SQLAlias = 'SchuelerEinzelleistungen' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' end object daTable2: TdaTable ChildType = 5 Alias = 'K_Einzelleistungen' SQLAlias = 'K_Einzelleistungen' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' object daTableJoin1: TdaTableJoin ChildType = 6 object daField13: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField12: TdaField ChildType = 4 Alias = 'Art_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Art_ID' FieldLength = 0 FieldName = 'Art_ID' SQLFieldName = 'Art_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end end end object TdaSQLLink ChildType = 9 object daField14: TdaField ChildType = 10 Alias = 'ID (3)' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' IsDetail = True SQLFieldName = 'ID_3' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField15: TdaField ChildType = 11 Alias = 'Leistung_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Leistung_ID' FieldLength = 0 FieldName = 'Leistung_ID' SQLFieldName = 'Leistung_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end end end end object daADOQueryDataView7: TdaADOQueryDataView UserName = 'Query_Kl_ges' Height = 284 Left = 35 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 626 TypeColumnWidth = 52 Width = 285 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_Kurs_Tabelle' object Kl_ges: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'Kl_ges' MasterDataPipelineName = 'Kurs_Tabelle' object ppField1: TppField FieldAlias = 'Art_ID' FieldName = 'Art_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'SchuelerEinzelleistungen' end object ppField2: TppField FieldAlias = 'Bemerkung' FieldName = 'Bemerkung' FieldLength = 100 DisplayWidth = 100 Position = 1 TableName = 'SchuelerEinzelleistungen' end object ppField3: TppField FieldAlias = 'Datum' FieldName = 'Datum' FieldLength = 0 DataType = dtDateTime DisplayWidth = 18 Position = 2 TableName = 'SchuelerEinzelleistungen' end object ppField4: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtLongint DisplayWidth = 10 Position = 3 TableName = 'SchuelerEinzelleistungen' end object ppField5: TppField FieldAlias = 'Lehrer_ID' FieldName = 'Lehrer_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 4 TableName = 'SchuelerEinzelleistungen' end object ppField6: TppField FieldAlias = 'Leistung_ID' FieldName = 'Leistung_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 5 TableName = 'SchuelerEinzelleistungen' end object ppField7: TppField FieldAlias = 'NotenKrz' FieldName = 'NotenKrz' FieldLength = 2 DisplayWidth = 2 Position = 6 TableName = 'SchuelerEinzelleistungen' end object ppField8: TppField FieldAlias = 'SchulnrEigner' FieldName = 'SchulnrEigner' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 7 TableName = 'SchuelerEinzelleistungen' end object ppField9: TppField FieldAlias = 'Bezeichnung' FieldName = 'Bezeichnung' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 8 TableName = 'K_Einzelleistungen' end object ppField10: TppField FieldAlias = 'Sortierung' FieldName = 'Sortierung' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 9 TableName = 'K_Einzelleistungen' end object TppMasterFieldLink MasterFieldName = 'ASDJahrgang_2' GuidCollationType = gcMSAccess DetailFieldName = 'ASDJahrgang' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Klasse' GuidCollationType = gcMSAccess DetailFieldName = 'Klasse' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Name' GuidCollationType = gcMSAccess DetailFieldName = 'Name' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Vorname' GuidCollationType = gcMSAccess DetailFieldName = 'Vorname' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Kurs_ID' GuidCollationType = gcMSAccess DetailFieldName = 'Kurs_ID' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ASDSchulgliederung' GuidCollationType = gcMSAccess DetailFieldName = 'ASDSchulgliederung' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ASDJahrgang' GuidCollationType = gcMSAccess DetailFieldName = 'ASDJahrgang_2' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ID_3' GuidCollationType = gcMSAccess DetailFieldName = 'Leistung_ID' DetailSortOrder = soAscending IsCaseSensitive = True end end object daSQL3: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'Kl_ges' IsCaseSensitive = True LinkColor = clGreen LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT SchuelerEinzelleistungen.Art_ID, ' ' SchuelerEinzelleistungen.Bemerkung, ' ' SchuelerEinzelleistungen.Datum, ' ' SchuelerEinzelleistungen.ID, ' ' SchuelerEinzelleistungen.Lehrer_ID, ' ' SchuelerEinzelleistungen.Leistung_ID, ' ' SchuelerEinzelleistungen.NotenKrz, ' ' SchuelerEinzelleistungen.SchulnrEigner, ' ' K_Einzelleistungen.Bezeichnung, ' ' K_Einzelleistungen.Sortierung' 'FROM (' ' SchuelerEinzelleistungen SchuelerEinzelleistungen' ' INNER JOIN K_Einzelleistungen K_Einzelleistungen ON ' ' (K_Einzelleistungen.ID = SchuelerEinzelleistungen.Art_ID) )' 'WHERE ' ' ( K_Einzelleistungen.Bezeichnung = '#39'Kl.ges'#39' )' 'ORDER BY K_Einzelleistungen.Sortierung') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Value = 'Kl.ges' object TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' SQLFieldName = 'Bezeichnung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end end object daField1: TdaField Alias = 'Art_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Art_ID' FieldLength = 0 FieldName = 'Art_ID' SQLFieldName = 'Art_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField2: TdaField Alias = 'Bemerkung' DisplayWidth = 100 FieldAlias = 'Bemerkung' FieldLength = 100 FieldName = 'Bemerkung' SQLFieldName = 'Bemerkung' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField3: TdaField Alias = 'Datum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Datum' FieldLength = 0 FieldName = 'Datum' SQLFieldName = 'Datum' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField4: TdaField Alias = 'ID' DataType = dtLongint DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField5: TdaField Alias = 'Lehrer_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Lehrer_ID' FieldLength = 0 FieldName = 'Lehrer_ID' SQLFieldName = 'Lehrer_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField6: TdaField Alias = 'Leistung_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Leistung_ID' FieldLength = 0 FieldName = 'Leistung_ID' SQLFieldName = 'Leistung_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField7: TdaField Alias = 'NotenKrz' DisplayWidth = 2 FieldAlias = 'NotenKrz' FieldLength = 2 FieldName = 'NotenKrz' SQLFieldName = 'NotenKrz' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField8: TdaField Alias = 'SchulnrEigner' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'SchulnrEigner' FieldLength = 0 FieldName = 'SchulnrEigner' SQLFieldName = 'SchulnrEigner' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField9: TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' IsDetail = True SQLFieldName = 'Bezeichnung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField10: TdaField Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' IsDetail = True SQLFieldName = 'Sortierung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField11: TdaField ChildType = 2 Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' SQLFieldName = 'Sortierung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daTable1: TdaTable ChildType = 5 Alias = 'SchuelerEinzelleistungen' JoinType = dajtNone SQLAlias = 'SchuelerEinzelleistungen' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' end object daTable2: TdaTable ChildType = 5 Alias = 'K_Einzelleistungen' SQLAlias = 'K_Einzelleistungen' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' object daTableJoin1: TdaTableJoin ChildType = 6 object daField13: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField12: TdaField ChildType = 4 Alias = 'Art_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Art_ID' FieldLength = 0 FieldName = 'Art_ID' SQLFieldName = 'Art_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end end end object TdaSQLLink ChildType = 9 object daField14: TdaField ChildType = 10 Alias = 'ID (3)' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' IsDetail = True SQLFieldName = 'ID_3' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField15: TdaField ChildType = 11 Alias = 'Leistung_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Leistung_ID' FieldLength = 0 FieldName = 'Leistung_ID' SQLFieldName = 'Leistung_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end end end end object daADOQueryDataView8: TdaADOQueryDataView UserName = 'Query_TeilLeist_ges' Height = 284 Left = 931 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 14 TypeColumnWidth = 52 Width = 282 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_Kurs_Tabelle' object TeilLeist_ges: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'TeilLeist_ges' MasterDataPipelineName = 'Kurs_Tabelle' object ppField1: TppField FieldAlias = 'Art_ID' FieldName = 'Art_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'SchuelerEinzelleistungen' end object ppField2: TppField FieldAlias = 'Bemerkung' FieldName = 'Bemerkung' FieldLength = 100 DisplayWidth = 100 Position = 1 TableName = 'SchuelerEinzelleistungen' end object ppField3: TppField FieldAlias = 'Datum' FieldName = 'Datum' FieldLength = 0 DataType = dtDateTime DisplayWidth = 18 Position = 2 TableName = 'SchuelerEinzelleistungen' end object ppField4: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtLongint DisplayWidth = 10 Position = 3 TableName = 'SchuelerEinzelleistungen' end object ppField5: TppField FieldAlias = 'Lehrer_ID' FieldName = 'Lehrer_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 4 TableName = 'SchuelerEinzelleistungen' end object ppField6: TppField FieldAlias = 'Leistung_ID' FieldName = 'Leistung_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 5 TableName = 'SchuelerEinzelleistungen' end object ppField7: TppField FieldAlias = 'NotenKrz' FieldName = 'NotenKrz' FieldLength = 2 DisplayWidth = 2 Position = 6 TableName = 'SchuelerEinzelleistungen' end object ppField8: TppField FieldAlias = 'SchulnrEigner' FieldName = 'SchulnrEigner' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 7 TableName = 'SchuelerEinzelleistungen' end object ppField9: TppField FieldAlias = 'Bezeichnung' FieldName = 'Bezeichnung' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 8 TableName = 'K_Einzelleistungen' end object ppField10: TppField FieldAlias = 'Sortierung' FieldName = 'Sortierung' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 9 TableName = 'K_Einzelleistungen' end object TppMasterFieldLink MasterFieldName = 'ASDJahrgang_2' GuidCollationType = gcMSAccess DetailFieldName = 'ASDJahrgang' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Klasse' GuidCollationType = gcMSAccess DetailFieldName = 'Klasse' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Name' GuidCollationType = gcMSAccess DetailFieldName = 'Name' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Vorname' GuidCollationType = gcMSAccess DetailFieldName = 'Vorname' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Kurs_ID' GuidCollationType = gcMSAccess DetailFieldName = 'Kurs_ID' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ASDSchulgliederung' GuidCollationType = gcMSAccess DetailFieldName = 'ASDSchulgliederung' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ASDJahrgang' GuidCollationType = gcMSAccess DetailFieldName = 'ASDJahrgang_2' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ID_3' GuidCollationType = gcMSAccess DetailFieldName = 'Leistung_ID' DetailSortOrder = soAscending IsCaseSensitive = True end end object daSQL3: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'TeilLeist_ges' IsCaseSensitive = True LinkColor = clGreen LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT SchuelerEinzelleistungen.Art_ID, ' ' SchuelerEinzelleistungen.Bemerkung, ' ' SchuelerEinzelleistungen.Datum, ' ' SchuelerEinzelleistungen.ID, ' ' SchuelerEinzelleistungen.Lehrer_ID, ' ' SchuelerEinzelleistungen.Leistung_ID, ' ' SchuelerEinzelleistungen.NotenKrz, ' ' SchuelerEinzelleistungen.SchulnrEigner, ' ' K_Einzelleistungen.Bezeichnung, ' ' K_Einzelleistungen.Sortierung' 'FROM (' ' SchuelerEinzelleistungen SchuelerEinzelleistungen' ' INNER JOIN K_Einzelleistungen K_Einzelleistungen ON ' ' (K_Einzelleistungen.ID = SchuelerEinzelleistungen.Art_ID) )' 'WHERE ' ' ( K_Einzelleistungen.Bezeichnung IN ('#39'Kl.1'#39','#39'Kl.2'#39','#39'Kl.ges' + #39','#39'So.1'#39','#39'So.2'#39','#39'So.ges'#39') )' 'ORDER BY K_Einzelleistungen.Sortierung') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList Value = 'Kl.1,Kl.2,Kl.ges,So.1,So.2,So.ges' object TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' SQLFieldName = 'Bezeichnung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end end object daField1: TdaField Alias = 'Art_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Art_ID' FieldLength = 0 FieldName = 'Art_ID' SQLFieldName = 'Art_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField2: TdaField Alias = 'Bemerkung' DisplayWidth = 100 FieldAlias = 'Bemerkung' FieldLength = 100 FieldName = 'Bemerkung' SQLFieldName = 'Bemerkung' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField3: TdaField Alias = 'Datum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Datum' FieldLength = 0 FieldName = 'Datum' SQLFieldName = 'Datum' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField4: TdaField Alias = 'ID' DataType = dtLongint DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField5: TdaField Alias = 'Lehrer_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Lehrer_ID' FieldLength = 0 FieldName = 'Lehrer_ID' SQLFieldName = 'Lehrer_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField6: TdaField Alias = 'Leistung_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Leistung_ID' FieldLength = 0 FieldName = 'Leistung_ID' SQLFieldName = 'Leistung_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField7: TdaField Alias = 'NotenKrz' DisplayWidth = 2 FieldAlias = 'NotenKrz' FieldLength = 2 FieldName = 'NotenKrz' SQLFieldName = 'NotenKrz' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField8: TdaField Alias = 'SchulnrEigner' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'SchulnrEigner' FieldLength = 0 FieldName = 'SchulnrEigner' SQLFieldName = 'SchulnrEigner' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end object daField9: TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' IsDetail = True SQLFieldName = 'Bezeichnung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField10: TdaField Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' IsDetail = True SQLFieldName = 'Sortierung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField11: TdaField ChildType = 2 Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' SQLFieldName = 'Sortierung' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daTable1: TdaTable ChildType = 5 Alias = 'SchuelerEinzelleistungen' JoinType = dajtNone SQLAlias = 'SchuelerEinzelleistungen' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' end object daTable2: TdaTable ChildType = 5 Alias = 'K_Einzelleistungen' SQLAlias = 'K_Einzelleistungen' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' object daTableJoin1: TdaTableJoin ChildType = 6 object daField13: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'K_Einzelleistungen' TableName = 'K_Einzelleistungen' TableSQLAlias = 'K_Einzelleistungen' end object daField12: TdaField ChildType = 4 Alias = 'Art_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Art_ID' FieldLength = 0 FieldName = 'Art_ID' SQLFieldName = 'Art_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end end end object TdaSQLLink ChildType = 9 object daField14: TdaField ChildType = 10 Alias = 'ID (3)' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' IsDetail = True SQLFieldName = 'ID_3' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField15: TdaField ChildType = 11 Alias = 'Leistung_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Leistung_ID' FieldLength = 0 FieldName = 'Leistung_ID' SQLFieldName = 'Leistung_ID' TableAlias = 'SchuelerEinzelleistungen' TableName = 'SchuelerEinzelleistungen' TableSQLAlias = 'SchuelerEinzelleistungen' end end end end end object raCodeModule1: TraCodeModule ProgramStream = { 01060D54726156617250726F6772616D094368696C645479706502110B50726F 6772616D4E616D6506095661726961626C65730B50726F6772616D5479706507 0B747450726F63656475726506536F75726365066C70726F6365647572652056 61726961626C65733B0D0A7661720D0A6B312C6B322C6B6765732C73312C7332 2C736765733A20426F6F6C65616E3B0D0A6665686C5F6765732C206665686C5F 753A20696E74656765723B2020200D0A0D0A626567696E0D0A0D0A656E643B0D 0A084361726574506F7301021B0203000001060A54726150726F6772616D0943 68696C645479706502150E497346756E6374696F6E54797065090B50726F6772 616D4E616D65060E6E6F74655F696E5F70756E6B74650B50726F6772616D5479 7065070A747446756E6374696F6E06536F757263650C0A03000066756E637469 6F6E206E6F74655F696E5F70756E6B746528614E6F74653A20737472696E6729 3A20737472696E673B200D0A0D0A626567696E0D0A0D0A20696620614E6F7465 203D2027312B27207468656E20726573756C743A3D202731352720656C736520 0D0A20696620614E6F7465203D2027312720207468656E20726573756C743A3D 202731342720656C7365200D0A20696620614E6F7465203D2027312D27207468 656E20726573756C743A3D202731332720656C7365200D0A20696620614E6F74 65203D2027322B27207468656E20726573756C743A3D202731322720656C7365 200D0A20696620614E6F7465203D2027322720207468656E20726573756C743A 3D202731312720656C7365200D0A20696620614E6F7465203D2027322D272074 68656E20726573756C743A3D202731302720656C7365200D0A20696620614E6F 7465203D2027332B27207468656E20726573756C743A3D202730392720656C73 65200D0A20696620614E6F7465203D2027332720207468656E20726573756C74 3A3D202730382720656C7365200D0A20696620614E6F7465203D2027332D2720 7468656E20726573756C743A3D202730372720656C7365200D0A20696620614E 6F7465203D2027342B27207468656E20726573756C743A3D202730362720656C 7365200D0A20696620614E6F7465203D2027342720207468656E20726573756C 743A3D202730352720656C7365200D0A20696620614E6F7465203D2027342D27 207468656E20726573756C743A3D202730342720656C7365200D0A2069662061 4E6F7465203D2027352B27207468656E20726573756C743A3D20273033272065 6C7365200D0A20696620614E6F7465203D2027352720207468656E2072657375 6C743A3D202730322720656C7365200D0A20696620614E6F7465203D2027352D 27207468656E20726573756C743A3D202730312720656C7365200D0A20696620 614E6F7465203D2027362720207468656E20726573756C743A3D202730302720 0D0A200D0A20656C736520726573756C743A3D20272D2D273B0D0A200D0A656E 643B0D0A084361726574506F730102010201000001060F5472614576656E7448 616E646C65720B50726F6772616D4E616D6506144C615F4A6168725F4162734F 6E476574546578740B50726F6772616D54797065070B747450726F6365647572 6506536F7572636506A670726F636564757265204C615F4A6168725F4162734F 6E476574546578742876617220546578743A20537472696E67293B0D0A626567 696E0D0A0D0A746578743A3D20696E74746F737472284B7572735F546162656C 6C655B27536368756C6A616872275D29202B20272E27202B20696E74746F7374 72284B7572735F546162656C6C655B27536368756C6A61687241627363686E69 7474275D293B0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060B 4C615F4A6168725F416273094576656E744E616D6506094F6E47657454657874 074576656E7449440235084361726574506F730102010201000001060F547261 4576656E7448616E646C65720B50726F6772616D4E616D6506144442545F4B75 72735F464C4F6E476574546578740B50726F6772616D54797065070B74745072 6F63656475726506536F75726365067670726F636564757265204442545F4B75 72735F464C4F6E476574546578742876617220546578743A20537472696E6729 3B0D0A626567696E0D0A0D0A202054657874203A3D2074657874202B20272C20 27202B204B7572735F546162656C6C655B27566F726E616D65275D3B0D0A0D0A 656E643B0D0A0D436F6D706F6E656E744E616D65060B4442545F4B7572735F46 4C094576656E744E616D6506094F6E47657454657874074576656E7449440235 084361726574506F730102190204000001060F5472614576656E7448616E646C 65720B50726F6772616D4E616D65060F4C615F506B744F6E476574546578740B 50726F6772616D54797065070B747450726F63656475726506536F7572636506 7470726F636564757265204C615F506B744F6E47657454657874287661722054 6578743A20537472696E67293B0D0A626567696E0D0A0D0A202054657874203A 3D206E6F74655F696E5F70756E6B7465284B7572735F546162656C6C655B274E 6F74656E4B727A275D293B0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E 616D6506064C615F506B74094576656E744E616D6506094F6E47657454657874 074576656E7449440235084361726574506F730102010201000001060F547261 4576656E7448616E646C65720B50726F6772616D4E616D6506114442545F4E6F 74654F6E476574546578740B50726F6772616D54797065070B747450726F6365 6475726506536F75726365066C70726F636564757265204442545F4E6F74654F 6E476574546578742876617220546578743A20537472696E67293B0D0A626567 696E0D0A0D0A20206966204C615F506B742E74657874203D20272D2D27207468 656E20746578743A3D20272D2D273B0D0A0D0A656E643B0D0A0D436F6D706F6E 656E744E616D6506084442545F4E6F7465094576656E744E616D6506094F6E47 657454657874074576656E7449440235084361726574506F7301020102010000 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D65060E 4C615F6B316E7A4F6E5072696E740B50726F6772616D54797065070B74745072 6F63656475726506536F75726365064B70726F636564757265204C615F6B316E 7A4F6E5072696E743B0D0A626567696E20200D0A20204C615F6B316E7A2E7669 7369626C653A3D206B31203D2066616C73653B0D0A656E643B0D0A0D436F6D70 6F6E656E744E616D6506074C615F6B316E7A094576656E744E616D6506074F6E 5072696E74074576656E7449440220084361726574506F7301021F0203000001 060F5472614576656E7448616E646C65720B50726F6772616D4E616D65060E4C 615F6B326E7A4F6E5072696E740B50726F6772616D54797065070B747450726F 63656475726506536F75726365064970726F636564757265204C615F6B326E7A 4F6E5072696E743B0D0A626567696E0D0A20204C615F6B326E7A2E7669736962 6C653A3D206B32203D2066616C73653B0D0A656E643B0D0A0D436F6D706F6E65 6E744E616D6506074C615F6B326E7A094576656E744E616D6506074F6E507269 6E74074576656E7449440220084361726574506F730102010201000001060F54 72614576656E7448616E646C65720B50726F6772616D4E616D6506104C615F6B 6765736E7A4F6E5072696E740B50726F6772616D54797065070B747450726F63 656475726506536F75726365064F70726F636564757265204C615F6B6765736E 7A4F6E5072696E743B0D0A626567696E0D0A20204C615F6B6765736E7A2E7669 7369626C653A3D206B676573203D2066616C73653B0D0A656E643B0D0A0D436F 6D706F6E656E744E616D6506094C615F6B6765736E7A094576656E744E616D65 06074F6E5072696E74074576656E7449440220084361726574506F7301020102 01000001060F5472614576656E7448616E646C65720B50726F6772616D4E616D 65060F4C615F736F316E7A4F6E5072696E740B50726F6772616D54797065070B 747450726F63656475726506536F75726365064B70726F636564757265204C61 5F736F316E7A4F6E5072696E743B0D0A626567696E0D0A20204C615F736F316E 7A2E76697369626C653A3D207331203D2066616C73653B0D0A656E643B0D0A0D 436F6D706F6E656E744E616D6506084C615F736F316E7A094576656E744E616D 6506074F6E5072696E74074576656E7449440220084361726574506F73010201 0201000001060F5472614576656E7448616E646C65720B50726F6772616D4E61 6D65060F4C615F736F326E7A4F6E5072696E740B50726F6772616D5479706507 0B747450726F63656475726506536F75726365064B70726F636564757265204C 615F736F326E7A4F6E5072696E743B0D0A626567696E0D0A20204C615F736F32 6E7A2E76697369626C653A3D207332203D2066616C73653B0D0A656E643B0D0A 0D436F6D706F6E656E744E616D6506084C615F736F326E7A094576656E744E61 6D6506074F6E5072696E74074576656E7449440220084361726574506F730102 010201000001060F5472614576656E7448616E646C65720B50726F6772616D4E 616D6506114C615F736F6765736E7A4F6E5072696E740B50726F6772616D5479 7065070B747450726F63656475726506536F75726365065170726F6365647572 65204C615F736F6765736E7A4F6E5072696E743B0D0A626567696E0D0A20204C 615F736F6765736E7A2E76697369626C653A3D2073676573203D2066616C7365 3B0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060A4C615F736F6765 736E7A094576656E744E616D6506074F6E5072696E74074576656E7449440220 084361726574506F730102010201000001060F5472614576656E7448616E646C 65720B50726F6772616D4E616D6506115265706F72744265666F72655072696E 740B50726F6772616D54797065070B747450726F63656475726506536F757263 65146D01000070726F636564757265205265706F72744265666F72655072696E 743B0D0A626567696E0D0A202F2F2073686F776D657373616765282745732077 657264656E20646965205465696C6C65697374756E677362657A656963686E75 6E67656E272B636872283133292B274B6C312C204B6C322C204B6C472066C3BC 72204B6C61757375726E6F74656E20756E64272B636872283133292B27536F31 2C20536F322C20536F472076657277656E6465742E272B636872283133292B27 46C3BC7220616E646572652042657A656963686E756E67656E206D7573732064 696520446174656E7175656C6C652066C3BC7220646965205375627265706F72 7473206765C3A46E646572742077657264656E2028446174656E203E2049636F 6E20224C75706522292C206175C39F657264656D206465722045696E74726167 20756E7465722044657461696C4265666F72655072696E7420766F6E20537562 7265706F7274312E27293B0D0A656E643B0D0A0D436F6D706F6E656E744E616D 6506065265706F7274094576656E744E616D65060B4265666F72655072696E74 074576656E7449440201084361726574506F730102010201000001060F547261 4576656E7448616E646C65720B50726F6772616D4E616D6506144442545F4665 686C7374644F6E476574546578740B50726F6772616D54797065070B74745072 6F63656475726506536F75726365068B70726F636564757265204442545F4665 686C7374644F6E476574546578742876617220546578743A20537472696E6729 3B0D0A626567696E0D0A20200D0A2020546578743A3D2074657874202B202720 202827202B20696E74746F737472284B7572735F546162656C6C655B27754665 686C737464275D29202B202729273B0D0A20200D0A656E643B0D0A0D436F6D70 6F6E656E744E616D65060B4442545F4665686C737464094576656E744E616D65 06094F6E47657454657874074576656E7449440235084361726574506F730102 140204000001060F5472614576656E7448616E646C65720B50726F6772616D4E 616D6506164442545F4B6C617373655F4A474F6E476574546578740B50726F67 72616D54797065070B747450726F63656475726506536F75726365068070726F 636564757265204442545F4B6C617373655F4A474F6E47657454657874287661 7220546578743A20537472696E67293B0D0A626567696E0D0A0D0A2020546578 743A3D2074657874202B2027202F2027202B204B7572735F546162656C6C655B 274153444A61687267616E6720283229275D3B0D0A0D0A656E643B0D0A0D436F 6D706F6E656E744E616D65060D4442545F4B6C617373655F4A47094576656E74 4E616D6506094F6E47657454657874074576656E744944023508436172657450 6F730102030203000001060F5472614576656E7448616E646C65720B50726F67 72616D4E616D65061547726F757032416674657247726F7570427265616B0B50 726F6772616D54797065070B747450726F63656475726506536F757263650695 70726F6365647572652047726F757032416674657247726F7570427265616B3B 0D0A626567696E0D0A20206B313A3D20202066616C73653B0D0A20206B323A3D 20202066616C73653B0D0A20206B6765733A3D2066616C73653B0D0A20207331 3A3D20202066616C73653B0D0A202073323A3D20202066616C73653B0D0A2020 736765733A3D2066616C73653B0D0A656E643B0D0A0D436F6D706F6E656E744E 616D65060647726F757032094576656E744E616D65060F416674657247726F75 70427265616B074576656E744944021B084361726574506F7301020502090000 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650611 44657461696C4265666F72655072696E740B50726F6772616D54797065070B74 7450726F63656475726506536F75726365068C70726F63656475726520446574 61696C4265666F72655072696E743B0D0A626567696E0D0A20206665686C5F67 65733A3D206665686C5F676573202B204B7572735F546162656C6C655B274665 686C737464275D3B0D0A20206665686C5F753A3D206665686C5F75202B204B75 72735F546162656C6C655B27754665686C737464275D3B0D0A656E643B0D0A0D 436F6D706F6E656E744E616D65060644657461696C094576656E744E616D6506 0B4265666F72655072696E74074576656E7449440218084361726574506F7301 022E0204000001060F5472614576656E7448616E646C65720B50726F6772616D 4E616D6506144C615F6665686C5F6765734F6E476574546578740B50726F6772 616D54797065070B747450726F63656475726506536F75726365066270726F63 6564757265204C615F6665686C5F6765734F6E47657454657874287661722054 6578743A20537472696E67293B0D0A626567696E0D0A0D0A2020546578743A3D 20696E74746F737472286665686C5F676573293B0D0A0D0A656E643B0D0A0D43 6F6D706F6E656E744E616D65060B4C615F6665686C5F676573094576656E744E 616D6506094F6E47657454657874074576656E7449440235084361726574506F 7301021D0204000001060F5472614576656E7448616E646C65720B50726F6772 616D4E616D6506124C615F6665686C5F754F6E476574546578740B50726F6772 616D54797065070B747450726F63656475726506536F75726365065E70726F63 6564757265204C615F6665686C5F754F6E476574546578742876617220546578 743A20537472696E67293B0D0A626567696E0D0A0D0A2020546578743A3D2069 6E74746F737472286665686C5F75293B0D0A0D0A656E643B0D0A0D436F6D706F 6E656E744E616D6506094C615F6665686C5F75094576656E744E616D6506094F 6E47657454657874074576656E7449440235084361726574506F7301021B0204 000001060F5472614576656E7448616E646C65720B50726F6772616D4E616D65 061547726F757036416674657247726F7570427265616B0B50726F6772616D54 797065070B747450726F63656475726506536F75726365064F70726F63656475 72652047726F757036416674657247726F7570427265616B3B0D0A626567696E 0D0A20206665686C5F6765733A3D20303B0D0A20206665686C5F753A3D20303B 0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060647726F7570360945 76656E744E616D65060F416674657247726F7570427265616B074576656E7449 44021B084361726574506F730102050205000000} end object ppDesignLayers2: TppDesignLayers object ppDesignLayer2: TppDesignLayer UserName = 'Foreground1' LayerType = ltBanded Index = 0 end end object ppParameterList2: TppParameterList object ppArchivierung: TppParameter AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = False AutoSearchSettings.ShowAllValues = True DataType = dtString LookupList.Strings = ( 'immer' 'nie' 'Schildvorgabe') LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName Value = '' UserName = 'Archivierung' end object ppParameter1: TppParameter AutoSearchSettings.Enabled = True AutoSearchSettings.FieldAlias = 'KurzBez' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = True AutoSearchSettings.SearchOperator = soInList AutoSearchSettings.ShowAllValues = True AutoSearchSettings.DataPipelineName = 'Kurs_Tabelle' DataType = dtString LookupSettings.NameField = 'KurzBez' LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName LookupSettings.ValueField = 'KurzBez' LookupSettings.DataPipelineName = 'Kurs_Tabelle' Value = '' UserName = 'AuswahlKurs' end object ppParameter2: TppParameter AutoSearchSettings.Enabled = True AutoSearchSettings.FieldAlias = 'ASDJahrgang' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = False AutoSearchSettings.SearchOperator = soInList AutoSearchSettings.ShowAllValues = True AutoSearchSettings.DataPipelineName = 'Kurs_Tabelle' DataType = dtString LookupSettings.NameField = 'ASDJahrgang' LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName LookupSettings.ValueField = 'ASDJahrgang' LookupSettings.DataPipelineName = 'Kurs_Tabelle' Value = '' UserName = 'Auswahl_ASDJgg' end object ppParameter3: TppParameter AutoSearchSettings.Enabled = True AutoSearchSettings.FieldAlias = 'ASDSchulgliederung' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = False AutoSearchSettings.SearchOperator = soInList AutoSearchSettings.ShowAllValues = True AutoSearchSettings.DataPipelineName = 'Kurs_Tabelle' DataType = dtString LookupSettings.NameField = 'ASDSchulgliederung' LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName LookupSettings.ValueField = 'ASDSchulgliederung' LookupSettings.DataPipelineName = 'Kurs_Tabelle' Value = '' UserName = 'Auswahl_Bildgg' end object ppParameter4: TppParameter AutoSearchSettings.Enabled = True AutoSearchSettings.FieldAlias = 'Klasse' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = False AutoSearchSettings.SearchOperator = soInList AutoSearchSettings.ShowAllValues = True AutoSearchSettings.DataPipelineName = 'Kurs_Tabelle' DataType = dtString LookupSettings.NameField = 'Klasse' LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName LookupSettings.ValueField = 'Klasse' LookupSettings.DataPipelineName = 'Kurs_Tabelle' Value = '' UserName = 'Wahl_Klasse' end end end