home *** CD-ROM | disk | FTP | other *** search
Wrap
INI File | 2005-10-03 | 37.3 KB | 1,848 lines
[Main] Version=3.5 OperatCount=38 TableCount=5 FieldCount=95 CondCount=0 FieldGroups=6 DefaultMainTable= RootFieldsFirst=0 [Operator:1] Name=Equal DisplayName=ist gleich SQLName=@f = '@1' ValFormat= ExprType=SameAsField AppliedTypes=ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp, ValueKind=vkScalar [Operator:2] Name=NotEqual DisplayName=ist ungleich SQLName=@f <> '@1' ValFormat= ExprType=SameAsField AppliedTypes=ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp, ValueKind=vkScalar [Operator:3] Name=LessThan DisplayName=kleiner als SQLName=@f < '@1' ValFormat= ExprType=SameAsField AppliedTypes=ftSmallint,ftInteger,ftWord,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp, ValueKind=vkScalar [Operator:4] Name=LessOrEqual DisplayName=kleiner gleich als SQLName=@f <= '@1' ValFormat= ExprType=SameAsField AppliedTypes=ftSmallint,ftInteger,ftWord,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp, ValueKind=vkScalar [Operator:5] Name=GreaterThan DisplayName=gr÷▀er als SQLName=@f >'@1' ValFormat= ExprType=SameAsField AppliedTypes=ftSmallint,ftInteger,ftWord,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp, ValueKind=vkScalar [Operator:6] Name=GreaterOrEqual DisplayName=gr÷▀er gleich als SQLName=@f >= '@1' ValFormat= ExprType=SameAsField AppliedTypes=ftSmallint,ftInteger,ftWord,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp, ValueKind=vkScalar [Operator:7] Name=IsNull DisplayName=ist leer SQLName=@f is null ValFormat= ExprType=SameAsField AppliedTypes=ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftDate,ftTime,ftDateTime,ftAutoInc,ftMemo,ftFmtMemo,ftLargeint,ftTimeStamp, ValueKind=vkScalar [Operator:8] Name=InList DisplayName=ist in der Liste SQLName=@f in (@1) ValFormat= ExprType=SameAsField AppliedTypes=ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp, ValueKind=vkList [Operator:9] Name=NotInList DisplayName=ist nicht in der Liste SQLName=NOT (@f in (@1)) ValFormat= ExprType=SameAsField AppliedTypes=ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp, ValueKind=vkList [Operator:10] Name=StartsWith DisplayName=beginnt mit SQLName=@f like '@1%' ValFormat= ExprType=SameAsField AppliedTypes=ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp, ValueKind=vkScalar [Operator:11] Name=NotStartsWith DisplayName=beginnt nicht mit SQLName=not(@f like '@1%') ValFormat= ExprType=SameAsField AppliedTypes=ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp, ValueKind=vkScalar [Operator:12] Name=Contains DisplayName=beinhaltet SQLName=@f like '%@1%' ValFormat= ExprType=SameAsField AppliedTypes=ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp, ValueKind=vkScalar [Operator:13] Name=NotContains DisplayName=beinhaltet nicht SQLName=not(@f like '%@1%') ValFormat= ExprType=SameAsField AppliedTypes=ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp, ValueKind=vkScalar [Operator:14] Name=Between DisplayName=zwischen SQLName=@f between '@1' and '@2' ValFormat=and ExprType=SameAsField AppliedTypes=ftSmallint,ftInteger,ftWord,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp, ValueKind=vkScalar [Operator:15] Name=NotBetween DisplayName=ist nicht zwischen SQLName=NOT (@f between '@1' and '@2') ValFormat=and ExprType=SameAsField AppliedTypes=ftSmallint,ftInteger,ftWord,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp, ValueKind=vkScalar [Operator:16] Name=Today DisplayName=ist heute SQLName=cast(@f as date) = CURRENT_DATE ValFormat= ExprType=SameAsField AppliedTypes=ftDate,ftDateTime, ValueKind=vkScalar [Operator:17] Name=Equal_Date DisplayName=ist gleich SQLName=cast(@f as date) = cast('@1' as date) ValFormat= ExprType=SameAsField AppliedTypes=ftDate,ftDateTime, ValueKind=vkScalar [Operator:18] Name=NotEqual_Date DisplayName=ist ungleich SQLName=cast(@f as date) <> cast('@1' as date) ValFormat= ExprType=SameAsField AppliedTypes=ftDate,ftDateTime, ValueKind=vkScalar [Operator:19] Name=LessThan_Date DisplayName=kleiner als SQLName=cast(@f as date) < cast('@1' as date) ValFormat= ExprType=SameAsField AppliedTypes=ftDate,ftDateTime, ValueKind=vkScalar [Operator:20] Name=LessOrEqual_Date DisplayName=kleiner gleich als SQLName=cast(@f as date) <= cast('@1' as date) ValFormat= ExprType=SameAsField AppliedTypes=ftDate,ftDateTime, ValueKind=vkScalar [Operator:21] Name=GreaterThan_Date DisplayName=gr÷▀er als SQLName=cast(@f as date) > cast('@1' as date) ValFormat= ExprType=SameAsField AppliedTypes=ftDate,ftDateTime, ValueKind=vkScalar [Operator:22] Name=GreaterOrEqual_Date DisplayName=gr÷▀er gleich als SQLName=cast(@f as date) >= cast('@1' as date) ValFormat= ExprType=SameAsField AppliedTypes=ftDate,ftDateTime, ValueKind=vkScalar [Operator:23] Name=Between_Date DisplayName=zwischen SQLName=cast(@f as date) between cast('@1' as date) and cast('@2' as date) ValFormat= ExprType=SameAsField AppliedTypes=ftDate,ftDateTime, ValueKind=vkScalar [Operator:24] Name=NotBetween_Date DisplayName=nicht zwischen SQLName=NOT (cast(@f as date) between cast('@1' as date) and cast('@2' as date)) ValFormat= ExprType=SameAsField AppliedTypes=ftDate,ftDateTime, ValueKind=vkScalar [Operator:25] Name=NextMonth DisplayName=liegt im nΣchsten Monat SQLName=(EXTRACT( MONTH from cast(@f as date)) = EXTRACT(MONTH from CURRENT_DATE)+1) AND (EXTRACT( YEAR from cast(@f as date)) = EXTRACT(YEAR from CURRENT_DATE)) ValFormat= ExprType=SameAsField AppliedTypes=ftDate,ftDateTime, ValueKind=vkScalar [Operator:26] Name=LastMonth DisplayName=liegt im letzten Monat SQLName=(EXTRACT( MONTH from cast(@f as date)) = EXTRACT(MONTH from CURRENT_DATE)-1) AND (EXTRACT( YEAR from cast(@f as date)) = EXTRACT(YEAR from CURRENT_DATE)) ValFormat= ExprType=SameAsField AppliedTypes=ftDate,ftDateTime, ValueKind=vkScalar [Operator:27] Name=ActualMonth DisplayName=liegt im aktuellen Monat SQLName=(EXTRACT( MONTH from cast(@f as date)) = EXTRACT(MONTH from CURRENT_DATE)) AND (EXTRACT( YEAR from cast(@f as date)) = EXTRACT(YEAR from CURRENT_DATE)) ValFormat= ExprType=SameAsField AppliedTypes=ftDate,ftDateTime, ValueKind=vkScalar [Operator:28] Name=Yesterday DisplayName=ist gestern SQLName=cast( @f as date ) = CURRENT_DATE-1 ValFormat= ExprType=SameAsField AppliedTypes=ftDate,ftDateTime, ValueKind=vkScalar [Operator:29] Name=Tomorrow DisplayName=ist morgen SQLName=cast( @f as date ) = CURRENT_DATE+1 ValFormat= ExprType=SameAsField AppliedTypes=ftDate,ftDateTime, ValueKind=vkScalar [Operator:30] Name=Next7Days DisplayName=liegt in den nΣchsten 7 Tagen SQLName=(cast( @f as date ) >= CURRENT_DATE) AND (cast( @f as date ) <= CURRENT_DATE+7) ValFormat= ExprType=SameAsField AppliedTypes=ftDate,ftDateTime, ValueKind=vkScalar [Operator:31] Name=EqualStr DisplayName=ist gleich SQLName=UPPER(@f) = UPPER('@1') ValFormat= ExprType=SameAsField AppliedTypes=ftString,ftFixedChar,ftWideString, ValueKind=vkScalar [Operator:32] Name=NotEqualStr DisplayName=ist ungleich SQLName=UPPER(@f) <> UPPER('@1') ValFormat= ExprType=SameAsField AppliedTypes=ftString,ftFixedChar,ftWideString, ValueKind=vkScalar [Operator:33] Name=IsNullStr DisplayName=ist leer SQLName=((@f is null) OR (@f = '')) ValFormat= ExprType=SameAsField AppliedTypes=ftString,ftFixedChar,ftWideString, ValueKind=vkScalar [Operator:34] Name=IsNotNullStr DisplayName=ist nicht leer SQLName=(not (@f is null) OR (@f <> '')) ValFormat= ExprType=SameAsField AppliedTypes=ftString,ftFixedChar,ftWideString, ValueKind=vkScalar [Operator:35] Name=StartWithStr DisplayName=beginnt mit SQLName=UPPER(@f) like UPPER( '@1%') ValFormat= ExprType=SameAsField AppliedTypes=ftString,ftFixedChar,ftWideString, ValueKind=vkScalar [Operator:36] Name=NotStartWithStr DisplayName=beginnt nicht mit SQLName=not(UPPER(@f) like UPPER( '@1%')) ValFormat= ExprType=SameAsField AppliedTypes=ftString,ftFixedChar,ftWideString, ValueKind=vkScalar [Operator:37] Name=ContainsStr DisplayName=beinhaltet SQLName=UPPER(@f) like UPPER('%@1%') ValFormat= ExprType=SameAsField AppliedTypes=ftString,ftFixedChar,ftWideString, ValueKind=vkScalar [Operator:38] Name=NotContainsStr DisplayName=beinhaltet nicht SQLName=not(UPPER(@f) like UPPER('%@1%')) ValFormat= ExprType=SameAsField AppliedTypes=ftString,ftFixedChar,ftWideString, ValueKind=vkScalar [Table:1] DBName=T Name=ADRESSE DisplayName=ADRESSE Alias=ADRESSE Quoted=0 Hints= DsgnPos=12,10,110,160 Links=TERMIN,KONTAKT,AP,WORKER [Link:ADRESSE-TERMIN] FldName1=ADRESS_ID FldName2=ADRESS_IDV Operators== QuoteFields=0 LinkType=Right [Link:ADRESSE-KONTAKT] FldName1=ADRESS_ID FldName2=ADRESS_ID Operators== QuoteFields=0 LinkType=Right [Link:ADRESSE-AP] FldName1=ADRESS_ID FldName2=ADRESS_ID Operators== QuoteFields=0 LinkType=Left [Link:ADRESSE-WORKER] FldName1=SERVICENUMMER FldName2=MITARBEITER_ID Operators== QuoteFields=0 LinkType=Right [Table:2] DBName=T Name=TERMIN DisplayName=TERMIN Alias=TERMIN Quoted=0 Hints= DsgnPos=162,10,110,160 Links= [Table:3] DBName=T Name=KONTAKT DisplayName=KONTAKT Alias=KONTAKT Quoted=0 Hints= DsgnPos=312,10,110,160 Links= [Table:4] DBName=T Name=AP DisplayName=AP Alias=AP Quoted=0 Hints= DsgnPos=482,87,113,160 Links= [Table:5] DBName=T Name=WORKER DisplayName=WORKER Alias=WORKER Quoted=0 Hints= DsgnPos=165,273,110,153 Links= [Field:1] ID=2 Kind=kfkData FieldExpr=SERVICENUMMER DisplayName=Mitarbeiter TableAlias=ADRESSE EditType=4 FieldType=2 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,Between,NotBetween [Field:1.SQL] SELECT MITARBEITER_ID, NAME || ' ' || VORNAME FROM WORKER [Field:2] ID=3 Kind=kfkData FieldExpr=FIRMA DisplayName=Firma TableAlias=ADRESSE EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:3] ID=4 Kind=kfkData FieldExpr=FIRMA2 DisplayName=Firma2 TableAlias=ADRESSE EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:4] ID=5 Kind=kfkData FieldExpr=STRASSE DisplayName=Strasse TableAlias=ADRESSE EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:5] ID=6 Kind=kfkData FieldExpr=PLZ DisplayName=PLZ TableAlias=ADRESSE EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,StartsWith,NotStartsWith,Contains,NotContains,Between,NotBetween [Field:6] ID=7 Kind=kfkData FieldExpr=ORT DisplayName=Ort TableAlias=ADRESSE EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:7] ID=8 Kind=kfkData FieldExpr=LAND DisplayName=Land TableAlias=ADRESSE EditType=4 FieldType=1 FieldSize=200 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:7.SQL] SELECT STR1, STR1 FROM STRINGS WHERE ID=9 AND OBJECT=58 [Field:8] ID=9 Kind=kfkData FieldExpr=REGION DisplayName=Region TableAlias=ADRESSE EditType=4 FieldType=1 FieldSize=200 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:8.SQL] SELECT STR1, STR1 FROM STRINGS WHERE ID=10 AND OBJECT=58 [Field:9] ID=10 Kind=kfkData FieldExpr=TELEFON DisplayName=Telefon TableAlias=ADRESSE EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:10] ID=11 Kind=kfkData FieldExpr=TELEFAX DisplayName=Telefax TableAlias=ADRESSE EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:11] ID=12 Kind=kfkData FieldExpr=EMAIL DisplayName=EMail TableAlias=ADRESSE EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:12] ID=13 Kind=kfkData FieldExpr=INTERNET DisplayName=Internet TableAlias=ADRESSE EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:13] ID=14 Kind=kfkData FieldExpr=HANDY DisplayName=Handy TableAlias=ADRESSE EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:14] ID=15 Kind=kfkData FieldExpr=BRANCHE DisplayName=Branche TableAlias=ADRESSE EditType=4 FieldType=2 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,Between,NotBetween [Field:14.SQL] SELECT BRANCHE_ID, BRANCHE from BRANCHE [Field:15] ID=17 Kind=kfkData FieldExpr=UPDATED DisplayName=GeΣndert am TableAlias=ADRESSE EditType=0 FieldType=9 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days [Field:16] ID=18 Kind=kfkData FieldExpr=DATUM DisplayName=Erstellt am TableAlias=ADRESSE EditType=0 FieldType=9 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days [Field:17] ID=21 Kind=kfkData FieldExpr=TELEFONAKTION DisplayName=Telefonaktion TableAlias=ADRESSE EditType=4 FieldType=2 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,Between,NotBetween [Field:17.SQL] select AKTION_ID, AKTION_NAME from AKTION [Field:18] ID=22 Kind=kfkData FieldExpr=NUMMER DisplayName=Nummer TableAlias=ADRESSE EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:19] ID=23 Kind=kfkData FieldExpr=TYP DisplayName=Adresstyp TableAlias=ADRESSE EditType=2 FieldType=3 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,IsNull Items=Firma,Mann,Frau Values=0,1,2 [Field:20] ID=24 Kind=kfkData FieldExpr=FORECAST DisplayName=Umsatzplanung TableAlias=ADRESSE EditType=2 FieldType=3 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,IsNull Items=Ja,Nein Values=0,1 [Field:21] ID=33 Kind=kfkData FieldExpr=DATUM DisplayName=Begint am TableAlias=TERMIN EditType=0 FieldType=9 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days [Field:22] ID=34 Kind=kfkData FieldExpr=UHRZEIT DisplayName=Begint um TableAlias=TERMIN EditType=0 FieldType=10 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,Between,NotBetween [Field:23] ID=35 Kind=kfkData FieldExpr=BETREFF DisplayName=Betreff TableAlias=TERMIN EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:24] ID=37 Kind=kfkData FieldExpr=INHABER DisplayName=Mitarbeiter TableAlias=TERMIN EditType=4 FieldType=2 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,IsNull [Field:24.SQL] SELECT MITARBEITER_ID, NAME|| ' ' || VORNAME FROM WORKER [Field:25] ID=38 Kind=kfkData FieldExpr=AP DisplayName=Partner TableAlias=TERMIN EditType=4 FieldType=3 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,IsNull [Field:25.SQL] SELECT AP_ID, NACHNAME FROM AP [Field:26] ID=39 Kind=kfkData FieldExpr=ART DisplayName=Art TableAlias=TERMIN EditType=2 FieldType=2 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,IsNull Items=Anrufen,Outdoor,Besuch,Aufgabe Values=0,1,2,3 [Field:27] ID=40 Kind=kfkData FieldExpr=USETIME DisplayName=Termintyp TableAlias=TERMIN EditType=2 FieldType=2 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,IsNull Items=Termin,Aufgabe Values=0,1 [Field:28] ID=41 Kind=kfkData FieldExpr=CREATOR DisplayName=Erstellt durch TableAlias=TERMIN EditType=4 FieldType=3 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,IsNull [Field:28.SQL] SELECT MITARBEITER_ID, NAME|| ' ' || VORNAME FROM WORKER [Field:29] ID=42 Kind=kfkData FieldExpr=CREATED DisplayName=Erstellt am TableAlias=TERMIN EditType=0 FieldType=9 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days [Field:30] ID=43 Kind=kfkData FieldExpr=CREATEDTIME DisplayName=Erstellt um TableAlias=TERMIN EditType=0 FieldType=10 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,Between,NotBetween [Field:31] ID=44 Kind=kfkData FieldExpr=ENDDATE DisplayName=Endet am TableAlias=TERMIN EditType=0 FieldType=9 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days [Field:32] ID=45 Kind=kfkData FieldExpr=ENDTIME DisplayName=Endet um TableAlias=TERMIN EditType=0 FieldType=10 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,Between,NotBetween [Field:33] ID=53 Kind=kfkData FieldExpr=KONTAKTDATUM DisplayName=Kontaktdatum TableAlias=KONTAKT EditType=0 FieldType=9 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days [Field:34] ID=54 Kind=kfkData FieldExpr=KONTAKTART DisplayName=Kontaktart TableAlias=KONTAKT EditType=0 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:35] ID=56 Kind=kfkData FieldExpr=GESPROCHENMIT DisplayName=Partner TableAlias=KONTAKT EditType=4 FieldType=1 FieldSize=200 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,IsNull [Field:35.SQL] SELECT AP_ID, NACHNAME FROM AP [Field:36] ID=57 Kind=kfkData FieldExpr=ERGEBNIS DisplayName=Ergebnis TableAlias=KONTAKT EditType=0 FieldType=1 FieldSize=20 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:37] ID=58 Kind=kfkData FieldExpr=GRUND DisplayName=Grund TableAlias=KONTAKT EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:38] ID=60 Kind=kfkData FieldExpr=TELEFONKONTAKTER DisplayName=Mitarbeiter TableAlias=KONTAKT EditType=4 FieldType=3 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,IsNull [Field:38.SQL] SELECT MITARBEITER_ID, NAME|| ' ' || VORNAME FROM WORKER [Field:39] ID=62 Kind=kfkData FieldExpr=UPDATED DisplayName=GeΣndert am TableAlias=KONTAKT EditType=0 FieldType=9 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days [Field:40] ID=64 Kind=kfkData FieldExpr=ICHISTORY DisplayName=Erstellt am TableAlias=KONTAKT EditType=0 FieldType=11 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days [Field:41] ID=68 Kind=kfkData FieldExpr=VORNAME DisplayName=Vorname TableAlias=AP EditType=0 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:42] ID=69 Kind=kfkData FieldExpr=NACHNAME DisplayName=Nachname TableAlias=AP EditType=0 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:43] ID=70 Kind=kfkData FieldExpr=DURCHWAHL DisplayName=Durchwahl TableAlias=AP EditType=0 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:44] ID=71 Kind=kfkData FieldExpr=APTELEFAX DisplayName=Telefax TableAlias=AP EditType=0 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:45] ID=72 Kind=kfkData FieldExpr=APEMAIL DisplayName=EMail TableAlias=AP EditType=0 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:46] ID=73 Kind=kfkData FieldExpr=APINTERNET DisplayName=Internet TableAlias=AP EditType=0 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:47] ID=74 Kind=kfkData FieldExpr=APHANDY DisplayName=Handy TableAlias=AP EditType=0 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:48] ID=75 Kind=kfkData FieldExpr=ZUERREICHEN DisplayName=Erreichbarkeit TableAlias=AP EditType=0 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:49] ID=76 Kind=kfkData FieldExpr=POSI DisplayName=Position TableAlias=AP EditType=4 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:49.SQL] SELECT STR1, STR1 FROM STRINGS WHERE ID=11 AND OBJECT=58 [Field:50] ID=77 Kind=kfkData FieldExpr=VERTRETER DisplayName=Vertretung TableAlias=AP EditType=0 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:51] ID=78 Kind=kfkData FieldExpr=GEBURTSTAG DisplayName=Geburtstag TableAlias=AP EditType=0 FieldType=9 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days [Field:52] ID=79 Kind=kfkData FieldExpr=USEGEBURTSTAG DisplayName=Geburtstag erinnern TableAlias=AP EditType=2 FieldType=2 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,IsNull Items=Ja,Nein Values=0,1 [Field:53] ID=80 Kind=kfkData FieldExpr=GESCHLECHT DisplayName=Geschlecht TableAlias=AP EditType=2 FieldType=2 FieldSize=0 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,IsNull Items=Mann,Frau Values=0,1 [Field:54] ID=81 Kind=kfkData FieldExpr=APADRART DisplayName=Adressart TableAlias=AP EditType=4 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:54.SQL] select ADRARTBEZ A, ADRARTBEZ B from ADRART [Field:55] ID=82 Kind=kfkData FieldExpr=APFIRMA DisplayName=Bemerkung TableAlias=AP EditType=0 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:56] ID=83 Kind=kfkData FieldExpr=APSTR DisplayName=Strasse TableAlias=AP EditType=0 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:57] ID=84 Kind=kfkData FieldExpr=APPLZ DisplayName=PLZ TableAlias=AP EditType=0 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,StartsWith,NotStartsWith,Contains,NotContains,Between,NotBetween,Today [Field:58] ID=85 Kind=kfkData FieldExpr=APORT DisplayName=Ort TableAlias=AP EditType=0 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:59] ID=86 Kind=kfkData FieldExpr=PRIOR DisplayName=PrioritΣt TableAlias=AP EditType=2 FieldType=1 FieldSize=1 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,IsNull Items="1. Prio","2. Prio",keine Values=1,2,N [Field:60] ID=87 Kind=kfkData FieldExpr=TITEL DisplayName=Titel TableAlias=AP EditType=0 FieldType=1 FieldSize=20 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:61] ID=88 Kind=kfkData FieldExpr=APABTEILUNG DisplayName=Abteilung TableAlias=AP EditType=4 FieldType=1 FieldSize=250 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:61.SQL] SELECT STR1, STR1 FROM STRINGS WHERE ID=7 AND OBJECT=58 [Field:62] ID=89 Kind=kfkData FieldExpr=APPRVTEL DisplayName=Privat Telefon TableAlias=AP EditType=0 FieldType=1 FieldSize=250 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:63] ID=90 Kind=kfkData FieldExpr=APPRVFAX DisplayName=Privat Fax TableAlias=AP EditType=0 FieldType=1 FieldSize=250 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:64] ID=91 Kind=kfkData FieldExpr=APPRVEMAIL DisplayName=Privat EMail TableAlias=AP EditType=0 FieldType=1 FieldSize=250 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:65] ID=92 Kind=kfkData FieldExpr=APPRVHOBBY DisplayName=Hobby TableAlias=AP EditType=0 FieldType=1 FieldSize=250 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:66] ID=93 Kind=kfkData FieldExpr=APVTEL DisplayName=Vertretung Telefon TableAlias=AP EditType=0 FieldType=1 FieldSize=250 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:67] ID=94 Kind=kfkData FieldExpr=APVFAX DisplayName=Vertretung Telefax TableAlias=AP EditType=0 FieldType=1 FieldSize=250 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:68] ID=95 Kind=kfkData FieldExpr=APVNOTE DisplayName=Vertretung Bemerkung TableAlias=AP EditType=0 FieldType=1 FieldSize=250 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:69] ID=96 Kind=kfkData FieldExpr=APVEMAIL DisplayName=Vertretung EMail TableAlias=AP EditType=0 FieldType=1 FieldSize=250 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:70] ID=97 Kind=kfkData FieldExpr=APVSTR DisplayName=Vertretung Strasse TableAlias=AP EditType=0 FieldType=1 FieldSize=250 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:71] ID=98 Kind=kfkData FieldExpr=APVPLZ DisplayName=Vertretung PLZ TableAlias=AP EditType=0 FieldType=1 FieldSize=250 Quoted=0 UIC=1 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,StartsWith,NotStartsWith,Contains,NotContains,Between,NotBetween [Field:72] ID=99 Kind=kfkData FieldExpr=APVORT DisplayName=Vertretung Ort TableAlias=AP EditType=0 FieldType=1 FieldSize=250 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr [Field:73] ID=155 Kind=kfkData FieldExpr=ADRESS_ID DisplayName=ADRESS_ID TableAlias=ADRESSE EditType=0 FieldType=3 FieldSize=0 Quoted=0 UIC=0 UIR=0 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,Between,NotBetween [Field:74] ID=156 Kind=kfkData FieldExpr=SPERRE DisplayName=SPERRE TableAlias=ADRESSE EditType=0 FieldType=2 FieldSize=0 Quoted=0 UIC=0 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,NotStartsWith,Contains,NotContains,Between,NotBetween [Field:75] ID=157 Kind=kfkData FieldExpr=SPERRE_AUTHORITY DisplayName=SPERRE_AUTHORITY TableAlias=ADRESSE EditType=0 FieldType=2 FieldSize=0 Quoted=0 UIC=0 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,NotStartsWith,Contains,NotContains,Between,NotBetween [Field:76] ID=158 Kind=kfkData FieldExpr=ADRART DisplayName=Adressart TableAlias=ADRESSE EditType=4 FieldType=1 FieldSize=100 Quoted=0 UIC=1 UIR=1 Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr [Field:76.SQL] select ADRARTBEZ A, ADRARTBEZ B from ADRART [Field:77] ID=159 Kind=kfkData FieldExpr=UPDATED DisplayName=UPDATED TableAlias=ADRESSE EditType=0 FieldType=9 FieldSize=0 Quoted=0 UIC=0 UIR=1 Operators=IsNull,Today,Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,NextMonth,LastMonth,ActualMonth,Yesterday,Tomorrow,Next7Days [Field:78] ID=160 Kind=kfkData FieldExpr=DATUM DisplayName=DATUM TableAlias=ADRESSE EditType=0 FieldType=9 FieldSize=0 Quoted=0 UIC=0 UIR=1 Operators=IsNull,Today,Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,NextMonth,LastMonth,ActualMonth,Yesterday,Tomorrow,Next7Days [Field:79] ID=161 Kind=kfkData FieldExpr=SERVICENUMMER DisplayName=SERVICENUMMER TableAlias=ADRESSE EditType=0 FieldType=2 FieldSize=0 Quoted=0 UIC=0 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,NotStartsWith,Contains,NotContains,Between,NotBetween [Field:80] ID=162 Kind=kfkData FieldExpr=TYP DisplayName=TYP TableAlias=ADRESSE EditType=0 FieldType=3 FieldSize=0 Quoted=0 UIC=0 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,StartsWith,NotStartsWith,Contains,NotContains,Between,NotBetween [Field:81] ID=163 Kind=kfkData FieldExpr=AP_ID DisplayName=AP_ID TableAlias=AP EditType=0 FieldType=3 FieldSize=0 Quoted=0 UIC=0 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,StartsWith,NotStartsWith,Contains,NotContains,Between,NotBetween [Field:82] ID=164 Kind=kfkData FieldExpr=MITARBEITER_ID DisplayName=MITARBEITER_ID TableAlias=WORKER EditType=0 FieldType=3 FieldSize=0 Quoted=0 UIC=0 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,StartsWith,NotStartsWith,Contains,NotContains,Between,NotBetween [Field:83] ID=165 Kind=kfkData FieldExpr=NAME DisplayName=NAME TableAlias=WORKER EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=0 UIR=1 Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr [Field:84] ID=166 Kind=kfkData FieldExpr=VORNAME DisplayName=VORNAME TableAlias=WORKER EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=0 UIR=1 Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr [Field:85] ID=167 Kind=kfkData FieldExpr=ABTEILUNG DisplayName=ABTEILUNG TableAlias=WORKER EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=0 UIR=1 Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr [Field:86] ID=168 Kind=kfkData FieldExpr=CODE DisplayName=CODE TableAlias=WORKER EditType=0 FieldType=1 FieldSize=10 Quoted=0 UIC=0 UIR=1 Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr [Field:87] ID=169 Kind=kfkData FieldExpr=USERGROUP DisplayName=USERGROUP TableAlias=WORKER EditType=0 FieldType=3 FieldSize=0 Quoted=0 UIC=0 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,StartsWith,NotStartsWith,Contains,NotContains,Between,NotBetween [Field:88] ID=170 Kind=kfkData FieldExpr=ANSCHRIFT DisplayName=ANSCHRIFT TableAlias=WORKER EditType=0 FieldType=16 FieldSize=8 Quoted=0 UIC=0 UIR=1 Operators=IsNull [Field:89] ID=171 Kind=kfkData FieldExpr=TELEFON DisplayName=TELEFON TableAlias=WORKER EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=0 UIR=1 Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr [Field:90] ID=172 Kind=kfkData FieldExpr=TELEFAX DisplayName=TELEFAX TableAlias=WORKER EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=0 UIR=1 Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr [Field:91] ID=173 Kind=kfkData FieldExpr=STATUS DisplayName=STATUS TableAlias=WORKER EditType=0 FieldType=1 FieldSize=200 Quoted=0 UIC=0 UIR=1 Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr [Field:92] ID=174 Kind=kfkData FieldExpr=LEV DisplayName=LEV TableAlias=WORKER EditType=0 FieldType=1 FieldSize=100 Quoted=0 UIC=0 UIR=1 Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr [Field:93] ID=175 Kind=kfkData FieldExpr=ADRESSE DisplayName=ADRESSE TableAlias=WORKER EditType=0 FieldType=1 FieldSize=255 Quoted=0 UIC=0 UIR=1 Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr [Field:94] ID=176 Kind=kfkData FieldExpr=ADRDESS_ID DisplayName=ADRDESS_ID TableAlias=WORKER EditType=0 FieldType=3 FieldSize=0 Quoted=0 UIC=0 UIR=1 Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,StartsWith,NotStartsWith,Contains,NotContains,Between,NotBetween [Field:95] ID=177 Kind=kfkData FieldExpr=JOBTITLE DisplayName=JOBTITLE TableAlias=WORKER EditType=0 FieldType=1 FieldSize=255 Quoted=0 UIC=0 UIR=1 Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr [FieldGroup1] GroupName=Adresse Fields=2,3,4,5,6,7,8,9,10,11,12,13,14,15,17,18,21,22,23,24,155,156,157,158,159,160,161,162 [FieldGroup2] GroupName=Person Fields=68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,163 [FieldGroup3] GroupName=Kontakt Fields=53,54,56,57,58,60,62,64 [FieldGroup4] GroupName=Datenfelder Fields= [FieldGroup5] GroupName=Termin Fields=33,34,45,44,35,37,38,39,40,41,42,43 [FieldGroup6] GroupName=WORKER Fields=164,165,166,167,168,169,170,171,172,173,174,175,176,177 [RootGroup] Fields=