object Report: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.SuS PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = '02_Klassenliste_leftouter_ausgewaehlte_Vermerke_mit_StV_nach_Bem' + 'Art_Datum.rtm' PrinterSetup.PaperName = 'A4 210 x 297 mm' PrinterSetup.PrinterName = 'Screen' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 10000 PrinterSetup.mmMarginLeft = 15000 PrinterSetup.mmMarginRight = 10000 PrinterSetup.mmMarginTop = 10000 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 SaveAsTemplate = True Template.FileName = 'F:\SchILD-NRW\SchILD-Reports\WBk_Bochum_Sekretariat\Listen\Verme' + 'rkart\02_Klassenliste_leftouter_ausgewaehlte_Vermerke_mit_StV_na' + 'ch_BemArt_Datum.rtm' Template.Format = ftASCII Units = utMillimeters ArchiveFileName = '($MyDocuments)\ReportArchive.raf' CachePages = True 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 = False ThumbnailSettings.Visible = False ThumbnailSettings.DeadSpace = 30 PDFSettings.Author = 'Schild-NRW' PDFSettings.EmbedFontOptions = [efUseSubset] 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 = feUnicode PDFSettings.ImageCompressionLevel = 1 PreviewFormSettings.ZoomSetting = zs100Percent PreviewFormSettings.SinglePageOnly = True RTFSettings.DefaultFont.Charset = DEFAULT_CHARSET RTFSettings.DefaultFont.Color = clWindowText RTFSettings.DefaultFont.Height = -15 RTFSettings.DefaultFont.Name = 'Calibri' RTFSettings.DefaultFont.Style = [] ShowPrintDialog = False TextFileName = '($MyDocuments)\Report.pdf' TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True XLSSettings.AppName = 'ReportBuilder' XLSSettings.Author = 'Schild-NRW' XLSSettings.Subject = 'Report' XLSSettings.Title = 'Report' Left = 128 Top = 8 Version = '15.05' mmColumnWidth = 165000 DataPipelineName = 'SuS' object ppTitleBand1: TppTitleBand Background.Brush.Style = bsClear PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 9790 mmPrintPosition = 0 object ppSubReport2: TppSubReport UserName = 'SubReport1' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentWidth = False TraverseAllData = False DataPipelineName = 'KuK' mmHeight = 5027 mmLeft = 87842 mmTop = 0 mmWidth = 27252 BandType = 1 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport2: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView2.KuK PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = '02_Klassenliste_leftouter_ausgewaehlte_Vermerke_mit_StV_nach_Bem' + 'Art_Datum.rtm' PrinterSetup.PaperName = 'A4 210 x 297 mm' PrinterSetup.PrinterName = 'Screen' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 10000 PrinterSetup.mmMarginLeft = 15000 PrinterSetup.mmMarginRight = 10000 PrinterSetup.mmMarginTop = 10000 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 0 DataPipelineName = 'KuK' object ppTitleBand2: TppTitleBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppDetailBand3: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppSummaryBand1: TppSummaryBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppGroup3: TppGroup BreakName = 'GU_ID' DataPipeline = daADOQueryDataView2.KuK GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True ReprintOnSubsequentPage = False StartOnOddPage = False UserName = 'Group2' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'KuK' 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 raCodeModule3: TraCodeModule ProgramStream = { 01060D54726156617250726F6772616D094368696C645479706502110B50726F 6772616D4E616D6506095661726961626C65730B50726F6772616D5479706507 0B747450726F63656475726506536F75726365065270726F6365647572652056 61726961626C65733B0D0A7661720D0A2069645F6C6973743A20737472696E67 3B0D0A206B756B49443A20737472696E673B20200D0A0D0A626567696E0D0A0D 0A656E643B0D0A084361726574506F730102010201000000} end object ppDesignLayers3: TppDesignLayers object ppDesignLayer3: TppDesignLayer UserName = 'PageLayer1' LayerType = ltBanded Index = 0 end end end end object ppSubReport4: TppSubReport UserName = 'SubReport3' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentWidth = False ShiftRelativeTo = ppSubReport5 TraverseAllData = False DataPipelineName = 'SuS' mmHeight = 5027 mmLeft = 0 mmTop = 4763 mmWidth = 42863 BandType = 1 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport4: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView1.SuS PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = '02_Klassenliste_leftouter_ausgewaehlte_Vermerke_mit_StV_nach_Bem' + 'Art_Datum.rtm' PrinterSetup.PaperName = 'A4 210 x 297 mm' PrinterSetup.PrinterName = 'Screen' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 10000 PrinterSetup.mmMarginLeft = 15000 PrinterSetup.mmMarginRight = 10000 PrinterSetup.mmMarginTop = 10000 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 0 DataPipelineName = 'SuS' object ppDetailBand5: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 5027 mmPrintPosition = 0 object ppSubReport3: TppSubReport UserName = 'SubReport2' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentWidth = False TraverseAllData = False DataPipelineName = 'SuS_Verm' mmHeight = 5027 mmLeft = 0 mmTop = 0 mmWidth = 33602 BandType = 4 LayerName = Foreground3 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport3: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView3.SuS_Verm PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = '02_Klassenliste_leftouter_ausgewaehlte_Vermerke_mit_StV_nach_Bem' + 'Art_Datum.rtm' PrinterSetup.PaperName = 'A4 210 x 297 mm' PrinterSetup.PrinterName = 'Screen' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 10000 PrinterSetup.mmMarginLeft = 15000 PrinterSetup.mmMarginRight = 10000 PrinterSetup.mmMarginTop = 10000 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 0 DataPipelineName = 'SuS_Verm' object ppDetailBand4: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppSummaryBand2: TppSummaryBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppGroup4: TppGroup BreakName = 'Bezeichnung' DataPipeline = daADOQueryDataView3.SuS_Verm GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True ReprintOnSubsequentPage = False StartOnOddPage = False UserName = 'Group4' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'SuS_Verm' 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 raCodeModule4: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D65061B 47726F757048656164657242616E64344265666F72655072696E740B50726F67 72616D54797065070B747450726F63656475726506536F7572636506A370726F 6365647572652047726F757048656164657242616E64344265666F7265507269 6E743B0D0A626567696E0D0A2020696620706F73285375535F5665726D5B2742 657A656963686E756E67275D2C7665726D5F6C69737429203C2031207468656E 207665726D5F6C6973743A3D207665726D5F6C697374202B205375535F566572 6D5B2742657A656963686E756E67275D202B20272C20273B0D0A656E643B0D0A 0D436F6D706F6E656E744E616D65061047726F757048656164657242616E6434 094576656E744E616D65060B4265666F72655072696E74074576656E74494402 18084361726574506F730102080204000000} end object ppDesignLayers4: TppDesignLayers object ppDesignLayer4: TppDesignLayer UserName = 'Foreground2' LayerType = ltBanded Index = 0 end end end end end object ppSummaryBand3: TppSummaryBand Background.Brush.Style = bsClear PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 3969 mmPrintPosition = 0 object ppLine2: TppLine UserName = 'Line2' Anchors = [atLeft, atBottom] ParentWidth = True Position = lpBottom Weight = 0.750000000000000000 mmHeight = 1058 mmLeft = 0 mmTop = 2913 mmWidth = 185000 BandType = 7 LayerName = Foreground3 end object ppLabel11: TppLabel UserName = 'Label11' Caption = 'Davon in der Auswahl:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3704 mmLeft = 3175 mmTop = 0 mmWidth = 32279 BandType = 7 LayerName = Foreground3 end object ppLine9: TppLine UserName = 'Line9' ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 0 mmTop = 0 mmWidth = 3704 BandType = 7 LayerName = Foreground3 end object ppLine10: TppLine UserName = 'Line10' ParentHeight = True Position = lpRight StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 181240 mmTop = 0 mmWidth = 3704 BandType = 7 LayerName = Foreground3 end object ppMemo2: TppMemo UserName = 'Memo_vermlistallg' Caption = 'Memo_vermlistallg' CharWrap = False Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] Lines.Strings = ( '6 Monate Praxis, Laufbahn-Bemerkung, iPad_neu, 2 Jahre Praxis, B' + 'eurlaubung, Mahnstufe, Abgeschl. Berufsausbildung, Allgemeine_Be' + 'merkung, Eintrag Schulleitung, Entlassung, Mahnstufe2, Mahnung_F' + 'ehlzeiten, Nachpruefung (Ergebnis), Nachpruefung (Faecher), Ordn' + 'ungsma'#223'nahme Fehlzeiten, Vorkursbeleger, iPad_rueck, Zust'#228'ndiges' + ' BAf'#246'G-Amt, Vorgesehene Klasse, Corona_Zulassung, 2.FS, Abmeldun' + 'g, Entlassung wg Fehlzeiten, Ausnahmegenehmigung Arnsberg, Unter' + 'richtsbesuch, FHR_nur, Vorleistung, Anmeldung_Sprachpruefung, Sp' + 'rachfeststellungspr'#252'fung, Corona_Abschluss, Nachteilsausgleich, ' + 'Beschluss der Teilkonferenz, Einladung Teilkonferenz, Mahnstufe1' + ', Glaubhaftmachung, Zweitschrift ausgestellt, Verweis1, NTA_ex, ' + 'Einladung Beratungsgespr'#228'ch') RemoveEmptyLines = False Stretch = True Transparent = True mmHeight = 3572 mmLeft = 39698 mmTop = 0 mmWidth = 144066 BandType = 7 LayerName = Foreground3 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 mmLeading = 0 end object ppLine11: TppLine UserName = 'Line11' ParentWidth = True Weight = 0.750000000000000000 mmHeight = 794 mmLeft = 0 mmTop = 0 mmWidth = 185000 BandType = 7 LayerName = Foreground3 end end object raCodeModule5: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650618 4D656D6F5F7665726D6C697374616C6C674F6E5072696E740B50726F6772616D 54797065070B747450726F63656475726506536F7572636506CA70726F636564 757265204D656D6F5F7665726D6C697374616C6C674F6E5072696E743B0D0A76 6172207478743A20737472696E673B0D0A0D0A626567696E0D0A0D0A20207478 743A3D20636F7079287665726D5F6C6973742C312C6C656E677468287665726D 5F6C69737429202D2032293B0D0A2020696620747874203D202727207468656E 207478743A3D20272D206B65696E65202D273B0D0A0D0A20204D656D6F5F7665 726D6C697374616C6C672E746578743A3D207478743B0D0A20200D0A0D0A656E 643B0D0A0D436F6D706F6E656E744E616D6506114D656D6F5F7665726D6C6973 74616C6C67094576656E744E616D6506074F6E5072696E74074576656E744944 0220084361726574506F7301021F0209000000} end object ppDesignLayers5: TppDesignLayers object ppDesignLayer5: TppDesignLayer UserName = 'Foreground3' LayerType = ltBanded Index = 0 end end end end object ppSubReport5: TppSubReport UserName = 'SubReport5' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentWidth = False TraverseAllData = False DataPipelineName = 'SuS_alle' mmHeight = 5027 mmLeft = 0 mmTop = 0 mmWidth = 42863 BandType = 1 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport5: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView5.SuS_alle PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = '02_Klassenliste_leftouter_ausgewaehlte_Vermerke_mit_StV_nach_Bem' + 'Art_Datum.rtm' PrinterSetup.PaperName = 'A4 210 x 297 mm' PrinterSetup.PrinterName = 'Screen' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 10000 PrinterSetup.mmMarginLeft = 15000 PrinterSetup.mmMarginRight = 10000 PrinterSetup.mmMarginTop = 10000 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 0 DataPipelineName = 'SuS_alle' object ppDetailBand6: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 5027 mmPrintPosition = 0 object ppSubReport6: TppSubReport UserName = 'SubReport2' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentWidth = False TraverseAllData = False DataPipelineName = 'SuS_Vermallg' mmHeight = 5027 mmLeft = 0 mmTop = 0 mmWidth = 33602 BandType = 4 LayerName = PageLayer3 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport6: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView6.SuS_Vermallg PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = '02_Klassenliste_leftouter_ausgewaehlte_Vermerke_mit_StV_nach_Bem' + 'Art_Datum.rtm' PrinterSetup.PaperName = 'A4 210 x 297 mm' PrinterSetup.PrinterName = 'Screen' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 10000 PrinterSetup.mmMarginLeft = 15000 PrinterSetup.mmMarginRight = 10000 PrinterSetup.mmMarginTop = 10000 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 0 DataPipelineName = 'SuS_Vermallg' object ppDetailBand7: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppSummaryBand4: TppSummaryBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppGroup5: TppGroup BreakName = 'Bezeichnung' DataPipeline = daADOQueryDataView6.SuS_Vermallg GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True ReprintOnSubsequentPage = False StartOnOddPage = False UserName = 'Group4' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'SuS_Vermallg' 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 raCodeModule6: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D65061B 47726F757048656164657242616E64354265666F72655072696E740B50726F67 72616D54797065070B747450726F63656475726506536F7572636506BD70726F 6365647572652047726F757048656164657242616E64354265666F7265507269 6E743B0D0A626567696E0D0A0D0A2020696620706F73285375535F5665726D61 6C6C675B2742657A656963686E756E67275D2C7665726D5F6C697374616C6C67 29203C2031207468656E207665726D5F6C697374616C6C673A3D207665726D5F 6C697374616C6C67202B205375535F5665726D616C6C675B2742657A65696368 6E756E67275D202B20272C20273B0D0A20200D0A656E643B0D0A0D436F6D706F 6E656E744E616D65061047726F757048656164657242616E6435094576656E74 4E616D65060B4265666F72655072696E74074576656E74494402180843617265 74506F730102030205000000} end object ppDesignLayers6: TppDesignLayers object ppDesignLayer6: TppDesignLayer UserName = 'PageLayer2' LayerType = ltBanded Index = 0 end end end end end object ppSummaryBand5: TppSummaryBand Background.Brush.Style = bsClear PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 3704 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' ParentWidth = True Weight = 0.750000000000000000 mmHeight = 2117 mmLeft = 0 mmTop = 0 mmWidth = 185000 BandType = 7 LayerName = PageLayer3 end object ppLabel9: TppLabel UserName = 'Label1' Caption = 'Gew'#228'hlte Vermerkarten:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3704 mmLeft = 3175 mmTop = 0 mmWidth = 35190 BandType = 7 LayerName = PageLayer3 end object ppLine7: TppLine UserName = 'Line7' ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 3704 mmLeft = 0 mmTop = 0 mmWidth = 3704 BandType = 7 LayerName = PageLayer3 end object ppLine8: TppLine UserName = 'Line8' ParentHeight = True Position = lpRight StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 3704 mmLeft = 181240 mmTop = 0 mmWidth = 3704 BandType = 7 LayerName = PageLayer3 end object ppMemo1: TppMemo UserName = 'Memo_vermlist' Caption = 'Memo_vermlist' CharWrap = False Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] Lines.Strings = ( '6 Monate Praxis, Laufbahn-Bemerkung, iPad_neu, 2 Jahre Praxis, B' + 'eurlaubung, Mahnstufe, Abgeschl. Berufsausbildung, Allgemeine_Be' + 'merkung, Eintrag Schulleitung, Entlassung, Mahnstufe2, Mahnung_F' + 'ehlzeiten, Nachpruefung (Ergebnis), Nachpruefung (Faecher), Ordn' + 'ungsma'#223'nahme Fehlzeiten, Vorkursbeleger, iPad_rueck, Zust'#228'ndiges' + ' BAf'#246'G-Amt, Vorgesehene Klasse, Corona_Zulassung, 2.FS, Abmeldun' + 'g, Entlassung wg Fehlzeiten, Ausnahmegenehmigung Arnsberg, Unter' + 'richtsbesuch, FHR_nur, Vorleistung, Anmeldung_Sprachpruefung, Sp' + 'rachfeststellungspr'#252'fung, Corona_Abschluss, Nachteilsausgleich, ' + 'Beschluss der Teilkonferenz, Einladung Teilkonferenz, Mahnstufe1' + ', Glaubhaftmachung, Zweitschrift ausgestellt, Verweis1, NTA_ex, ' + 'Einladung Beratungsgespr'#228'ch') RemoveEmptyLines = False Stretch = True Transparent = True mmHeight = 3704 mmLeft = 39690 mmTop = 0 mmWidth = 144198 BandType = 7 LayerName = PageLayer3 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 mmLeading = 0 end end object raCodeModule7: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650614 4D656D6F5F7665726D6C6973744F6E5072696E740B50726F6772616D54797065 070B747450726F63656475726506536F75726365067B70726F63656475726520 4D656D6F5F7665726D6C6973744F6E5072696E743B0D0A626567696E0D0A0D0A 20204D656D6F5F7665726D6C6973742E746578743A3D20636F7079287665726D 5F6C697374616C6C672C312C6C656E677468287665726D5F6C697374616C6C67 29202D2032293B0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D6506 0D4D656D6F5F7665726D6C697374094576656E744E616D6506074F6E5072696E 74074576656E7449440220084361726574506F730102010201000000} end object ppDesignLayers7: TppDesignLayers object ppDesignLayer7: TppDesignLayer UserName = 'PageLayer3' LayerType = ltBanded Index = 0 end end end end end object ppDetailBand1: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Color = cl3DLight Border.BorderPositions = [bpLeft, bpRight, bpBottom] Border.Visible = True Border.Weight = 0.750000000000000000 PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 9525 mmPrintPosition = 0 object ppLine5: TppLine UserName = 'TrennlinieD2' Pen.Color = 4993567 ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 9525 mmLeft = 10000 mmTop = 0 mmWidth = 1000 BandType = 4 LayerName = Foreground end object ppRegion1: TppRegion UserName = 'r' KeepTogether = True Brush.Style = bsClear Caption = 'r' ParentWidth = True Pen.Color = clWhite Pen.Style = psClear Pen.Width = 0 Stretch = True Transparent = True mmHeight = 9362 mmLeft = 0 mmTop = 0 mmWidth = 185000 BandType = 4 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppDBCalc1: TppDBCalc UserName = 'LaufenderZaehler' Anchors = [atLeft, atRight] DataPipeline = daADOQueryDataView1.SuS Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] ResetGroup = ppGroup2 SuppressRepeatedValues = True TextAlignment = taRightJustified Transparent = True DBCalcType = dcCount DataPipelineName = 'SuS' mmHeight = 3704 mmLeft = 0 mmTop = 1849 mmWidth = 7938 BandType = 4 LayerName = Foreground end object ppSubReport1: TppSubReport UserName = 'Unterbericht' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentWidth = False TraverseAllData = False DataPipelineName = 'SuS_Verm' mmHeight = 5292 mmLeft = 50934 mmTop = 0 mmWidth = 132821 BandType = 4 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport1: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView3.SuS_Verm PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = '02_Klassenliste_leftouter_ausgewaehlte_Vermerke_mit_StV_nach_Bem' + 'Art_Datum.rtm' PrinterSetup.PaperName = 'A4 210 x 297 mm' PrinterSetup.PrinterName = 'Screen' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 10000 PrinterSetup.mmMarginLeft = 15000 PrinterSetup.mmMarginRight = 10000 PrinterSetup.mmMarginTop = 10000 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 0 DataPipelineName = 'SuS_Verm' object ppDetailBand2: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 3704 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'dbTelefonArt1' AutoSize = True DataField = 'Datum' DataPipeline = daADOQueryDataView3.SuS_Verm Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'SuS_Verm' mmHeight = 3440 mmLeft = 123296 mmTop = 0 mmWidth = 8467 BandType = 4 LayerName = Foreground1 end object ppLine12: TppLine UserName = 'L_oben' Pen.Style = psDot Visible = False Weight = 0.750000000000000000 mmHeight = 1852 mmLeft = 5412 mmTop = 0 mmWidth = 126339 BandType = 4 LayerName = Foreground1 end object ppLabel7: TppLabel UserName = 'La_zaehler' AutoSize = False Caption = 'La_zaehler' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3440 mmLeft = 0 mmTop = 132 mmWidth = 3572 BandType = 4 LayerName = Foreground1 end object ppMemo3: TppMemo UserName = 'Memo_VermTxt' Caption = 'Memo_VermTxt' CharWrap = False Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] Lines.Strings = ( 'Kontaktaufnahme bis 20.10. wg. d.Ferien') RemoveEmptyLines = False Stretch = True Transparent = True mmHeight = 3704 mmLeft = 5292 mmTop = 0 mmWidth = 112184 BandType = 4 LayerName = Foreground1 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 mmLeading = 0 end end object ppGroup6: TppGroup BreakName = 'Bezeichnung' DataPipeline = daADOQueryDataView3.SuS_Verm GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False KeepTogether = True OutlineSettings.CreateNode = True StartOnOddPage = False UserName = 'Group6' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'SuS_Verm' NewFile = False object ppGroupHeaderBand6: TppGroupHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 3704 mmPrintPosition = 0 object ppDBText2: TppDBText UserName = 'dbTelefonArt' AutoSize = True DataField = 'Bezeichnung' DataPipeline = daADOQueryDataView3.SuS_Verm Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [fsBold] Transparent = True DataPipelineName = 'SuS_Verm' mmHeight = 3704 mmLeft = 0 mmTop = 0 mmWidth = 16404 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppLine13: TppLine UserName = 'L_top' Weight = 0.750000000000000000 mmHeight = 1852 mmLeft = 0 mmTop = 0 mmWidth = 133615 BandType = 3 GroupNo = 0 LayerName = Foreground1 end end object ppGroupFooterBand6: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object raCodeModule2: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650611 44657461696C4265666F72655072696E740B50726F6772616D54797065070B74 7450726F63656475726506536F757263650C2301000070726F63656475726520 44657461696C4265666F72655072696E743B0D0A766172207478743A20737472 696E673B0D0A0D0A626567696E0D0A0D0A2020696E63287665726D5F7A616568 6C6572293B0D0A20204C615F7A6165686C65722E746578743A3D20696E74746F 737472287665726D5F7A6165686C6572293B200D0A20204C5F6F62656E2E7669 7369626C653A3D207665726D5F7A6165686C6572203C3E20313B0D0A20200D0A 20207478743A3D205375535F5665726D5B2742656D65726B756E67275D3B0D0A 2020696620747874203D202727207468656E207478743A3D20272D206B65696E 2042656D65726B756E677374657874202D273B0D0A20204D656D6F5F5665726D 5478742E746578743A3D207478743B0D0A0D0A656E643B0D0A0D436F6D706F6E 656E744E616D65060644657461696C094576656E744E616D65060B4265666F72 655072696E74074576656E7449440218084361726574506F73010224020B0000 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650616 47726F7570364265666F726547726F7570427265616B0B50726F6772616D5479 7065070B747450726F63656475726506536F75726365068B70726F6365647572 652047726F7570364265666F726547726F7570427265616B3B0D0A626567696E 0D0A0D0A20207665726D5F7A6165686C65723A3D20303B0D0A2020696E632876 65726D6172745F7A6165686C6572293B0D0A20204C5F746F702E76697369626C 653A3D207665726D6172745F7A6165686C6572203C3E20313B0D0A0D0A656E64 3B0D0A0D436F6D706F6E656E744E616D65060647726F757036094576656E744E 616D6506104265666F726547726F7570427265616B074576656E744944021C08 4361726574506F730102280206000000} end object ppDesignLayers2: TppDesignLayers object ppDesignLayer2: TppDesignLayer UserName = 'Foreground1' LayerType = ltBanded Index = 0 end end end end object ppLabel8: TppLabel UserName = 'La_Name' AutoSize = False Caption = 'La_Name' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [fsBold] Transparent = True mmHeight = 3704 mmLeft = 11242 mmTop = 134 mmWidth = 37306 BandType = 4 LayerName = Foreground end object ppLabel10: TppLabel UserName = 'La_Vorname' AutoSize = False Caption = 'La_Vorname' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3704 mmLeft = 12437 mmTop = 3440 mmWidth = 35322 BandType = 4 LayerName = Foreground end end object ppLine4: TppLine UserName = 'TrennlinieD1' Pen.Color = 4993567 ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 9525 mmLeft = 50006 mmTop = 0 mmWidth = 1058 BandType = 4 LayerName = Foreground end end object ppGroup1: TppGroup BreakName = 'Klasse' DataPipeline = daADOQueryDataView1.SuS GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True NewPage = True StartOnOddPage = False UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'SuS' NewFile = False object ppGroupHeaderBand1: TppGroupHeaderBand Background.Brush.Style = bsClear Border.Color = 4993567 Border.Weight = 0.750000000000000000 mmBottomOffset = 0 mmHeight = 10319 mmPrintPosition = 0 object ppLabel3: TppLabel UserName = 'dbListenbezeichnung' AutoSize = False Border.BorderPositions = [bpTop, bpBottom] Border.Color = clGray Border.Visible = True Border.Weight = 2.000000000000000000 Caption = ' Klasse' Color = cl3DLight Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 12 Font.Style = [fsBold] VerticalAlignment = avCenter mmHeight = 8800 mmLeft = 0 mmTop = 660 mmWidth = 184944 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLabel2: TppLabel UserName = 'La_Sem' Caption = 'La_Sem' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 10 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True mmHeight = 3968 mmLeft = 170921 mmTop = 2988 mmWidth = 11113 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppDBText3: TppDBText UserName = 'DBT_StV' AutoSize = True DataField = 'Kuerzel' DataPipeline = daADOQueryDataView4.StvKL Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 10 Font.Style = [fsBold] ParentDataPipeline = False TextAlignment = taCentered Transparent = True DataPipelineName = 'StvKL' mmHeight = 3969 mmLeft = 84667 mmTop = 3041 mmWidth = 10848 BandType = 3 GroupNo = 0 LayerName = Foreground end end object ppGroupFooterBand1: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object ppGroup2: TppGroup BreakName = 'Klasse' DataPipeline = daADOQueryDataView1.SuS GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = False NewPage = True StartOnOddPage = False UserName = 'Group2' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'SuS' NewFile = False object ppGroupHeaderBand2: TppGroupHeaderBand Background.Brush.Style = bsClear Border.BorderPositions = [bpLeft, bpTop, bpRight, bpBottom] Border.Color = clNone Border.Visible = True PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 5292 mmPrintPosition = 0 object ppLine6: TppLine UserName = 'TrennlinieK1' Pen.Color = 4993567 ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 5292 mmLeft = 10000 mmTop = 0 mmWidth = 1000 BandType = 3 GroupNo = 1 LayerName = Foreground end object ppLine3: TppLine UserName = 'TrennlinieK2' Pen.Color = 4993567 ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 5292 mmLeft = 50006 mmTop = 0 mmWidth = 1058 BandType = 3 GroupNo = 1 LayerName = Foreground end object ppLabel6: TppLabel UserName = 'Nr' Anchors = [atLeft, atRight] AutoSize = False Caption = 'Nr' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Calibri' Font.Size = 11 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True mmHeight = 5200 mmLeft = 0 mmTop = 0 mmWidth = 8202 BandType = 3 GroupNo = 1 LayerName = Foreground end object ppLabel4: TppLabel UserName = 'Vermerke' Anchors = [atLeft, atRight] Caption = 'Vermerkart ' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Calibri' Font.Size = 11 Font.Style = [fsBold] Transparent = True mmHeight = 4763 mmLeft = 52123 mmTop = 0 mmWidth = 19579 BandType = 3 GroupNo = 1 LayerName = Foreground end object ppLabel1: TppLabel UserName = 'NameVorname' Anchors = [atLeft, atRight] AutoSize = False Caption = 'Name, Vorname' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Calibri' Font.Size = 11 Font.Style = [fsBold] Transparent = True mmHeight = 5292 mmLeft = 11643 mmTop = 0 mmWidth = 37630 BandType = 3 GroupNo = 1 LayerName = Foreground end object ppLabel5: TppLabel UserName = 'Vermerke1' Anchors = [atLeft, atRight] Caption = 'Datum' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Calibri' Font.Size = 11 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True mmHeight = 4763 mmLeft = 171450 mmTop = 1 mmWidth = 10848 BandType = 3 GroupNo = 1 LayerName = Foreground end object ppLabel12: TppLabel UserName = 'Label12' Caption = 'Bemerkungstext' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3704 mmLeft = 73025 mmTop = 529 mmWidth = 23019 BandType = 3 GroupNo = 1 LayerName = Foreground 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_SuS' Height = 544 Left = 16 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 43 TypeColumnWidth = 52 Width = 373 AutoSearchTabOrder = 0 object SuS: TppChildDBPipeline AutoCreateFields = False UserName = 'SuS' object ppField1: TppField FieldAlias = 'AktAbschnitt' FieldName = 'AktAbschnitt' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'Schueler' end object ppField2: TppField FieldAlias = 'AktSchuljahr' FieldName = 'AktSchuljahr' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 1 TableName = 'Schueler' end object ppField3: TppField FieldAlias = 'ASDJahrgang' FieldName = 'ASDJahrgang' FieldLength = 2 DisplayWidth = 2 Position = 2 TableName = 'Schueler' end object ppField4: TppField FieldAlias = 'ASDSchulform' FieldName = 'ASDSchulform' FieldLength = 3 DisplayWidth = 3 Position = 3 TableName = 'Schueler' end object ppField5: TppField FieldAlias = 'Geloescht' FieldName = 'Geloescht' FieldLength = 1 DisplayWidth = 1 Position = 4 TableName = 'Schueler' end object ppField6: TppField FieldAlias = 'Geschlecht' FieldName = 'Geschlecht' FieldLength = 0 DataType = dtLongint DisplayWidth = 10 Position = 5 TableName = 'Schueler' end object ppField7: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 6 TableName = 'Schueler' end object ppField8: TppField FieldAlias = 'Klasse' FieldName = 'Klasse' FieldLength = 6 DisplayWidth = 6 Position = 7 TableName = 'Schueler' end object ppField9: TppField FieldAlias = 'Lehrer' FieldName = 'Lehrer' FieldLength = 10 DisplayWidth = 10 Position = 8 TableName = 'Schueler' end object ppField10: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 50 DisplayWidth = 50 Position = 9 TableName = 'Schueler' end object ppField11: TppField FieldAlias = 'Telefon' FieldName = 'Telefon' FieldLength = 20 DisplayWidth = 20 Position = 10 TableName = 'Schueler' end object ppField12: TppField FieldAlias = 'Volljaehrig' FieldName = 'Volljaehrig' FieldLength = 1 DisplayWidth = 1 Position = 11 TableName = 'Schueler' end object ppField13: TppField FieldAlias = 'Vorname' FieldName = 'Vorname' FieldLength = 30 DisplayWidth = 30 Position = 12 TableName = 'Schueler' end object ppField14: TppField FieldAlias = 'Anrede' FieldName = 'Anrede' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 13 TableName = 'K_Lehrer' end object ppField15: TppField FieldAlias = 'Faecher' FieldName = 'Faecher' FieldLength = 100 IsDetail = True DisplayWidth = 100 Position = 14 TableName = 'K_Lehrer' end object ppField16: TppField FieldAlias = 'Amtsbezeichnung' FieldName = 'Amtsbezeichnung' FieldLength = 15 IsDetail = True DisplayWidth = 15 Position = 15 TableName = 'K_Lehrer' end object ppField17: TppField FieldAlias = 'Geburtsdatum' FieldName = 'Geburtsdatum' FieldLength = 0 IsDetail = True DataType = dtDateTime DisplayWidth = 18 Position = 16 TableName = 'K_Lehrer' end object ppField18: TppField FieldAlias = 'Geschlecht (2)' FieldName = 'Geschlecht_2' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 17 TableName = 'K_Lehrer' end object ppField19: TppField FieldAlias = 'ID (2)' FieldName = 'ID_2' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 18 TableName = 'K_Lehrer' end object ppField20: TppField FieldAlias = 'GU_ID' FieldName = 'GU_ID' FieldLength = 40 IsDetail = True DisplayWidth = 40 Position = 19 TableName = 'K_Lehrer' end object ppField21: TppField FieldAlias = 'Kuerzel' FieldName = 'Kuerzel' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 20 TableName = 'K_Lehrer' end object ppField22: TppField FieldAlias = 'Lehramt' FieldName = 'Lehramt' FieldLength = 4 IsDetail = True DisplayWidth = 4 Position = 21 TableName = 'K_Lehrer' end object ppField23: TppField FieldAlias = 'Nachname' FieldName = 'Nachname' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 22 TableName = 'K_Lehrer' end object ppField24: TppField FieldAlias = 'Tel' FieldName = 'Tel' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 23 TableName = 'K_Lehrer' end object ppField25: TppField FieldAlias = 'Titel' FieldName = 'Titel' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 24 TableName = 'K_Lehrer' end object ppField26: TppField FieldAlias = 'Vorname (2)' FieldName = 'Vorname_2' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 25 TableName = 'K_Lehrer' end end object daSQL1: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'SuS' IsCaseSensitive = True LinkColor = clMaroon LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Schueler.AktAbschnitt, ' ' Schueler.AktSchuljahr, ' ' Schueler.ASDJahrgang, ' ' Schueler.ASDSchulform, Schueler.Geloescht, ' ' Schueler.Geschlecht, Schueler.ID, ' ' Schueler.Klasse, Schueler.Lehrer, ' ' Schueler.Name, Schueler.Telefon, ' ' Schueler.Volljaehrig, Schueler.Vorname, ' ' K_Lehrer.Anrede, K_Lehrer.Faecher, ' ' K_Lehrer.Amtsbezeichnung, ' ' K_Lehrer.Geburtsdatum, ' ' K_Lehrer.Geschlecht AS Geschlecht_2, ' ' K_Lehrer.ID AS ID_2, K_Lehrer.GU_ID, ' ' K_Lehrer.Kuerzel, K_Lehrer.Lehramt, ' ' K_Lehrer.Nachname, K_Lehrer.Tel, ' ' K_Lehrer.Titel, ' ' K_Lehrer.Vorname AS Vorname_2' 'FROM (Schueler Schueler' ' INNER JOIN K_Lehrer K_Lehrer ON ' ' (K_Lehrer.Kuerzel = Schueler.Lehrer) )' 'WHERE ( Schueler.Status IN (2,6) )' ' AND ( Schueler.Geloescht <> '#39'+'#39' )' 'ORDER BY Schueler.Klasse, Schueler.Name, ' ' Schueler.Vorname') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList Value = '2,6' 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 object TdaNumericValue Value = 6.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 = 'Klassenwahl' 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 = 'AktAbschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'AktAbschnitt' FieldLength = 0 FieldName = 'AktAbschnitt' SQLFieldName = 'AktAbschnitt' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField2: TdaField Alias = 'AktSchuljahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'AktSchuljahr' FieldLength = 0 FieldName = 'AktSchuljahr' SQLFieldName = 'AktSchuljahr' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField3: TdaField Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' SQLFieldName = 'ASDJahrgang' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField4: TdaField Alias = 'ASDSchulform' DisplayWidth = 3 FieldAlias = 'ASDSchulform' FieldLength = 3 FieldName = 'ASDSchulform' SQLFieldName = 'ASDSchulform' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField5: TdaField Alias = 'Geloescht' DisplayWidth = 1 FieldAlias = 'Geloescht' FieldLength = 1 FieldName = 'Geloescht' SQLFieldName = 'Geloescht' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField6: TdaField Alias = 'Geschlecht' DataType = dtLongint DisplayWidth = 10 FieldAlias = 'Geschlecht' FieldLength = 0 FieldName = 'Geschlecht' SQLFieldName = 'Geschlecht' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField7: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField8: TdaField Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField9: TdaField Alias = 'Lehrer' DisplayWidth = 10 FieldAlias = 'Lehrer' FieldLength = 10 FieldName = 'Lehrer' SQLFieldName = 'Lehrer' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField10: TdaField Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField11: TdaField Alias = 'Telefon' DisplayWidth = 20 FieldAlias = 'Telefon' FieldLength = 20 FieldName = 'Telefon' SQLFieldName = 'Telefon' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField12: TdaField Alias = 'Volljaehrig' DisplayWidth = 1 FieldAlias = 'Volljaehrig' FieldLength = 1 FieldName = 'Volljaehrig' SQLFieldName = 'Volljaehrig' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField13: TdaField Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField14: TdaField Alias = 'Anrede' DisplayWidth = 10 FieldAlias = 'Anrede' FieldLength = 10 FieldName = 'Anrede' IsDetail = True SQLFieldName = 'Anrede' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField15: TdaField Alias = 'Faecher' DisplayWidth = 100 FieldAlias = 'Faecher' FieldLength = 100 FieldName = 'Faecher' IsDetail = True SQLFieldName = 'Faecher' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField16: TdaField Alias = 'Amtsbezeichnung' DisplayWidth = 15 FieldAlias = 'Amtsbezeichnung' FieldLength = 15 FieldName = 'Amtsbezeichnung' IsDetail = True SQLFieldName = 'Amtsbezeichnung' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField17: TdaField Alias = 'Geburtsdatum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Geburtsdatum' FieldLength = 0 FieldName = 'Geburtsdatum' IsDetail = True SQLFieldName = 'Geburtsdatum' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField18: TdaField Alias = 'Geschlecht (2)' DisplayWidth = 1 FieldAlias = 'Geschlecht' FieldLength = 1 FieldName = 'Geschlecht' IsDetail = True SQLFieldName = 'Geschlecht_2' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField19: 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 daField20: TdaField Alias = 'GU_ID' DisplayWidth = 40 FieldAlias = 'GU_ID' FieldLength = 40 FieldName = 'GU_ID' IsDetail = True SQLFieldName = 'GU_ID' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField21: 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 daField22: TdaField Alias = 'Lehramt' DisplayWidth = 4 FieldAlias = 'Lehramt' FieldLength = 4 FieldName = 'Lehramt' IsDetail = True SQLFieldName = 'Lehramt' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField23: 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 daField24: TdaField Alias = 'Tel' DisplayWidth = 20 FieldAlias = 'Tel' FieldLength = 20 FieldName = 'Tel' IsDetail = True SQLFieldName = 'Tel' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField25: TdaField Alias = 'Titel' DisplayWidth = 20 FieldAlias = 'Titel' FieldLength = 20 FieldName = 'Titel' IsDetail = True SQLFieldName = 'Titel' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField26: TdaField Alias = 'Vorname (2)' DisplayWidth = 20 FieldAlias = 'Vorname' FieldLength = 20 FieldName = 'Vorname' IsDetail = True SQLFieldName = 'Vorname_2' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField27: TdaField ChildType = 2 Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField28: TdaField ChildType = 2 Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField29: TdaField ChildType = 2 Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daTable1: TdaTable ChildType = 5 Alias = 'Schueler' JoinType = dajtNone SQLAlias = 'Schueler' TableAlias = 'Schueler' TableName = 'Schueler' end object daTable2: TdaTable ChildType = 5 Alias = 'K_Lehrer' SQLAlias = 'K_Lehrer' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' object daTableJoin1: TdaTableJoin ChildType = 6 object daField31: 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 daField30: TdaField ChildType = 4 Alias = 'Lehrer' DisplayWidth = 10 FieldAlias = 'Lehrer' FieldLength = 10 FieldName = 'Lehrer' SQLFieldName = 'Lehrer' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end end end end object daADOQueryDataView3: TdaADOQueryDataView UserName = 'Query_SuS_Verm' Height = 336 Left = 466 NameColumnWidth = 190 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 315 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_SuS' object SuS_Verm: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'SuS_Verm' MasterDataPipelineName = 'SuS' object ppField1: TppField FieldAlias = 'AngelegtVon' FieldName = 'AngelegtVon' FieldLength = 20 DisplayWidth = 20 Position = 0 TableName = 'SchuelerVermerke' end object ppField2: TppField FieldAlias = 'Bemerkung' FieldName = 'Bemerkung' FieldLength = 0 Linkable = False DataType = dtMemo DisplayWidth = 10 Position = 1 TableName = 'SchuelerVermerke' end object ppField3: TppField FieldAlias = 'Datum' FieldName = 'Datum' FieldLength = 0 DataType = dtDateTime DisplayWidth = 18 Position = 2 TableName = 'SchuelerVermerke' end object ppField4: TppField FieldAlias = 'GeaendertVon' FieldName = 'GeaendertVon' FieldLength = 20 DisplayWidth = 20 Position = 3 TableName = 'SchuelerVermerke' end object ppField5: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 4 TableName = 'SchuelerVermerke' end object ppField6: TppField FieldAlias = 'Schueler_ID' FieldName = 'Schueler_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 5 TableName = 'SchuelerVermerke' end object ppField7: TppField FieldAlias = 'SchulnrEigner' FieldName = 'SchulnrEigner' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 6 TableName = 'SchuelerVermerke' end object ppField8: TppField FieldAlias = 'VermerkArt_ID' FieldName = 'VermerkArt_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 7 TableName = 'SchuelerVermerke' end object ppField9: TppField FieldAlias = 'Bezeichnung' FieldName = 'Bezeichnung' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 8 TableName = 'K_VermerkArt' end object ppField10: TppField FieldAlias = 'ID (2)' FieldName = 'ID_2' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 9 TableName = 'K_VermerkArt' end object ppField11: TppField FieldAlias = 'Sortierung' FieldName = 'Sortierung' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 10 TableName = 'K_VermerkArt' end object ppField12: TppField FieldAlias = 'Sichtbar' FieldName = 'Sichtbar' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 11 TableName = 'K_VermerkArt' 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 = 'ID' GuidCollationType = gcMSAccess DetailFieldName = 'Schueler_ID' DetailSortOrder = soAscending IsCaseSensitive = True end end object daSQL3: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'SuS_Verm' IsCaseSensitive = True LinkColor = clGreen LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT SchuelerVermerke.AngelegtVon, ' ' SchuelerVermerke.Bemerkung, ' ' SchuelerVermerke.Datum, ' ' SchuelerVermerke.GeaendertVon, ' ' SchuelerVermerke.ID, ' ' SchuelerVermerke.Schueler_ID, ' ' SchuelerVermerke.SchulnrEigner, ' ' SchuelerVermerke.VermerkArt_ID, ' ' K_VermerkArt.Bezeichnung, ' ' K_VermerkArt.ID AS ID_2, ' ' K_VermerkArt.Sortierung, ' ' K_VermerkArt.Sichtbar' 'FROM (SchuelerVermerke SchuelerVermerke' ' INNER JOIN K_VermerkArt K_VermerkArt ON ' ' (K_VermerkArt.ID = SchuelerVermerke.VermerkArt_ID) )' 'ORDER BY K_VermerkArt.Bezeichnung, ' ' SchuelerVermerke.Datum') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'Verm_Art' object TdaField Alias = 'Bezeichnung' DisplayWidth = 30 FieldAlias = 'Bezeichnung' FieldLength = 30 FieldName = 'Bezeichnung' ShowAllValues = True SQLFieldName = 'Bezeichnung' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end end object daField1: TdaField Alias = 'AngelegtVon' DisplayWidth = 20 FieldAlias = 'AngelegtVon' FieldLength = 20 FieldName = 'AngelegtVon' SQLFieldName = 'AngelegtVon' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField2: TdaField Alias = 'Bemerkung' DataType = dtMemo DisplayWidth = 10 FieldAlias = 'Bemerkung' FieldLength = 0 FieldName = 'Bemerkung' Linkable = False SQLFieldName = 'Bemerkung' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField3: TdaField Alias = 'Datum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Datum' FieldLength = 0 FieldName = 'Datum' SQLFieldName = 'Datum' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField4: TdaField Alias = 'GeaendertVon' DisplayWidth = 20 FieldAlias = 'GeaendertVon' FieldLength = 20 FieldName = 'GeaendertVon' SQLFieldName = 'GeaendertVon' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField5: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField6: TdaField Alias = 'Schueler_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schueler_ID' FieldLength = 0 FieldName = 'Schueler_ID' SQLFieldName = 'Schueler_ID' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField7: TdaField Alias = 'SchulnrEigner' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'SchulnrEigner' FieldLength = 0 FieldName = 'SchulnrEigner' SQLFieldName = 'SchulnrEigner' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField8: TdaField Alias = 'VermerkArt_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'VermerkArt_ID' FieldLength = 0 FieldName = 'VermerkArt_ID' SQLFieldName = 'VermerkArt_ID' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField9: TdaField Alias = 'Bezeichnung' DisplayWidth = 30 FieldAlias = 'Bezeichnung' FieldLength = 30 FieldName = 'Bezeichnung' IsDetail = True SQLFieldName = 'Bezeichnung' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end object daField10: TdaField Alias = 'ID (2)' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' IsDetail = True SQLFieldName = 'ID_2' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end object daField11: TdaField Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' IsDetail = True SQLFieldName = 'Sortierung' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end object daField12: TdaField Alias = 'Sichtbar' DisplayWidth = 1 FieldAlias = 'Sichtbar' FieldLength = 1 FieldName = 'Sichtbar' IsDetail = True SQLFieldName = 'Sichtbar' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end object daField13: TdaField ChildType = 2 Alias = 'Bezeichnung' DisplayWidth = 30 FieldAlias = 'Bezeichnung' FieldLength = 30 FieldName = 'Bezeichnung' SQLFieldName = 'Bezeichnung' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end object daField14: TdaField ChildType = 2 Alias = 'Datum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Datum' FieldLength = 0 FieldName = 'Datum' SQLFieldName = 'Datum' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daTable1: TdaTable ChildType = 5 Alias = 'SchuelerVermerke' JoinType = dajtNone SQLAlias = 'SchuelerVermerke' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' end object daTable2: TdaTable ChildType = 5 Alias = 'K_VermerkArt' SQLAlias = 'K_VermerkArt' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' object daTableJoin1: TdaTableJoin ChildType = 6 object daField16: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end object daField15: TdaField ChildType = 4 Alias = 'VermerkArt_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'VermerkArt_ID' FieldLength = 0 FieldName = 'VermerkArt_ID' SQLFieldName = 'VermerkArt_ID' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end end end object TdaSQLLink ChildType = 9 object daField17: TdaField ChildType = 10 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField18: TdaField ChildType = 11 Alias = 'Schueler_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schueler_ID' FieldLength = 0 FieldName = 'Schueler_ID' SQLFieldName = 'Schueler_ID' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end end end end object daADOQueryDataView2: TdaADOQueryDataView UserName = 'Query_' Height = 514 Left = 1223 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 346 TypeColumnWidth = 52 Width = 487 AutoSearchTabOrder = 0 object KuK: TppChildDBPipeline AutoCreateFields = False UserName = 'KuK' object ppField1: TppField FieldAlias = 'Aenderbar' FieldName = 'Aenderbar' FieldLength = 1 DisplayWidth = 1 Position = 0 TableName = 'K_Lehrer' end object ppField2: TppField FieldAlias = 'Amtsbezeichnung' FieldName = 'Amtsbezeichnung' FieldLength = 15 DisplayWidth = 15 Position = 1 TableName = 'K_Lehrer' end object ppField3: TppField FieldAlias = 'AnrechnungStd' FieldName = 'AnrechnungStd' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 2 TableName = 'K_Lehrer' end object ppField4: TppField FieldAlias = 'Anrede' FieldName = 'Anrede' FieldLength = 10 DisplayWidth = 10 Position = 3 TableName = 'K_Lehrer' end object ppField5: TppField FieldAlias = 'Antwort1' FieldName = 'Antwort1' FieldLength = 255 DisplayWidth = 255 Position = 4 TableName = 'K_Lehrer' end object ppField6: TppField FieldAlias = 'Antwort2' FieldName = 'Antwort2' FieldLength = 255 DisplayWidth = 255 Position = 5 TableName = 'K_Lehrer' end object ppField7: TppField FieldAlias = 'Beschaeftigungsart' FieldName = 'Beschaeftigungsart' FieldLength = 2 DisplayWidth = 2 Position = 6 TableName = 'K_Lehrer' end object ppField8: TppField FieldAlias = 'DatumAbgang' FieldName = 'DatumAbgang' FieldLength = 0 DataType = dtDateTime DisplayWidth = 18 Position = 7 TableName = 'K_Lehrer' end object ppField9: TppField FieldAlias = 'DatumZugang' FieldName = 'DatumZugang' FieldLength = 0 DataType = dtDateTime DisplayWidth = 18 Position = 8 TableName = 'K_Lehrer' end object ppField10: TppField FieldAlias = 'Einsatzstatus' FieldName = 'Einsatzstatus' FieldLength = 1 DisplayWidth = 1 Position = 9 TableName = 'K_Lehrer' end object ppField11: TppField FieldAlias = 'Email' FieldName = 'Email' FieldLength = 100 DisplayWidth = 100 Position = 10 TableName = 'K_Lehrer' end object ppField12: TppField FieldAlias = 'EMailDienstlich' FieldName = 'EMailDienstlich' FieldLength = 100 DisplayWidth = 100 Position = 11 TableName = 'K_Lehrer' end object ppField13: TppField FieldAlias = 'EntlastungStd' FieldName = 'EntlastungStd' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 12 TableName = 'K_Lehrer' end object ppField14: TppField FieldAlias = 'ErmGrund' FieldName = 'ErmGrund' FieldLength = 2 DisplayWidth = 2 Position = 13 TableName = 'K_Lehrer' end object ppField15: TppField FieldAlias = 'ErmStd' FieldName = 'ErmStd' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 14 TableName = 'K_Lehrer' end object ppField16: TppField FieldAlias = 'ErtUnterrichtLID' FieldName = 'ErtUnterrichtLID' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 15 TableName = 'K_Lehrer' end object ppField17: TppField FieldAlias = 'ErtUnterrichtUVD' FieldName = 'ErtUnterrichtUVD' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 16 TableName = 'K_Lehrer' end object ppField18: TppField FieldAlias = 'Fachrichtung' FieldName = 'Fachrichtung' FieldLength = 2 DisplayWidth = 2 Position = 17 TableName = 'K_Lehrer' end object ppField19: TppField FieldAlias = 'Faecher' FieldName = 'Faecher' FieldLength = 100 DisplayWidth = 100 Position = 18 TableName = 'K_Lehrer' end object ppField20: TppField FieldAlias = 'FRQualifikation' FieldName = 'FRQualifikation' FieldLength = 1 DisplayWidth = 1 Position = 19 TableName = 'K_Lehrer' end object ppField21: TppField FieldAlias = 'FuerExport' FieldName = 'FuerExport' FieldLength = 1 DisplayWidth = 1 Position = 20 TableName = 'K_Lehrer' end object ppField22: TppField FieldAlias = 'FWStd' FieldName = 'FWStd' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 21 TableName = 'K_Lehrer' end object ppField23: TppField FieldAlias = 'FWStufe' FieldName = 'FWStufe' FieldLength = 2 DisplayWidth = 2 Position = 22 TableName = 'K_Lehrer' end object ppField24: TppField FieldAlias = 'Geburtsdatum' FieldName = 'Geburtsdatum' FieldLength = 0 DataType = dtDateTime DisplayWidth = 18 Position = 23 TableName = 'K_Lehrer' end object ppField25: TppField FieldAlias = 'Geschlecht' FieldName = 'Geschlecht' FieldLength = 1 DisplayWidth = 1 Position = 24 TableName = 'K_Lehrer' end object ppField26: TppField FieldAlias = 'GrundAbgang' FieldName = 'GrundAbgang' FieldLength = 10 DisplayWidth = 10 Position = 25 TableName = 'K_Lehrer' end object ppField27: TppField FieldAlias = 'GrundZugang' FieldName = 'GrundZugang' FieldLength = 10 DisplayWidth = 10 Position = 26 TableName = 'K_Lehrer' end object ppField28: TppField FieldAlias = 'GU_ID' FieldName = 'GU_ID' FieldLength = 40 DisplayWidth = 40 Position = 27 TableName = 'K_Lehrer' end object ppField29: TppField FieldAlias = 'Handy' FieldName = 'Handy' FieldLength = 20 DisplayWidth = 20 Position = 28 TableName = 'K_Lehrer' end object ppField30: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 29 TableName = 'K_Lehrer' end object ppField31: TppField FieldAlias = 'IdentNr1' FieldName = 'IdentNr1' FieldLength = 10 DisplayWidth = 10 Position = 30 TableName = 'K_Lehrer' end object ppField32: TppField FieldAlias = 'KennwortTools' FieldName = 'KennwortTools' FieldLength = 255 DisplayWidth = 255 Position = 31 TableName = 'K_Lehrer' end object ppField33: TppField FieldAlias = 'KennwortToolsAktuell' FieldName = 'KennwortToolsAktuell' FieldLength = 1 DisplayWidth = 1 Position = 32 TableName = 'K_Lehrer' end object ppField34: TppField FieldAlias = 'Kuerzel' FieldName = 'Kuerzel' FieldLength = 10 DisplayWidth = 10 Position = 33 TableName = 'K_Lehrer' end object ppField35: TppField FieldAlias = 'LBQualifikation' FieldName = 'LBQualifikation' FieldLength = 1 DisplayWidth = 1 Position = 34 TableName = 'K_Lehrer' end object ppField36: TppField FieldAlias = 'LBVNr' FieldName = 'LBVNr' FieldLength = 15 DisplayWidth = 15 Position = 35 TableName = 'K_Lehrer' end object ppField37: TppField FieldAlias = 'Lehramt' FieldName = 'Lehramt' FieldLength = 4 DisplayWidth = 4 Position = 36 TableName = 'K_Lehrer' end object ppField38: TppField FieldAlias = 'Lehrbefaehigung' FieldName = 'Lehrbefaehigung' FieldLength = 2 DisplayWidth = 2 Position = 37 TableName = 'K_Lehrer' end object ppField39: TppField FieldAlias = 'LIDKrz' FieldName = 'LIDKrz' FieldLength = 4 DisplayWidth = 4 Position = 38 TableName = 'K_Lehrer' end object ppField40: TppField FieldAlias = 'LPassword' FieldName = 'LPassword' FieldLength = 255 DisplayWidth = 255 Position = 39 TableName = 'K_Lehrer' end object ppField41: TppField FieldAlias = 'Mehrarbeit' FieldName = 'Mehrarbeit' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 40 TableName = 'K_Lehrer' end object ppField42: TppField FieldAlias = 'MehrleistungStd' FieldName = 'MehrleistungStd' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 41 TableName = 'K_Lehrer' end object ppField43: TppField FieldAlias = 'Nachname' FieldName = 'Nachname' FieldLength = 30 DisplayWidth = 30 Position = 42 TableName = 'K_Lehrer' end object ppField44: TppField FieldAlias = 'PANr' FieldName = 'PANr' FieldLength = 20 DisplayWidth = 20 Position = 43 TableName = 'K_Lehrer' end object ppField45: TppField FieldAlias = 'PersonTyp' FieldName = 'PersonTyp' FieldLength = 20 DisplayWidth = 20 Position = 44 TableName = 'K_Lehrer' end object ppField46: TppField FieldAlias = 'PflichtstdSoll' FieldName = 'PflichtstdSoll' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 45 TableName = 'K_Lehrer' end object ppField47: TppField FieldAlias = 'PLZ' FieldName = 'PLZ' FieldLength = 10 DisplayWidth = 10 Position = 46 TableName = 'K_Lehrer' end object ppField48: TppField FieldAlias = 'PWAktuell' FieldName = 'PWAktuell' FieldLength = 3 DisplayWidth = 3 Position = 47 TableName = 'K_Lehrer' end object ppField49: TppField FieldAlias = 'Rechtsverhaeltnis' FieldName = 'Rechtsverhaeltnis' FieldLength = 1 DisplayWidth = 1 Position = 48 TableName = 'K_Lehrer' end object ppField50: TppField FieldAlias = 'RestStd' FieldName = 'RestStd' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 49 TableName = 'K_Lehrer' end object ppField51: TppField FieldAlias = 'SchILDweb_Config' FieldName = 'SchILDweb_Config' FieldLength = 0 Linkable = False DataType = dtMemo DisplayWidth = 10 Position = 50 TableName = 'K_Lehrer' end object ppField52: TppField FieldAlias = 'SchILDweb_FL' FieldName = 'SchILDweb_FL' FieldLength = 1 DisplayWidth = 1 Position = 51 TableName = 'K_Lehrer' end object ppField53: TppField FieldAlias = 'SchILDweb_KL' FieldName = 'SchILDweb_KL' FieldLength = 1 DisplayWidth = 1 Position = 52 TableName = 'K_Lehrer' end object ppField54: TppField FieldAlias = 'SchulFunktion' FieldName = 'SchulFunktion' FieldLength = 10 DisplayWidth = 10 Position = 53 TableName = 'K_Lehrer' end object ppField55: TppField FieldAlias = 'SchulnrEigner' FieldName = 'SchulnrEigner' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 54 TableName = 'K_Lehrer' end object ppField56: TppField FieldAlias = 'SerNr' FieldName = 'SerNr' FieldLength = 5 DisplayWidth = 5 Position = 55 TableName = 'K_Lehrer' end object ppField57: TppField FieldAlias = 'Sichtbar' FieldName = 'Sichtbar' FieldLength = 1 DisplayWidth = 1 Position = 56 TableName = 'K_Lehrer' end object ppField58: TppField FieldAlias = 'Sortierung' FieldName = 'Sortierung' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 57 TableName = 'K_Lehrer' end object ppField59: TppField FieldAlias = 'StaatKrz' FieldName = 'StaatKrz' FieldLength = 3 DisplayWidth = 3 Position = 58 TableName = 'K_Lehrer' end object ppField60: TppField FieldAlias = 'StammschulNr' FieldName = 'StammschulNr' FieldLength = 6 DisplayWidth = 6 Position = 59 TableName = 'K_Lehrer' end object ppField61: TppField FieldAlias = 'Statistik' FieldName = 'Statistik' FieldLength = 1 DisplayWidth = 1 Position = 60 TableName = 'K_Lehrer' end object ppField62: TppField FieldAlias = 'Strasse' FieldName = 'Strasse' FieldLength = 50 DisplayWidth = 50 Position = 61 TableName = 'K_Lehrer' end object ppField63: TppField FieldAlias = 'Tel' FieldName = 'Tel' FieldLength = 20 DisplayWidth = 20 Position = 62 TableName = 'K_Lehrer' end object ppField64: TppField FieldAlias = 'Titel' FieldName = 'Titel' FieldLength = 20 DisplayWidth = 20 Position = 63 TableName = 'K_Lehrer' end object ppField65: TppField FieldAlias = 'UnterrichtsStd' FieldName = 'UnterrichtsStd' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 64 TableName = 'K_Lehrer' end object ppField66: TppField FieldAlias = 'Vorname' FieldName = 'Vorname' FieldLength = 20 DisplayWidth = 20 Position = 65 TableName = 'K_Lehrer' end object ppField67: TppField FieldAlias = 'VSchluessel' FieldName = 'VSchluessel' FieldLength = 1 DisplayWidth = 1 Position = 66 TableName = 'K_Lehrer' end object ppField68: TppField FieldAlias = 'ZuvielErtGrund' FieldName = 'ZuvielErtGrund' FieldLength = 2 DisplayWidth = 2 Position = 67 TableName = 'K_Lehrer' end object ppField69: TppField FieldAlias = 'ZuvielErtStd' FieldName = 'ZuvielErtStd' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 68 TableName = 'K_Lehrer' end object ppField70: TppField FieldAlias = 'ZuwenigErtGrund' FieldName = 'ZuwenigErtGrund' FieldLength = 2 DisplayWidth = 2 Position = 69 TableName = 'K_Lehrer' end object ppField71: TppField FieldAlias = 'ZuwenigErtStd' FieldName = 'ZuwenigErtStd' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 70 TableName = 'K_Lehrer' end end object daSQL1: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'KuK' IsCaseSensitive = True LinkColor = clMaroon LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT K_Lehrer.Aenderbar, ' ' K_Lehrer.Amtsbezeichnung, ' ' K_Lehrer.AnrechnungStd, K_Lehrer.Anrede, ' ' K_Lehrer.Antwort1, K_Lehrer.Antwort2, ' ' K_Lehrer.Beschaeftigungsart, ' ' K_Lehrer.DatumAbgang, ' ' K_Lehrer.DatumZugang, ' ' K_Lehrer.Einsatzstatus, K_Lehrer.Email, ' ' K_Lehrer.EMailDienstlich, ' ' K_Lehrer.EntlastungStd, K_Lehrer.ErmGrund, ' ' K_Lehrer.ErmStd, ' ' K_Lehrer.ErtUnterrichtLID, ' ' K_Lehrer.ErtUnterrichtUVD, ' ' K_Lehrer.Fachrichtung, K_Lehrer.Faecher, ' ' K_Lehrer.FRQualifikation, ' ' K_Lehrer.FuerExport, K_Lehrer.FWStd, ' ' K_Lehrer.FWStufe, K_Lehrer.Geburtsdatum, ' ' K_Lehrer.Geschlecht, K_Lehrer.GrundAbgang, ' ' K_Lehrer.GrundZugang, K_Lehrer.GU_ID, ' ' K_Lehrer.Handy, K_Lehrer.ID, ' ' K_Lehrer.IdentNr1, K_Lehrer.KennwortTools, ' ' K_Lehrer.KennwortToolsAktuell, ' ' K_Lehrer.Kuerzel, ' ' K_Lehrer.LBQualifikation, K_Lehrer.LBVNr, ' ' K_Lehrer.Lehramt, ' ' K_Lehrer.Lehrbefaehigung, K_Lehrer.LIDKrz, ' ' K_Lehrer.LPassword, K_Lehrer.Mehrarbeit, ' ' K_Lehrer.MehrleistungStd, ' ' K_Lehrer.Nachname, K_Lehrer.PANr, ' ' K_Lehrer.PersonTyp, ' ' K_Lehrer.PflichtstdSoll, K_Lehrer.PLZ, ' ' K_Lehrer.PWAktuell, ' ' K_Lehrer.Rechtsverhaeltnis, ' ' K_Lehrer.RestStd, ' ' K_Lehrer.SchILDweb_Config, ' ' K_Lehrer.SchILDweb_FL, ' ' K_Lehrer.SchILDweb_KL, ' ' K_Lehrer.SchulFunktion, ' ' K_Lehrer.SchulnrEigner, K_Lehrer.SerNr, ' ' K_Lehrer.Sichtbar, K_Lehrer.Sortierung, ' ' K_Lehrer.StaatKrz, K_Lehrer.StammschulNr, ' ' K_Lehrer.Statistik, K_Lehrer.Strasse, ' ' K_Lehrer.Tel, K_Lehrer.Titel, ' ' K_Lehrer.UnterrichtsStd, K_Lehrer.Vorname, ' ' K_Lehrer.VSchluessel, ' ' K_Lehrer.ZuvielErtGrund, ' ' K_Lehrer.ZuvielErtStd, ' ' K_Lehrer.ZuwenigErtGrund, ' ' K_Lehrer.ZuwenigErtStd' 'FROM K_Lehrer K_Lehrer' 'WHERE ( K_Lehrer.Sichtbar = '#39'+'#39' )') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Value = '+' object TdaField Alias = 'Sichtbar' DisplayWidth = 1 FieldAlias = 'Sichtbar' FieldLength = 1 FieldName = 'Sichtbar' SQLFieldName = 'Sichtbar' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end end object daField1: TdaField Alias = 'Aenderbar' DisplayWidth = 1 FieldAlias = 'Aenderbar' FieldLength = 1 FieldName = 'Aenderbar' SQLFieldName = 'Aenderbar' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField2: TdaField Alias = 'Amtsbezeichnung' DisplayWidth = 15 FieldAlias = 'Amtsbezeichnung' FieldLength = 15 FieldName = 'Amtsbezeichnung' SQLFieldName = 'Amtsbezeichnung' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField3: TdaField Alias = 'AnrechnungStd' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'AnrechnungStd' FieldLength = 0 FieldName = 'AnrechnungStd' SQLFieldName = 'AnrechnungStd' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField4: TdaField Alias = 'Anrede' DisplayWidth = 10 FieldAlias = 'Anrede' FieldLength = 10 FieldName = 'Anrede' SQLFieldName = 'Anrede' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField5: TdaField Alias = 'Antwort1' DisplayWidth = 255 FieldAlias = 'Antwort1' FieldLength = 255 FieldName = 'Antwort1' SQLFieldName = 'Antwort1' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField6: TdaField Alias = 'Antwort2' DisplayWidth = 255 FieldAlias = 'Antwort2' FieldLength = 255 FieldName = 'Antwort2' SQLFieldName = 'Antwort2' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField7: TdaField Alias = 'Beschaeftigungsart' DisplayWidth = 2 FieldAlias = 'Beschaeftigungsart' FieldLength = 2 FieldName = 'Beschaeftigungsart' SQLFieldName = 'Beschaeftigungsart' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField8: TdaField Alias = 'DatumAbgang' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'DatumAbgang' FieldLength = 0 FieldName = 'DatumAbgang' SQLFieldName = 'DatumAbgang' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField9: TdaField Alias = 'DatumZugang' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'DatumZugang' FieldLength = 0 FieldName = 'DatumZugang' SQLFieldName = 'DatumZugang' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField10: TdaField Alias = 'Einsatzstatus' DisplayWidth = 1 FieldAlias = 'Einsatzstatus' FieldLength = 1 FieldName = 'Einsatzstatus' SQLFieldName = 'Einsatzstatus' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField11: TdaField Alias = 'Email' DisplayWidth = 100 FieldAlias = 'Email' FieldLength = 100 FieldName = 'Email' SQLFieldName = 'Email' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField12: TdaField Alias = 'EMailDienstlich' DisplayWidth = 100 FieldAlias = 'EMailDienstlich' FieldLength = 100 FieldName = 'EMailDienstlich' SQLFieldName = 'EMailDienstlich' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField13: TdaField Alias = 'EntlastungStd' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'EntlastungStd' FieldLength = 0 FieldName = 'EntlastungStd' SQLFieldName = 'EntlastungStd' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField14: TdaField Alias = 'ErmGrund' DisplayWidth = 2 FieldAlias = 'ErmGrund' FieldLength = 2 FieldName = 'ErmGrund' SQLFieldName = 'ErmGrund' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField15: TdaField Alias = 'ErmStd' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'ErmStd' FieldLength = 0 FieldName = 'ErmStd' SQLFieldName = 'ErmStd' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField16: TdaField Alias = 'ErtUnterrichtLID' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'ErtUnterrichtLID' FieldLength = 0 FieldName = 'ErtUnterrichtLID' SQLFieldName = 'ErtUnterrichtLID' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField17: TdaField Alias = 'ErtUnterrichtUVD' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'ErtUnterrichtUVD' FieldLength = 0 FieldName = 'ErtUnterrichtUVD' SQLFieldName = 'ErtUnterrichtUVD' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField18: TdaField Alias = 'Fachrichtung' DisplayWidth = 2 FieldAlias = 'Fachrichtung' FieldLength = 2 FieldName = 'Fachrichtung' SQLFieldName = 'Fachrichtung' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField19: TdaField Alias = 'Faecher' DisplayWidth = 100 FieldAlias = 'Faecher' FieldLength = 100 FieldName = 'Faecher' SQLFieldName = 'Faecher' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField20: TdaField Alias = 'FRQualifikation' DisplayWidth = 1 FieldAlias = 'FRQualifikation' FieldLength = 1 FieldName = 'FRQualifikation' SQLFieldName = 'FRQualifikation' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField21: TdaField Alias = 'FuerExport' DisplayWidth = 1 FieldAlias = 'FuerExport' FieldLength = 1 FieldName = 'FuerExport' SQLFieldName = 'FuerExport' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField22: TdaField Alias = 'FWStd' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'FWStd' FieldLength = 0 FieldName = 'FWStd' SQLFieldName = 'FWStd' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField23: TdaField Alias = 'FWStufe' DisplayWidth = 2 FieldAlias = 'FWStufe' FieldLength = 2 FieldName = 'FWStufe' SQLFieldName = 'FWStufe' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField24: TdaField Alias = 'Geburtsdatum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Geburtsdatum' FieldLength = 0 FieldName = 'Geburtsdatum' SQLFieldName = 'Geburtsdatum' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField25: TdaField Alias = 'Geschlecht' DisplayWidth = 1 FieldAlias = 'Geschlecht' FieldLength = 1 FieldName = 'Geschlecht' SQLFieldName = 'Geschlecht' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField26: TdaField Alias = 'GrundAbgang' DisplayWidth = 10 FieldAlias = 'GrundAbgang' FieldLength = 10 FieldName = 'GrundAbgang' SQLFieldName = 'GrundAbgang' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField27: TdaField Alias = 'GrundZugang' DisplayWidth = 10 FieldAlias = 'GrundZugang' FieldLength = 10 FieldName = 'GrundZugang' SQLFieldName = 'GrundZugang' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField28: TdaField Alias = 'GU_ID' DisplayWidth = 40 FieldAlias = 'GU_ID' FieldLength = 40 FieldName = 'GU_ID' SQLFieldName = 'GU_ID' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField29: TdaField Alias = 'Handy' DisplayWidth = 20 FieldAlias = 'Handy' FieldLength = 20 FieldName = 'Handy' SQLFieldName = 'Handy' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField30: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField31: TdaField Alias = 'IdentNr1' DisplayWidth = 10 FieldAlias = 'IdentNr1' FieldLength = 10 FieldName = 'IdentNr1' SQLFieldName = 'IdentNr1' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField32: TdaField Alias = 'KennwortTools' DisplayWidth = 255 FieldAlias = 'KennwortTools' FieldLength = 255 FieldName = 'KennwortTools' SQLFieldName = 'KennwortTools' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField33: TdaField Alias = 'KennwortToolsAktuell' DisplayWidth = 1 FieldAlias = 'KennwortToolsAktuell' FieldLength = 1 FieldName = 'KennwortToolsAktuell' SQLFieldName = 'KennwortToolsAktuell' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField34: TdaField Alias = 'Kuerzel' DisplayWidth = 10 FieldAlias = 'Kuerzel' FieldLength = 10 FieldName = 'Kuerzel' SQLFieldName = 'Kuerzel' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField35: TdaField Alias = 'LBQualifikation' DisplayWidth = 1 FieldAlias = 'LBQualifikation' FieldLength = 1 FieldName = 'LBQualifikation' SQLFieldName = 'LBQualifikation' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField36: TdaField Alias = 'LBVNr' DisplayWidth = 15 FieldAlias = 'LBVNr' FieldLength = 15 FieldName = 'LBVNr' SQLFieldName = 'LBVNr' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField37: TdaField Alias = 'Lehramt' DisplayWidth = 4 FieldAlias = 'Lehramt' FieldLength = 4 FieldName = 'Lehramt' SQLFieldName = 'Lehramt' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField38: TdaField Alias = 'Lehrbefaehigung' DisplayWidth = 2 FieldAlias = 'Lehrbefaehigung' FieldLength = 2 FieldName = 'Lehrbefaehigung' SQLFieldName = 'Lehrbefaehigung' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField39: TdaField Alias = 'LIDKrz' DisplayWidth = 4 FieldAlias = 'LIDKrz' FieldLength = 4 FieldName = 'LIDKrz' SQLFieldName = 'LIDKrz' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField40: TdaField Alias = 'LPassword' DisplayWidth = 255 FieldAlias = 'LPassword' FieldLength = 255 FieldName = 'LPassword' SQLFieldName = 'LPassword' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField41: TdaField Alias = 'Mehrarbeit' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Mehrarbeit' FieldLength = 0 FieldName = 'Mehrarbeit' SQLFieldName = 'Mehrarbeit' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField42: TdaField Alias = 'MehrleistungStd' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'MehrleistungStd' FieldLength = 0 FieldName = 'MehrleistungStd' SQLFieldName = 'MehrleistungStd' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField43: TdaField Alias = 'Nachname' DisplayWidth = 30 FieldAlias = 'Nachname' FieldLength = 30 FieldName = 'Nachname' SQLFieldName = 'Nachname' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField44: TdaField Alias = 'PANr' DisplayWidth = 20 FieldAlias = 'PANr' FieldLength = 20 FieldName = 'PANr' SQLFieldName = 'PANr' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField45: TdaField Alias = 'PersonTyp' DisplayWidth = 20 FieldAlias = 'PersonTyp' FieldLength = 20 FieldName = 'PersonTyp' SQLFieldName = 'PersonTyp' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField46: TdaField Alias = 'PflichtstdSoll' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'PflichtstdSoll' FieldLength = 0 FieldName = 'PflichtstdSoll' SQLFieldName = 'PflichtstdSoll' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField47: TdaField Alias = 'PLZ' DisplayWidth = 10 FieldAlias = 'PLZ' FieldLength = 10 FieldName = 'PLZ' SQLFieldName = 'PLZ' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField48: TdaField Alias = 'PWAktuell' DisplayWidth = 3 FieldAlias = 'PWAktuell' FieldLength = 3 FieldName = 'PWAktuell' SQLFieldName = 'PWAktuell' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField49: TdaField Alias = 'Rechtsverhaeltnis' DisplayWidth = 1 FieldAlias = 'Rechtsverhaeltnis' FieldLength = 1 FieldName = 'Rechtsverhaeltnis' SQLFieldName = 'Rechtsverhaeltnis' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField50: TdaField Alias = 'RestStd' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'RestStd' FieldLength = 0 FieldName = 'RestStd' SQLFieldName = 'RestStd' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField51: TdaField Alias = 'SchILDweb_Config' DataType = dtMemo DisplayWidth = 10 FieldAlias = 'SchILDweb_Config' FieldLength = 0 FieldName = 'SchILDweb_Config' Linkable = False SQLFieldName = 'SchILDweb_Config' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField52: TdaField Alias = 'SchILDweb_FL' DisplayWidth = 1 FieldAlias = 'SchILDweb_FL' FieldLength = 1 FieldName = 'SchILDweb_FL' SQLFieldName = 'SchILDweb_FL' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField53: TdaField Alias = 'SchILDweb_KL' DisplayWidth = 1 FieldAlias = 'SchILDweb_KL' FieldLength = 1 FieldName = 'SchILDweb_KL' SQLFieldName = 'SchILDweb_KL' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField54: TdaField Alias = 'SchulFunktion' DisplayWidth = 10 FieldAlias = 'SchulFunktion' FieldLength = 10 FieldName = 'SchulFunktion' SQLFieldName = 'SchulFunktion' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField55: TdaField Alias = 'SchulnrEigner' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'SchulnrEigner' FieldLength = 0 FieldName = 'SchulnrEigner' SQLFieldName = 'SchulnrEigner' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField56: TdaField Alias = 'SerNr' DisplayWidth = 5 FieldAlias = 'SerNr' FieldLength = 5 FieldName = 'SerNr' SQLFieldName = 'SerNr' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField57: TdaField Alias = 'Sichtbar' DisplayWidth = 1 FieldAlias = 'Sichtbar' FieldLength = 1 FieldName = 'Sichtbar' SQLFieldName = 'Sichtbar' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField58: TdaField Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' SQLFieldName = 'Sortierung' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField59: TdaField Alias = 'StaatKrz' DisplayWidth = 3 FieldAlias = 'StaatKrz' FieldLength = 3 FieldName = 'StaatKrz' SQLFieldName = 'StaatKrz' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField60: TdaField Alias = 'StammschulNr' DisplayWidth = 6 FieldAlias = 'StammschulNr' FieldLength = 6 FieldName = 'StammschulNr' SQLFieldName = 'StammschulNr' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField61: TdaField Alias = 'Statistik' DisplayWidth = 1 FieldAlias = 'Statistik' FieldLength = 1 FieldName = 'Statistik' SQLFieldName = 'Statistik' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField62: TdaField Alias = 'Strasse' DisplayWidth = 50 FieldAlias = 'Strasse' FieldLength = 50 FieldName = 'Strasse' SQLFieldName = 'Strasse' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField63: TdaField Alias = 'Tel' DisplayWidth = 20 FieldAlias = 'Tel' FieldLength = 20 FieldName = 'Tel' SQLFieldName = 'Tel' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField64: TdaField Alias = 'Titel' DisplayWidth = 20 FieldAlias = 'Titel' FieldLength = 20 FieldName = 'Titel' SQLFieldName = 'Titel' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField65: TdaField Alias = 'UnterrichtsStd' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'UnterrichtsStd' FieldLength = 0 FieldName = 'UnterrichtsStd' SQLFieldName = 'UnterrichtsStd' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField66: TdaField Alias = 'Vorname' DisplayWidth = 20 FieldAlias = 'Vorname' FieldLength = 20 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField67: TdaField Alias = 'VSchluessel' DisplayWidth = 1 FieldAlias = 'VSchluessel' FieldLength = 1 FieldName = 'VSchluessel' SQLFieldName = 'VSchluessel' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField68: TdaField Alias = 'ZuvielErtGrund' DisplayWidth = 2 FieldAlias = 'ZuvielErtGrund' FieldLength = 2 FieldName = 'ZuvielErtGrund' SQLFieldName = 'ZuvielErtGrund' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField69: TdaField Alias = 'ZuvielErtStd' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'ZuvielErtStd' FieldLength = 0 FieldName = 'ZuvielErtStd' SQLFieldName = 'ZuvielErtStd' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField70: TdaField Alias = 'ZuwenigErtGrund' DisplayWidth = 2 FieldAlias = 'ZuwenigErtGrund' FieldLength = 2 FieldName = 'ZuwenigErtGrund' SQLFieldName = 'ZuwenigErtGrund' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField71: TdaField Alias = 'ZuwenigErtStd' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'ZuwenigErtStd' FieldLength = 0 FieldName = 'ZuwenigErtStd' SQLFieldName = 'ZuwenigErtStd' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daTable1: TdaTable ChildType = 5 Alias = 'K_Lehrer' JoinType = dajtNone SQLAlias = 'K_Lehrer' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' end end end object daADOQueryDataView4: TdaADOQueryDataView UserName = 'Query_StvKL' Height = 209 Left = 465 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 378 TypeColumnWidth = 52 Width = 316 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_SuS' object StvKL: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'StvKL' MasterDataPipelineName = 'SuS' object ppField1: TppField FieldAlias = 'Klasse' FieldName = 'Klasse' FieldLength = 10 DisplayWidth = 10 Position = 0 end object ppField2: TppField FieldAlias = 'Klassenlehrer' FieldName = 'Klassenlehrer' FieldLength = 10 DisplayWidth = 10 Position = 1 end object ppField3: TppField FieldAlias = 'Nachname' FieldName = 'Nachname' FieldLength = 30 DisplayWidth = 30 Position = 2 end object ppField4: TppField FieldAlias = 'Vorname' FieldName = 'Vorname' FieldLength = 20 DisplayWidth = 20 Position = 3 end object ppField5: TppField FieldAlias = 'Kuerzel' FieldName = 'Kuerzel' FieldLength = 10 DisplayWidth = 10 Position = 4 end object ppField6: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 5 end object ppField7: TppField FieldAlias = 'GU_ID' FieldName = 'GU_ID' FieldLength = 40 DisplayWidth = 40 Position = 6 end end object daSQL3: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'StvKL' EditSQLAsText = True IsCaseSensitive = True LinkColor = clGreen LinkType = ltParameterizedSQL MaxSQLFieldAliasLength = 0 SkipWhenNoRecords = False SQLText.Strings = ( 'select ' 'A.Klasse,' 'A.Klassenlehrer, ' 'LK.Nachname, ' 'LK.Vorname,' 'LK.Kuerzel,' 'LK.ID,' 'LK.GU_ID' '' 'from ' 'Schueler S, ' 'SchuelerLernabschnittsdaten A, ' 'K_Lehrer LK, ' 'EigeneSchule ES ' '' 'where ' 'A.Jahr = ES.Schuljahr ' 'and A.Abschnitt = ES.SchuljahrAbschnitt' 'and LK.ID = A.StvKlassenlehrer_ID' 'and A.Schueler_ID = S.ID' 'and S.Geloescht = '#39'-'#39' ' 'and S.Status = 2' '' 'order by A.Klasse') SQLType = sqSQL2 object daField1: TdaField Alias = 'Klasse' DisplayWidth = 10 FieldAlias = 'Klasse' FieldLength = 10 FieldName = 'Klasse' SQLFieldName = 'Klasse' end object daField2: TdaField Alias = 'Klassenlehrer' DisplayWidth = 10 FieldAlias = 'Klassenlehrer' FieldLength = 10 FieldName = 'Klassenlehrer' SQLFieldName = 'Klassenlehrer' end object daField3: TdaField Alias = 'Nachname' DisplayWidth = 30 FieldAlias = 'Nachname' FieldLength = 30 FieldName = 'Nachname' SQLFieldName = 'Nachname' end object daField4: TdaField Alias = 'Vorname' DisplayWidth = 20 FieldAlias = 'Vorname' FieldLength = 20 FieldName = 'Vorname' SQLFieldName = 'Vorname' end object daField5: TdaField Alias = 'Kuerzel' DisplayWidth = 10 FieldAlias = 'Kuerzel' FieldLength = 10 FieldName = 'Kuerzel' SQLFieldName = 'Kuerzel' end object daField6: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' end object daField7: TdaField Alias = 'GU_ID' DisplayWidth = 40 FieldAlias = 'GU_ID' FieldLength = 40 FieldName = 'GU_ID' SQLFieldName = 'GU_ID' end object TdaSQLLink ChildType = 9 object daField8: TdaField ChildType = 10 Alias = 'Lehrer' DisplayWidth = 10 FieldAlias = 'Lehrer' FieldLength = 10 FieldName = 'Lehrer' SQLFieldName = 'Lehrer' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField9: TdaField ChildType = 11 Alias = 'Klassenlehrer' DisplayWidth = 10 FieldAlias = 'Klassenlehrer' FieldLength = 10 FieldName = 'Klassenlehrer' SQLFieldName = 'Klassenlehrer' end end end end object daADOQueryDataView5: TdaADOQueryDataView UserName = 'Query_SuS_alle' Height = 539 Left = 806 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 33 TypeColumnWidth = 52 Width = 354 AutoSearchTabOrder = 0 object SuS_alle: TppChildDBPipeline AutoCreateFields = False UserName = 'SuS_alle' object ppField1: TppField FieldAlias = 'AktAbschnitt' FieldName = 'AktAbschnitt' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'Schueler' end object ppField2: TppField FieldAlias = 'AktSchuljahr' FieldName = 'AktSchuljahr' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 1 TableName = 'Schueler' end object ppField3: TppField FieldAlias = 'ASDJahrgang' FieldName = 'ASDJahrgang' FieldLength = 2 DisplayWidth = 2 Position = 2 TableName = 'Schueler' end object ppField4: TppField FieldAlias = 'ASDSchulform' FieldName = 'ASDSchulform' FieldLength = 3 DisplayWidth = 3 Position = 3 TableName = 'Schueler' end object ppField5: TppField FieldAlias = 'Geloescht' FieldName = 'Geloescht' FieldLength = 1 DisplayWidth = 1 Position = 4 TableName = 'Schueler' end object ppField6: TppField FieldAlias = 'Geschlecht' FieldName = 'Geschlecht' FieldLength = 0 DataType = dtLongint DisplayWidth = 10 Position = 5 TableName = 'Schueler' end object ppField7: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 6 TableName = 'Schueler' end object ppField8: TppField FieldAlias = 'Klasse' FieldName = 'Klasse' FieldLength = 6 DisplayWidth = 6 Position = 7 TableName = 'Schueler' end object ppField9: TppField FieldAlias = 'Lehrer' FieldName = 'Lehrer' FieldLength = 10 DisplayWidth = 10 Position = 8 TableName = 'Schueler' end object ppField10: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 50 DisplayWidth = 50 Position = 9 TableName = 'Schueler' end object ppField11: TppField FieldAlias = 'Telefon' FieldName = 'Telefon' FieldLength = 20 DisplayWidth = 20 Position = 10 TableName = 'Schueler' end object ppField12: TppField FieldAlias = 'Volljaehrig' FieldName = 'Volljaehrig' FieldLength = 1 DisplayWidth = 1 Position = 11 TableName = 'Schueler' end object ppField13: TppField FieldAlias = 'Vorname' FieldName = 'Vorname' FieldLength = 30 DisplayWidth = 30 Position = 12 TableName = 'Schueler' end object ppField14: TppField FieldAlias = 'Anrede' FieldName = 'Anrede' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 13 TableName = 'K_Lehrer' end object ppField15: TppField FieldAlias = 'Faecher' FieldName = 'Faecher' FieldLength = 100 IsDetail = True DisplayWidth = 100 Position = 14 TableName = 'K_Lehrer' end object ppField16: TppField FieldAlias = 'Amtsbezeichnung' FieldName = 'Amtsbezeichnung' FieldLength = 15 IsDetail = True DisplayWidth = 15 Position = 15 TableName = 'K_Lehrer' end object ppField17: TppField FieldAlias = 'Geburtsdatum' FieldName = 'Geburtsdatum' FieldLength = 0 IsDetail = True DataType = dtDateTime DisplayWidth = 18 Position = 16 TableName = 'K_Lehrer' end object ppField18: TppField FieldAlias = 'Geschlecht (2)' FieldName = 'Geschlecht_2' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 17 TableName = 'K_Lehrer' end object ppField19: TppField FieldAlias = 'ID (2)' FieldName = 'ID_2' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 18 TableName = 'K_Lehrer' end object ppField20: TppField FieldAlias = 'GU_ID' FieldName = 'GU_ID' FieldLength = 40 IsDetail = True DisplayWidth = 40 Position = 19 TableName = 'K_Lehrer' end object ppField21: TppField FieldAlias = 'Kuerzel' FieldName = 'Kuerzel' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 20 TableName = 'K_Lehrer' end object ppField22: TppField FieldAlias = 'Lehramt' FieldName = 'Lehramt' FieldLength = 4 IsDetail = True DisplayWidth = 4 Position = 21 TableName = 'K_Lehrer' end object ppField23: TppField FieldAlias = 'Nachname' FieldName = 'Nachname' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 22 TableName = 'K_Lehrer' end object ppField24: TppField FieldAlias = 'Tel' FieldName = 'Tel' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 23 TableName = 'K_Lehrer' end object ppField25: TppField FieldAlias = 'Titel' FieldName = 'Titel' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 24 TableName = 'K_Lehrer' end object ppField26: TppField FieldAlias = 'Vorname (2)' FieldName = 'Vorname_2' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 25 TableName = 'K_Lehrer' end end object daSQL1: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'SuS_alle' IsCaseSensitive = True LinkColor = clMaroon LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Schueler.AktAbschnitt, ' ' Schueler.AktSchuljahr, ' ' Schueler.ASDJahrgang, ' ' Schueler.ASDSchulform, Schueler.Geloescht, ' ' Schueler.Geschlecht, Schueler.ID, ' ' Schueler.Klasse, Schueler.Lehrer, ' ' Schueler.Name, Schueler.Telefon, ' ' Schueler.Volljaehrig, Schueler.Vorname, ' ' K_Lehrer.Anrede, K_Lehrer.Faecher, ' ' K_Lehrer.Amtsbezeichnung, ' ' K_Lehrer.Geburtsdatum, ' ' K_Lehrer.Geschlecht AS Geschlecht_2, ' ' K_Lehrer.ID AS ID_2, K_Lehrer.GU_ID, ' ' K_Lehrer.Kuerzel, K_Lehrer.Lehramt, ' ' K_Lehrer.Nachname, K_Lehrer.Tel, ' ' K_Lehrer.Titel, ' ' K_Lehrer.Vorname AS Vorname_2' 'FROM (Schueler Schueler' ' INNER JOIN K_Lehrer K_Lehrer ON ' ' (K_Lehrer.Kuerzel = Schueler.Lehrer) )' 'WHERE ( Schueler.Status IN (2,6) )' ' AND ( Schueler.Geloescht <> '#39'+'#39' )' 'ORDER BY Schueler.Klasse, Schueler.Name, ' ' Schueler.Vorname') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList Value = '2,6' 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 object TdaNumericValue Value = 6.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 daField1: TdaField Alias = 'AktAbschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'AktAbschnitt' FieldLength = 0 FieldName = 'AktAbschnitt' SQLFieldName = 'AktAbschnitt' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField2: TdaField Alias = 'AktSchuljahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'AktSchuljahr' FieldLength = 0 FieldName = 'AktSchuljahr' SQLFieldName = 'AktSchuljahr' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField3: TdaField Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' SQLFieldName = 'ASDJahrgang' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField4: TdaField Alias = 'ASDSchulform' DisplayWidth = 3 FieldAlias = 'ASDSchulform' FieldLength = 3 FieldName = 'ASDSchulform' SQLFieldName = 'ASDSchulform' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField5: TdaField Alias = 'Geloescht' DisplayWidth = 1 FieldAlias = 'Geloescht' FieldLength = 1 FieldName = 'Geloescht' SQLFieldName = 'Geloescht' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField6: TdaField Alias = 'Geschlecht' DataType = dtLongint DisplayWidth = 10 FieldAlias = 'Geschlecht' FieldLength = 0 FieldName = 'Geschlecht' SQLFieldName = 'Geschlecht' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField7: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField8: TdaField Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField9: TdaField Alias = 'Lehrer' DisplayWidth = 10 FieldAlias = 'Lehrer' FieldLength = 10 FieldName = 'Lehrer' SQLFieldName = 'Lehrer' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField10: TdaField Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField11: TdaField Alias = 'Telefon' DisplayWidth = 20 FieldAlias = 'Telefon' FieldLength = 20 FieldName = 'Telefon' SQLFieldName = 'Telefon' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField12: TdaField Alias = 'Volljaehrig' DisplayWidth = 1 FieldAlias = 'Volljaehrig' FieldLength = 1 FieldName = 'Volljaehrig' SQLFieldName = 'Volljaehrig' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField13: TdaField Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField14: TdaField Alias = 'Anrede' DisplayWidth = 10 FieldAlias = 'Anrede' FieldLength = 10 FieldName = 'Anrede' IsDetail = True SQLFieldName = 'Anrede' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField15: TdaField Alias = 'Faecher' DisplayWidth = 100 FieldAlias = 'Faecher' FieldLength = 100 FieldName = 'Faecher' IsDetail = True SQLFieldName = 'Faecher' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField16: TdaField Alias = 'Amtsbezeichnung' DisplayWidth = 15 FieldAlias = 'Amtsbezeichnung' FieldLength = 15 FieldName = 'Amtsbezeichnung' IsDetail = True SQLFieldName = 'Amtsbezeichnung' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField17: TdaField Alias = 'Geburtsdatum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Geburtsdatum' FieldLength = 0 FieldName = 'Geburtsdatum' IsDetail = True SQLFieldName = 'Geburtsdatum' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField18: TdaField Alias = 'Geschlecht (2)' DisplayWidth = 1 FieldAlias = 'Geschlecht' FieldLength = 1 FieldName = 'Geschlecht' IsDetail = True SQLFieldName = 'Geschlecht_2' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField19: 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 daField20: TdaField Alias = 'GU_ID' DisplayWidth = 40 FieldAlias = 'GU_ID' FieldLength = 40 FieldName = 'GU_ID' IsDetail = True SQLFieldName = 'GU_ID' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField21: 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 daField22: TdaField Alias = 'Lehramt' DisplayWidth = 4 FieldAlias = 'Lehramt' FieldLength = 4 FieldName = 'Lehramt' IsDetail = True SQLFieldName = 'Lehramt' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField23: 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 daField24: TdaField Alias = 'Tel' DisplayWidth = 20 FieldAlias = 'Tel' FieldLength = 20 FieldName = 'Tel' IsDetail = True SQLFieldName = 'Tel' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField25: TdaField Alias = 'Titel' DisplayWidth = 20 FieldAlias = 'Titel' FieldLength = 20 FieldName = 'Titel' IsDetail = True SQLFieldName = 'Titel' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField26: TdaField Alias = 'Vorname (2)' DisplayWidth = 20 FieldAlias = 'Vorname' FieldLength = 20 FieldName = 'Vorname' IsDetail = True SQLFieldName = 'Vorname_2' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField27: TdaField ChildType = 2 Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField28: TdaField ChildType = 2 Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField29: TdaField ChildType = 2 Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daTable1: TdaTable ChildType = 5 Alias = 'Schueler' JoinType = dajtNone SQLAlias = 'Schueler' TableAlias = 'Schueler' TableName = 'Schueler' end object daTable2: TdaTable ChildType = 5 Alias = 'K_Lehrer' SQLAlias = 'K_Lehrer' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' object daTableJoin1: TdaTableJoin ChildType = 6 object daField31: 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 daField30: TdaField ChildType = 4 Alias = 'Lehrer' DisplayWidth = 10 FieldAlias = 'Lehrer' FieldLength = 10 FieldName = 'Lehrer' SQLFieldName = 'Lehrer' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end end end end object daADOQueryDataView6: TdaADOQueryDataView UserName = 'Query_SuS_Vermallg' Height = 301 Left = 1217 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 13 TypeColumnWidth = 52 Width = 270 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_SuS_alle' object SuS_Vermallg: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'SuS_Vermallg' MasterDataPipelineName = 'SuS_alle' object ppField1: TppField FieldAlias = 'AngelegtVon' FieldName = 'AngelegtVon' FieldLength = 20 DisplayWidth = 20 Position = 0 TableName = 'SchuelerVermerke' end object ppField2: TppField FieldAlias = 'Bemerkung' FieldName = 'Bemerkung' FieldLength = 0 Linkable = False DataType = dtMemo DisplayWidth = 10 Position = 1 TableName = 'SchuelerVermerke' end object ppField3: TppField FieldAlias = 'Datum' FieldName = 'Datum' FieldLength = 0 DataType = dtDateTime DisplayWidth = 18 Position = 2 TableName = 'SchuelerVermerke' end object ppField4: TppField FieldAlias = 'GeaendertVon' FieldName = 'GeaendertVon' FieldLength = 20 DisplayWidth = 20 Position = 3 TableName = 'SchuelerVermerke' end object ppField5: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 4 TableName = 'SchuelerVermerke' end object ppField6: TppField FieldAlias = 'Schueler_ID' FieldName = 'Schueler_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 5 TableName = 'SchuelerVermerke' end object ppField7: TppField FieldAlias = 'SchulnrEigner' FieldName = 'SchulnrEigner' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 6 TableName = 'SchuelerVermerke' end object ppField8: TppField FieldAlias = 'VermerkArt_ID' FieldName = 'VermerkArt_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 7 TableName = 'SchuelerVermerke' end object ppField9: TppField FieldAlias = 'Bezeichnung' FieldName = 'Bezeichnung' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 8 TableName = 'K_VermerkArt' end object ppField10: TppField FieldAlias = 'ID (2)' FieldName = 'ID_2' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 9 TableName = 'K_VermerkArt' end object ppField11: TppField FieldAlias = 'Sortierung' FieldName = 'Sortierung' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 10 TableName = 'K_VermerkArt' end object ppField12: TppField FieldAlias = 'Sichtbar' FieldName = 'Sichtbar' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 11 TableName = 'K_VermerkArt' 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 = 'ID' GuidCollationType = gcMSAccess DetailFieldName = 'Schueler_ID' DetailSortOrder = soAscending IsCaseSensitive = True end end object daSQL3: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'SuS_Vermallg' IsCaseSensitive = True LinkColor = clGreen LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT SchuelerVermerke.AngelegtVon, ' ' SchuelerVermerke.Bemerkung, ' ' SchuelerVermerke.Datum, ' ' SchuelerVermerke.GeaendertVon, ' ' SchuelerVermerke.ID, ' ' SchuelerVermerke.Schueler_ID, ' ' SchuelerVermerke.SchulnrEigner, ' ' SchuelerVermerke.VermerkArt_ID, ' ' K_VermerkArt.Bezeichnung, ' ' K_VermerkArt.ID AS ID_2, ' ' K_VermerkArt.Sortierung, ' ' K_VermerkArt.Sichtbar' 'FROM (SchuelerVermerke SchuelerVermerke' ' INNER JOIN K_VermerkArt K_VermerkArt ON ' ' (K_VermerkArt.ID = SchuelerVermerke.VermerkArt_ID) )' 'ORDER BY K_VermerkArt.Bezeichnung, ' ' SchuelerVermerke.Datum') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'Verm_Art' object TdaField Alias = 'Bezeichnung' DisplayWidth = 30 FieldAlias = 'Bezeichnung' FieldLength = 30 FieldName = 'Bezeichnung' ShowAllValues = True SQLFieldName = 'Bezeichnung' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end end object daField1: TdaField Alias = 'AngelegtVon' DisplayWidth = 20 FieldAlias = 'AngelegtVon' FieldLength = 20 FieldName = 'AngelegtVon' SQLFieldName = 'AngelegtVon' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField2: TdaField Alias = 'Bemerkung' DataType = dtMemo DisplayWidth = 10 FieldAlias = 'Bemerkung' FieldLength = 0 FieldName = 'Bemerkung' Linkable = False SQLFieldName = 'Bemerkung' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField3: TdaField Alias = 'Datum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Datum' FieldLength = 0 FieldName = 'Datum' SQLFieldName = 'Datum' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField4: TdaField Alias = 'GeaendertVon' DisplayWidth = 20 FieldAlias = 'GeaendertVon' FieldLength = 20 FieldName = 'GeaendertVon' SQLFieldName = 'GeaendertVon' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField5: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField6: TdaField Alias = 'Schueler_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schueler_ID' FieldLength = 0 FieldName = 'Schueler_ID' SQLFieldName = 'Schueler_ID' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField7: TdaField Alias = 'SchulnrEigner' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'SchulnrEigner' FieldLength = 0 FieldName = 'SchulnrEigner' SQLFieldName = 'SchulnrEigner' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField8: TdaField Alias = 'VermerkArt_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'VermerkArt_ID' FieldLength = 0 FieldName = 'VermerkArt_ID' SQLFieldName = 'VermerkArt_ID' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField9: TdaField Alias = 'Bezeichnung' DisplayWidth = 30 FieldAlias = 'Bezeichnung' FieldLength = 30 FieldName = 'Bezeichnung' IsDetail = True SQLFieldName = 'Bezeichnung' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end object daField10: TdaField Alias = 'ID (2)' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' IsDetail = True SQLFieldName = 'ID_2' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end object daField11: TdaField Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' IsDetail = True SQLFieldName = 'Sortierung' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end object daField12: TdaField Alias = 'Sichtbar' DisplayWidth = 1 FieldAlias = 'Sichtbar' FieldLength = 1 FieldName = 'Sichtbar' IsDetail = True SQLFieldName = 'Sichtbar' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end object daField13: TdaField ChildType = 2 Alias = 'Bezeichnung' DisplayWidth = 30 FieldAlias = 'Bezeichnung' FieldLength = 30 FieldName = 'Bezeichnung' SQLFieldName = 'Bezeichnung' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end object daField14: TdaField ChildType = 2 Alias = 'Datum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Datum' FieldLength = 0 FieldName = 'Datum' SQLFieldName = 'Datum' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daTable1: TdaTable ChildType = 5 Alias = 'SchuelerVermerke' JoinType = dajtNone SQLAlias = 'SchuelerVermerke' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' end object daTable2: TdaTable ChildType = 5 Alias = 'K_VermerkArt' SQLAlias = 'K_VermerkArt' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' object daTableJoin1: TdaTableJoin ChildType = 6 object daField16: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end object daField15: TdaField ChildType = 4 Alias = 'VermerkArt_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'VermerkArt_ID' FieldLength = 0 FieldName = 'VermerkArt_ID' SQLFieldName = 'VermerkArt_ID' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end end end object TdaSQLLink ChildType = 9 object daField17: TdaField ChildType = 10 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField18: TdaField ChildType = 11 Alias = 'Schueler_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schueler_ID' FieldLength = 0 FieldName = 'Schueler_ID' SQLFieldName = 'Schueler_ID' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end end end end end object raCodeModule1: TraCodeModule ProgramStream = { 01060D54726156617250726F6772616D094368696C645479706502110B50726F 6772616D4E616D6506095661726961626C65730B50726F6772616D5479706507 0B747450726F63656475726506536F7572636506B170726F6365647572652056 61726961626C65733B0D0A7661720D0A6B756B49443A20737472696E673B0D0A 69645F6C6973743A20737472696E673B0D0A7665726D5F6C6973743A20737472 696E673B0D0A7665726D5F6C697374616C6C673A20737472696E673B20200D0A 7665726D5F7A6165686C65723A20696E74656765723B200D0A7665726D617274 5F7A6165686C65723A20696E74656765723B200D0A0D0A626567696E0D0A0D0A 656E643B0D0A084361726574506F730102010201000001060A54726150726F67 72616D094368696C645479706502130B50726F6772616D4E616D65060E476C6F 62616C4F6E4372656174650B50726F6772616D54797065070B747450726F6365 6475726506536F75726365065970726F63656475726520476C6F62616C4F6E43 72656174653B0D0A626567696E0D0A2F2F206B756B49443A3D20737472696E67 696E707574282750617373776F72742065696E676562656E272C2727293B0D0A 656E643B0D0A084361726574506F730102010201000001060F5472614576656E 7448616E646C65720B50726F6772616D4E616D65061C64624C697374656E6265 7A656963686E756E674F6E476574546578740B50726F6772616D54797065070B 747450726F63656475726506536F75726365069A70726F636564757265206462 4C697374656E62657A656963686E756E674F6E47657454657874287661722054 6578743A20537472696E67293B0D0A626567696E0D0A0D0A202054657874203A 3D2027202027202B2054657874202B20272027202B205375535B274B6C617373 65275D202B202720202827202B205375535B274E6163686E616D65275D202B20 2729273B0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D6506136462 4C697374656E62657A656963686E756E67094576656E744E616D6506094F6E47 657454657874074576656E7449440235084361726574506F7301020102010000 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D65060F 4C615F53656D4F6E476574546578740B50726F6772616D54797065070B747450 726F63656475726506536F757263650C0202000070726F636564757265204C61 5F53656D4F6E476574546578742876617220546578743A20537472696E67293B 0D0A7661720D0A2020736A2C20686A202C206C7374722C2073656D3A73747269 6E673B0D0A626567696E0D0A207B200D0A2020736A203A3D20456967656E6553 6368756C655B27536368756C6A616872275D3B0D0A2020686A203A3D20456967 656E65536368756C655B27536368756C6A61687241627363686E697474275D3B 0D0A2020696620686A203D20273127207468656E2073656D3A3D202757696E74 657273656D6573746572202720656C73652073656D3A3D2027536F6D6D657273 656D657374657220273B0D0A20206C5374723A3D496E74546F53747228287374 72746F696E7428736A29202B203129206D6F6420313030293B0D0A2020696620 4C656E677468286C53747229203C2032207468656E206C5374723A3D27302720 2B206C5374723B0D0A2020696620686A203D20273227207468656E2074657874 3A3D2073656D202B2027323027202B206C7374723B0D0A2020696620686A203D 20273127207468656E2074657874203A3D2073656D202B20636F707928736A2C 312C3429202B20272F27202B206C5374723B0D0A207D0D0A200D0A2074657874 3A3D20456967656E65536368756C655B27536368756C6A616872556E64416273 63686E69747454657874275D3B200D0A656E643B0D0A0D436F6D706F6E656E74 4E616D6506064C615F53656D094576656E744E616D6506094F6E476574546578 74074576656E7449440235084361726574506F73010233020F000001060F5472 614576656E7448616E646C65720B50726F6772616D4E616D6506114465746169 6C4265666F72655072696E740B50726F6772616D54797065070B747450726F63 656475726506536F7572636506A270726F6365647572652044657461696C4265 666F72655072696E743B0D0A626567696E0D0A2F2F2064657461696C2E766973 69626C653A3D2028286B756B4944203D20636F7079285375535B2747555F4944 275D2C322C382929206F7220286B756B4944203D20636F7079285374764B4C5B 2747555F4944275D2C322C382929293B0D0A20207665726D6172745F7A616568 6C65723A3D20303B0D0A656E643B0D0A0D436F6D706F6E656E744E616D650606 44657461696C094576656E744E616D65060B4265666F72655072696E74074576 656E7449440218084361726574506F730102070204000001060F547261457665 6E7448616E646C65720B50726F6772616D4E616D6506104442545F5374564F6E 476574546578740B50726F6772616D54797065070B747450726F636564757265 06536F75726365068B70726F636564757265204442545F5374564F6E47657454 6578742876617220546578743A20537472696E67293B0D0A626567696E0D0A0D 0A202069662074657874203D202727207468656E20746578743A3D20274E4E27 3B0D0A0D0A202054657874203A3D20275374656C6C76657274726574756E673A 2027202B20746578743B0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E61 6D6506074442545F537456094576656E744E616D6506094F6E47657454657874 074576656E7449440235084361726574506F7301020B0204000001060F547261 4576656E7448616E646C65720B50726F6772616D4E616D6506104C615F4E616D 654F6E476574546578740B50726F6772616D54797065070B747450726F636564 75726506536F75726365065770726F636564757265204C615F4E616D654F6E47 6574546578742876617220546578743A20537472696E67293B0D0A626567696E 0D0A0D0A2020546578743A3D205375535B274E616D65275D3B0D0A0D0A656E64 3B0D0A0D436F6D706F6E656E744E616D6506074C615F4E616D65094576656E74 4E616D6506094F6E47657454657874074576656E744944023508436172657450 6F730102160204000001060F5472614576656E7448616E646C65720B50726F67 72616D4E616D6506134C615F566F726E616D654F6E476574546578740B50726F 6772616D54797065070B747450726F63656475726506536F75726365065D7072 6F636564757265204C615F566F726E616D654F6E476574546578742876617220 546578743A20537472696E67293B0D0A626567696E0D0A0D0A2020546578743A 3D205375535B27566F726E616D65275D3B0D0A0D0A656E643B0D0A0D436F6D70 6F6E656E744E616D65060A4C615F566F726E616D65094576656E744E616D6506 094F6E47657454657874074576656E7449440235084361726574506F73010219 0204000000} end object ppDesignLayers1: TppDesignLayers object ppDesignLayer1: TppDesignLayer UserName = 'Foreground' LayerType = ltBanded Index = 0 end end object ppParameterList2: TppParameterList object ppArchivierung: TppParameter AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = 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 = 'Klasse' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = False AutoSearchSettings.SearchOperator = soInList AutoSearchSettings.ShowAllValues = True AutoSearchSettings.DataPipelineName = 'SuS' DataType = dtString LookupSettings.NameField = 'Klasse' LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName LookupSettings.ValueField = 'Klasse' LookupSettings.DataPipelineName = 'SuS' Value = '' UserName = 'Klassenwahl' end object ppParameter2: TppParameter AutoSearchSettings.Enabled = True AutoSearchSettings.FieldAlias = 'Bezeichnung' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = False AutoSearchSettings.SearchOperator = soInList AutoSearchSettings.ShowAllValues = True AutoSearchSettings.DataPipelineName = 'SuS_Verm' DataType = dtString LookupSettings.NameField = 'Bezeichnung' LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName LookupSettings.ValueField = 'Bezeichnung' LookupSettings.DataPipelineName = 'SuS_Verm' Value = '' UserName = 'Verm_Art' end end end