&ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2 &ANALYZE-RESUME /* Connected Databases anadat PROGRESS */ &Scoped-define WINDOW-NAME CURRENT-WINDOW {adecomm/appserv.i} /* Temp-Table and Buffer definitions */ DEFINE TEMP-TABLE RowObject NO-UNDO {"d-spezprei.i"}. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS vTableWin /*------------------------------------------------------------------------ File: Description: from viewer.w - Template for SmartDataViewer objects Input Parameters: Output Parameters: ------------------------------------------------------------------------*/ /* This .W file was created with the Progress AppBuilder. */ /*----------------------------------------------------------------------*/ /* Create an unnamed pool to store all the widgets created by this procedure. This is a good default which assures that this procedure's triggers and internal procedures will execute in this procedure's storage, and that proper cleanup will occur on deletion of the procedure. */ CREATE WIDGET-POOL. /* *************************** Definitions ************************** */ /* Komma-Trennzeichen */ /* Keyfelder werden beim Mutieren nicht "Enabled" */ &Scoped-define ERSTES_FELD F_Knr &Scoped-define LETZTES_FELD F_Wert &Scoped-define KEY_FELDER F_Knr,Menge &Scoped-define NUR_LESEN Kunde &Scoped-define Eingabe F_Knr,F_Wert { incl/viwdefinition.i } DEF VAR lLeave AS LOG INIT TRUE NO-UNDO. DEF VAR cArtikel AS CHAR NO-UNDO. DEF VAR nKnr AS INT NO-UNDO. DEF VAR nArtnr AS INT NO-UNDO. DEF VAR nInhalt AS INT NO-UNDO. DEF VAR nJahr AS INT NO-UNDO. DEF VAR iKnr AS INT NO-UNDO. DEF TEMP-TABLE TSpezPrei LIKE Spezprei. {src/adm2/widgetprto.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK /* ******************** Preprocessor Definitions ******************** */ &Scoped-define PROCEDURE-TYPE SmartDataViewer &Scoped-define DB-AWARE no &Scoped-define ADM-CONTAINER FRAME &Scoped-define ADM-SUPPORTED-LINKS Data-Target,Update-Source,TableIO-Target,GroupAssign-Source,GroupAssign-Target /* Include file with RowObject temp-table definition */ &Scoped-define DATA-FIELD-DEFS "d-spezprei.i" /* Name of designated FRAME-NAME and/or first browse and/or first query */ &Scoped-define FRAME-NAME F-Main /* Standard List Definitions */ &Scoped-Define ENABLED-FIELDS RowObject.Menge RowObject.Ab_Datum ~ RowObject.Bis_Datum RowObject.Kunde RowObject.Wert RowObject.VP_Normal ~ RowObject.Marge RowObject.AltPreis &Scoped-define ENABLED-TABLES RowObject &Scoped-define FIRST-ENABLED-TABLE RowObject &Scoped-Define ENABLED-OBJECTS F_Knr CB_Art F_Wert Btn_Kopieren ~ Btn_Loeschen Btn_Excel RECT-1 RECT-2 &Scoped-Define DISPLAYED-FIELDS RowObject.Menge RowObject.Ab_Datum ~ RowObject.Bis_Datum RowObject.Kunde RowObject.Wert RowObject.VP_Normal ~ RowObject.Proz_Betr RowObject.Inhalt RowObject.Artnr RowObject.Firma ~ RowObject.PreisMut RowObject.Jahr RowObject.Knr RowObject.Marge ~ RowObject.AltPreis &Scoped-define DISPLAYED-TABLES RowObject &Scoped-define FIRST-DISPLAYED-TABLE RowObject &Scoped-Define DISPLAYED-OBJECTS F_Knr CB_Art F_Artnr F_Inhalt F_Jahr ~ F_Datum /* Custom List Definitions */ /* ADM-ASSIGN-FIELDS,List-2,List-3,List-4,List-5,List-6 */ &Scoped-define List-5 Btn_Kopieren Btn_Loeschen Btn_Excel &Scoped-define List-6 F_Artnr F_Inhalt F_Jahr F_Datum /* _UIB-PREPROCESSOR-BLOCK-END */ &ANALYZE-RESUME /* *********************** Control Definitions ********************** */ /* Menu Definitions */ DEFINE MENU POPUP-MENU-F-Main MENU-ITEM m_lschen_Spezialpreise_von_in LABEL "löschen Spezialpreise von inaktiven Artikeln". /* Definitions of the field level widgets */ DEFINE BUTTON Btn_Excel IMAGE-UP FILE "grafik/results%.ico":U IMAGE-INSENSITIVE FILE "grafik/results%.ico":U LABEL "Excel" SIZE 7 BY 1.81. DEFINE BUTTON Btn_Kopieren LABEL "Ko&pieren" SIZE 12 BY 1. DEFINE BUTTON Btn_Loeschen LABEL "&Löschen" SIZE 12 BY 1. DEFINE VARIABLE CB_Art AS CHARACTER FORMAT "X(256)":U LABEL "Preisart" VIEW-AS COMBO-BOX INNER-LINES 5 LIST-ITEM-PAIRS "Prozent","P", "Betrag","B" DROP-DOWN-LIST SIZE 16 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Artnr AS INTEGER FORMAT "999999":U INITIAL 0 LABEL "zu Artikel" VIEW-AS FILL-IN NATIVE SIZE 11 BY 1 TOOLTIP "Kopieren mit -Taste" BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Datum AS DATE FORMAT "99.99.9999":U LABEL "bis Datum" VIEW-AS FILL-IN NATIVE SIZE 15 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Inhalt AS INTEGER FORMAT "9999":U INITIAL 0 LABEL "/" VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 TOOLTIP "Kopieren mit -Taste" BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Jahr AS INTEGER FORMAT "9999":U INITIAL 0 LABEL "/" VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 TOOLTIP "Kopieren mit -Taste" BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Knr AS CHARACTER FORMAT "x(20)":U LABEL "Kunde" VIEW-AS FILL-IN NATIVE SIZE 15 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Wert AS DECIMAL FORMAT "zzzz9.9999-":U INITIAL 0 LABEL "Wert" VIEW-AS FILL-IN NATIVE SIZE 17 BY 1 BGCOLOR 11 NO-UNDO. DEFINE RECTANGLE RECT-1 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 150 BY 4.81. DEFINE RECTANGLE RECT-2 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 150 BY 2.48. /* ************************ Frame Definitions *********************** */ DEFINE FRAME F-Main F_Knr AT ROW 1.52 COL 9 COLON-ALIGNED WIDGET-ID 22 RowObject.Menge AT ROW 2.52 COL 24 COLON-ALIGNED WIDGET-ID 30 LABEL "ab Menge" FORMAT "zzz,zz9" VIEW-AS FILL-IN NATIVE SIZE 12 BY 1 BGCOLOR 15 RowObject.Ab_Datum AT ROW 3.52 COL 24 COLON-ALIGNED WIDGET-ID 16 LABEL "gültig ab/bis" FORMAT "99.99.9999" VIEW-AS FILL-IN NATIVE SIZE 16 BY 1 BGCOLOR 15 RowObject.Bis_Datum AT ROW 3.52 COL 48 COLON-ALIGNED WIDGET-ID 18 LABEL "/" FORMAT "99.99.9999" VIEW-AS FILL-IN NATIVE SIZE 16 BY 1 BGCOLOR 15 RowObject.Kunde AT ROW 1.52 COL 24 COLON-ALIGNED NO-LABEL WIDGET-ID 26 FORMAT "x(60)" VIEW-AS FILL-IN NATIVE SIZE 80 BY 1 BGCOLOR 15 NO-TAB-STOP CB_Art AT ROW 4.52 COL 24 COLON-ALIGNED WIDGET-ID 20 RowObject.Wert AT ROW 4.52 COL 48 COLON-ALIGNED WIDGET-ID 34 LABEL "Wert" FORMAT "zzz9.9999-" VIEW-AS FILL-IN NATIVE SIZE 16 BY 1 BGCOLOR 15 RowObject.VP_Normal AT ROW 1.52 COL 123 COLON-ALIGNED WIDGET-ID 32 LABEL "aktueller VP" VIEW-AS FILL-IN NATIVE SIZE 18 BY 1 BGCOLOR 14 NO-TAB-STOP F_Wert AT ROW 4.52 COL 83.4 COLON-ALIGNED WIDGET-ID 24 Btn_Kopieren AT ROW 7.14 COL 4.6 WIDGET-ID 42 F_Artnr AT ROW 7.14 COL 26 COLON-ALIGNED WIDGET-ID 46 RowObject.Proz_Betr AT ROW 4 COL 100 WIDGET-ID 12 LABEL "Proz_Betr" VIEW-AS TOGGLE-BOX SIZE 4 BY 1 NO-TAB-STOP F_Inhalt AT ROW 7.14 COL 40 COLON-ALIGNED WIDGET-ID 50 F_Jahr AT ROW 7.14 COL 51 COLON-ALIGNED WIDGET-ID 52 RowObject.Inhalt AT ROW 4 COL 98 COLON-ALIGNED WIDGET-ID 6 VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP Btn_Loeschen AT ROW 7.14 COL 65.4 WIDGET-ID 44 F_Datum AT ROW 7.14 COL 88 COLON-ALIGNED WIDGET-ID 48 RowObject.Artnr AT ROW 4 COL 98 COLON-ALIGNED WIDGET-ID 2 VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP Btn_Excel AT ROW 6.76 COL 115.6 WIDGET-ID 40 RowObject.Firma AT ROW 4 COL 98 COLON-ALIGNED WIDGET-ID 4 VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP RowObject.PreisMut AT ROW 4 COL 98 COLON-ALIGNED WIDGET-ID 10 VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP RowObject.Jahr AT ROW 4 COL 98 COLON-ALIGNED WIDGET-ID 8 VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP RowObject.Knr AT ROW 4 COL 100 COLON-ALIGNED WIDGET-ID 14 VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP RowObject.Marge AT ROW 4.52 COL 123 COLON-ALIGNED WIDGET-ID 28 LABEL "Marge" FORMAT "zzzz9.9999-" VIEW-AS FILL-IN NATIVE SIZE 18 BY 1 BGCOLOR 14 NO-TAB-STOP RowObject.AltPreis AT ROW 2.52 COL 123 COLON-ALIGNED WIDGET-ID 54 LABEL "alter VP" VIEW-AS FILL-IN NATIVE SIZE 18 BY 1 BGCOLOR 14 NO-TAB-STOP RECT-1 AT ROW 1.24 COL 2 WIDGET-ID 36 WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY USE-DICT-EXPS SIDE-LABELS NO-UNDERLINE THREE-D NO-AUTO-VALIDATE AT COL 1 ROW 1 SCROLLABLE WIDGET-ID 100. /* DEFINE FRAME statement is approaching 4K Bytes. Breaking it up */ DEFINE FRAME F-Main RECT-2 AT ROW 6.43 COL 2 WIDGET-ID 38 WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY USE-DICT-EXPS SIDE-LABELS NO-UNDERLINE THREE-D NO-AUTO-VALIDATE AT COL 1 ROW 1 SCROLLABLE WIDGET-ID 100. /* *********************** Procedure Settings ************************ */ &ANALYZE-SUSPEND _PROCEDURE-SETTINGS /* Settings for THIS-PROCEDURE Type: SmartDataViewer Data Source: "d-spezprei.w" Allow: Basic,DB-Fields,Smart Container Links: Data-Target,Update-Source,TableIO-Target,GroupAssign-Source,GroupAssign-Target Frames: 1 Add Fields to: Neither Other Settings: PERSISTENT-ONLY COMPILE APPSERVER Temp-Tables and Buffers: TABLE: RowObject D "?" NO-UNDO ADDITIONAL-FIELDS: {d-spezprei.i} END-FIELDS. END-TABLES. */ /* This procedure should always be RUN PERSISTENT. Report the error, */ /* then cleanup and return. */ IF NOT THIS-PROCEDURE:PERSISTENT THEN DO: MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U VIEW-AS ALERT-BOX ERROR BUTTONS OK. RETURN. END. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS /* ************************* Create Window ************************** */ &ANALYZE-SUSPEND _CREATE-WINDOW /* DESIGN Window definition (used by the UIB) CREATE WINDOW vTableWin ASSIGN HEIGHT = 8.67 WIDTH = 152. /* END WINDOW DEFINITION */ */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB vTableWin /* ************************* Included-Libraries *********************** */ {src/adm2/viewer.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* *********** Runtime Attributes and AppBuilder Settings *********** */ &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES /* SETTINGS FOR WINDOW vTableWin VISIBLE,,RUN-PERSISTENT */ /* SETTINGS FOR FRAME F-Main NOT-VISIBLE FRAME-NAME Size-to-Fit Custom */ ASSIGN FRAME F-Main:SCROLLABLE = FALSE FRAME F-Main:HIDDEN = TRUE FRAME F-Main:POPUP-MENU = MENU POPUP-MENU-F-Main:HANDLE. /* SETTINGS FOR FILL-IN RowObject.Ab_Datum IN FRAME F-Main EXP-LABEL EXP-FORMAT */ /* SETTINGS FOR FILL-IN RowObject.AltPreis IN FRAME F-Main EXP-LABEL */ ASSIGN RowObject.AltPreis:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.Artnr IN FRAME F-Main NO-ENABLE */ ASSIGN RowObject.Artnr:HIDDEN IN FRAME F-Main = TRUE RowObject.Artnr:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.Bis_Datum IN FRAME F-Main EXP-LABEL EXP-FORMAT */ /* SETTINGS FOR BUTTON Btn_Excel IN FRAME F-Main 5 */ /* SETTINGS FOR BUTTON Btn_Kopieren IN FRAME F-Main 5 */ /* SETTINGS FOR BUTTON Btn_Loeschen IN FRAME F-Main 5 */ /* SETTINGS FOR FILL-IN RowObject.Firma IN FRAME F-Main NO-ENABLE */ ASSIGN RowObject.Firma:HIDDEN IN FRAME F-Main = TRUE RowObject.Firma:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN F_Artnr IN FRAME F-Main NO-ENABLE 6 */ ASSIGN F_Artnr:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN F_Datum IN FRAME F-Main NO-ENABLE 6 */ ASSIGN F_Datum:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN F_Inhalt IN FRAME F-Main NO-ENABLE 6 */ ASSIGN F_Inhalt:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN F_Jahr IN FRAME F-Main NO-ENABLE 6 */ ASSIGN F_Jahr:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN F_Wert IN FRAME F-Main NO-DISPLAY */ /* SETTINGS FOR FILL-IN RowObject.Inhalt IN FRAME F-Main NO-ENABLE */ ASSIGN RowObject.Inhalt:HIDDEN IN FRAME F-Main = TRUE RowObject.Inhalt:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.Jahr IN FRAME F-Main NO-ENABLE */ ASSIGN RowObject.Jahr:HIDDEN IN FRAME F-Main = TRUE RowObject.Jahr:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.Knr IN FRAME F-Main NO-ENABLE */ ASSIGN RowObject.Knr:HIDDEN IN FRAME F-Main = TRUE RowObject.Knr:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.Kunde IN FRAME F-Main EXP-LABEL EXP-FORMAT */ ASSIGN RowObject.Kunde:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.Marge IN FRAME F-Main EXP-LABEL EXP-FORMAT */ ASSIGN RowObject.Marge:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.Menge IN FRAME F-Main EXP-LABEL EXP-FORMAT */ /* SETTINGS FOR FILL-IN RowObject.PreisMut IN FRAME F-Main NO-ENABLE */ ASSIGN RowObject.PreisMut:HIDDEN IN FRAME F-Main = TRUE RowObject.PreisMut:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR TOGGLE-BOX RowObject.Proz_Betr IN FRAME F-Main NO-ENABLE EXP-LABEL */ ASSIGN RowObject.Proz_Betr:HIDDEN IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.VP_Normal IN FRAME F-Main EXP-LABEL */ ASSIGN RowObject.VP_Normal:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.Wert IN FRAME F-Main EXP-LABEL EXP-FORMAT */ /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* Setting information for Queries and Browse Widgets fields */ &ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main /* Query rebuild information for FRAME F-Main _Options = "NO-LOCK" _Query is NOT OPENED */ /* FRAME F-Main */ &ANALYZE-RESUME /* ************************ Control Triggers ************************ */ &Scoped-define SELF-NAME Btn_Excel &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Excel vTableWin ON CHOOSE OF Btn_Excel IN FRAME F-Main /* Excel */ DO: DISABLE Btn_Excel WITH FRAME {&FRAME-NAME}. RUN REPORT. ENABLE Btn_Excel WITH FRAME {&FRAME-NAME}. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME Btn_Kopieren &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Kopieren vTableWin ON CHOOSE OF Btn_Kopieren IN FRAME F-Main /* Kopieren */ DO: IF FMut THEN RETURN NO-APPLY. DO WITH FRAME {&FRAME-NAME}: IF INDEX(SELF:LABEL, 'eich') > 0 THEN RUN KOPIEREN. ELSE DO: RUN ENABLE_DISABLE ( INPUT TRUE ). Btn_Kopieren:LABEL = '&Speichern'. Btn_Loeschen:SENSITIVE = FALSE. Btn_Excel :SENSITIVE = FALSE. F_Datum :SENSITIVE = FALSE. F_Datum :TAB-STOP = FALSE. APPLY 'ENTRY' TO F_Artnr. RETURN NO-APPLY. END. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Kopieren vTableWin ON END-ERROR OF Btn_Kopieren IN FRAME F-Main /* Kopieren */ DO: IF INDEX(SELF:LABEL, 'eic') > 0 THEN DO: SELF:LABEL = 'Ko&pieren'. RUN ENABLE_DISABLE ( TRUE ). APPLY 'U1'. RETURN NO-APPLY. END. ELSE DO: APPLY 'U1'. RETURN NO-APPLY. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Kopieren vTableWin ON ENDKEY OF Btn_Kopieren IN FRAME F-Main /* Kopieren */ DO: IF INDEX(SELF:LABEL, 'eic') > 0 THEN DO: SELF:LABEL = 'Ko&pieren'. RUN ENABLE_DISABLE ( TRUE ). APPLY 'U1'. RETURN NO-APPLY. END. ELSE DO: APPLY 'U1'. RETURN NO-APPLY. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Kopieren vTableWin ON RETURN OF Btn_Kopieren IN FRAME F-Main /* Kopieren */ DO: IF FMut THEN RETURN NO-APPLY. DO WITH FRAME {&FRAME-NAME}: IF INDEX(SELF:LABEL, 'eich') > 0 THEN RUN KOPIEREN. ELSE DO: RUN ENABLE_DISABLE ( INPUT TRUE ). Btn_Kopieren:LABEL = '&Speichern'. Btn_Loeschen:SENSITIVE = FALSE. Btn_Excel :SENSITIVE = FALSE. F_Datum :SENSITIVE = FALSE. F_Datum :TAB-STOP = FALSE. APPLY 'ENTRY' TO F_Artnr. RETURN NO-APPLY. END. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME Btn_Loeschen &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Loeschen vTableWin ON CHOOSE OF Btn_Loeschen IN FRAME F-Main /* Löschen */ DO: IF FMut THEN RETURN NO-APPLY. DO WITH FRAME {&FRAME-NAME}: SELF:SENSITIVE = FALSE. F_Datum:SENSITIVE = TRUE. F_Datum:TAB-STOP = TRUE. APPLY 'ENTRY' TO F_Datum. RETURN NO-APPLY. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME CB_Art &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_Art vTableWin ON VALUE-CHANGED OF CB_Art IN FRAME F-Main /* Preisart */ DO: DO WITH FRAME {&FRAME-NAME}: IF NOT FMut THEN SELF:SCREEN-VALUE = rowObject.Proz_Betr:SCREEN-VALUE. rowObject.Proz_Betr:SCREEN-VALUE = SELF:SCREEN-VALUE. rowObject.Proz_Betr:MODIFIED = TRUE. IF CB_Art:SCREEN-VALUE = 'P' THEN F_Wert:LABEL = 'Preis'. ELSE F_Wert:LABEL = 'Prozent'. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Artnr &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Artnr vTableWin ON END-ERROR OF F_Artnr IN FRAME F-Main /* zu Artikel */ DO: DO WITH FRAME {&FRAME-NAME}: SELF:SCREEN-VALUE = '0'. RUN ENABLE_DISABLE ( INPUT FALSE ). APPLY 'U1'. RETURN NO-APPLY. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Artnr vTableWin ON LEAVE OF F_Artnr IN FRAME F-Main /* zu Artikel */ DO: IF INTEGER(SELF:SCREEN-VALUE) = 0 THEN RETURN. FIND FIRST Artst USE-INDEX Artst-k1 WHERE Artst.Firma = Firma AND Artst.Artnr = INTEGER(SELF:SCREEN-VALUE) NO-LOCK NO-ERROR. IF NOT AVAILABLE Artst THEN DO: RUN FEHLER ( INPUT 1042 ) NO-ERROR. APPLY 'ENTRY' TO SELF. RETURN NO-APPLY. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Artnr vTableWin ON RETURN OF F_Artnr IN FRAME F-Main /* zu Artikel */ DO: APPLY 'TAB' TO SELF. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Datum &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Datum vTableWin ON END-ERROR OF F_Datum IN FRAME F-Main /* bis Datum */ DO: DO WITH FRAME {&FRAME-NAME}: SELF:SCREEN-VALUE = ''. SELF:SENSITIVE = FALSE. SELF:TAB-STOP = FALSE. ENABLE {&list-5}. APPLY 'U1'. RETURN NO-APPLY. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Datum vTableWin ON LEAVE OF F_Datum IN FRAME F-Main /* bis Datum */ DO: RUN LOESCHEN. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Datum vTableWin ON RETURN OF F_Datum IN FRAME F-Main /* bis Datum */ DO: APPLY 'TAB' TO SELF. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Inhalt &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Inhalt vTableWin ON END-ERROR OF F_Inhalt IN FRAME F-Main /* / */ DO: DO WITH FRAME {&FRAME-NAME}: SELF:SCREEN-VALUE = '0'. RUN ENABLE_DISABLE ( INPUT FALSE ). APPLY 'U1'. RETURN NO-APPLY. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Inhalt vTableWin ON LEAVE OF F_Inhalt IN FRAME F-Main /* / */ DO: DEF VAR iArtnr AS INT NO-UNDO. DEF VAR iInhalt AS INT NO-UNDO. iArtnr = INTEGER(F_Artnr :SCREEN-VALUE). iInhalt = INTEGER(F_Inhalt:SCREEN-VALUE). IF iArtnr = 0 THEN RETURN. FIND FIRST Artst USE-INDEX Artst-k1 WHERE Artst.Firma = Firma AND Artst.Artnr = iArtnr AND Artst.Inhalt = iInhalt NO-LOCK NO-ERROR. IF NOT AVAILABLE Artst THEN DO: RUN FEHLER ( INPUT 1042 ) NO-ERROR. APPLY 'ENTRY' TO SELF. RETURN NO-APPLY. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Inhalt vTableWin ON RETURN OF F_Inhalt IN FRAME F-Main /* / */ DO: APPLY 'TAB' TO SELF. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Jahr &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Jahr vTableWin ON END-ERROR OF F_Jahr IN FRAME F-Main /* / */ DO: DO WITH FRAME {&FRAME-NAME}: SELF:SCREEN-VALUE = '0'. RUN ENABLE_DISABLE ( INPUT FALSE ). APPLY 'U1'. RETURN NO-APPLY. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Jahr vTableWin ON LEAVE OF F_Jahr IN FRAME F-Main /* / */ DO: DEF VAR iArtnr AS INT NO-UNDO. DEF VAR iInhalt AS INT NO-UNDO. DEF VAR iJahr AS INT NO-UNDO. DEF VAR cString AS CHAR NO-UNDO. iArtnr = INTEGER(F_Artnr :SCREEN-VALUE). iInhalt = INTEGER(F_Inhalt:SCREEN-VALUE). iJahr = INTEGER(F_Jahr :SCREEN-VALUE). IF iArtnr = 0 THEN RETURN NO-APPLY. FIND FIRST Artst NO-LOCK USE-INDEX Artst-k1 WHERE Artst.Firma = Firma AND Artst.Artnr = iArtnr AND Artst.Inhalt = iInhalt AND Artst.Jahr = iJahr NO-ERROR. IF NOT AVAILABLE Artst THEN DO: RUN FEHLER ( INPUT 1042 ) NO-ERROR. APPLY 'ENTRY' TO SELF. RETURN NO-APPLY. END. cString = SUBSTITUTE('kopieren zu Artikel &1.&2.&3 &4 &5 &6 mit Speichern bestätigen!', Artst.Artnr, Artst.Inhalt, Artst.Jahr, Artst.Bez, Artst.VGeb_Cd, Artst.KGeb_Cd). MESSAGE cString VIEW-AS ALERT-BOX INFORMATION. APPLY 'ENTRY' TO Btn_Kopieren. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Jahr vTableWin ON RETURN OF F_Jahr IN FRAME F-Main /* / */ DO: APPLY 'TAB' TO SELF. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME m_lschen_Spezialpreise_von_in &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL m_lschen_Spezialpreise_von_in vTableWin ON CHOOSE OF MENU-ITEM m_lschen_Spezialpreise_von_in /* löschen Spezialpreise von inaktiven Artikeln */ DO: IF FMut THEN RETURN NO-APPLY. RUN LOESCHEN_INAKT. APPLY 'U1'. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK vTableWin /* *************************** Main Block *************************** */ { incl/viwmainblock.i } &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN RUN initializeObject. &ENDIF /************************ INTERNAL PROCEDURES ********************/ /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* ********************** Internal Procedures *********************** */ &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE addRecord vTableWin PROCEDURE addRecord : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DO WITH FRAME {&FRAME-NAME}: RUN ENABLE_DISABLE ( INPUT FALSE ). END. cArtikel = DYNAMIC-FUNCTION('getArtikel':U) NO-ERROR. IF cArtikel = '' OR cArtikel = ? THEN DO: DYNAMIC-FUNCTION('setFlagAbbruch':U, TRUE, ProgName) NO-ERROR. RETURN NO-APPLY. END. nArtnr = INTEGER(ENTRY(2, cArtikel, CHR(01))). nInhalt = INTEGER(ENTRY(3, cArtikel, CHR(01))). nJahr = INTEGER(ENTRY(4, cArtikel, CHR(01))). FNeu = TRUE. FMut = TRUE. FDisp = TRUE. RUN SUPER. /* Code placed here will execute AFTER standard behavior. */ END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE BERECHNEN vTableWin PROCEDURE BERECHNEN : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR lInkl AS LOG NO-UNDO. DEF VAR PreisGrp AS INT NO-UNDO. DEF VAR FwPreisGrp AS INT NO-UNDO. DEF VAR Marge AS DEC DECIMALS 4 NO-UNDO. DEF VAR VK_Netto AS DEC DECIMALS 4 NO-UNDO. DEF VAR VK_Spez AS DEC DECIMALS 4 NO-UNDO. DEF VAR Ansatz AS DEC DECIMALS 4 NO-UNDO. DEF VAR Wert AS DEC DECIMALS 4 NO-UNDO. FwPreisGrp = DYNAMIC-FUNCTION('GETFWPREISGRP':U) NO-ERROR. DO WITH FRAME {&FRAME-NAME}: nKnr = INTEGER(F_Knr:SCREEN-VALUE ). nArtnr = INTEGER(rowObject.Artnr:SCREEN-VALUE ). nInhalt = INTEGER(rowObject.Inhalt:SCREEN-VALUE). nJahr = INTEGER(rowObject.Jahr:SCREEN-VALUE ). Wert = DECIMAL(rowObject.Wert:SCREEN-VALUE ). END. FIND Artst NO-LOCK USE-INDEX Artst-k1 WHERE Artst.Firma = Firma AND Artst.Artnr = nArtnr AND Artst.Inhalt = nInhalt AND Artst.Jahr = nJahr NO-ERROR. FIND Debst NO-LOCK USE-INDEX Debst-k1 WHERE Debst.Firma = Firma AND Debst.Knr = nKnr NO-ERROR. PreisGrp = Debst.Preis_Grp. FIND Wust NO-LOCK USE-INDEX Wust-k1 WHERE Wust.CodeK = Debst.MWST AND Wust.CodeA = 99 NO-ERROR. lInkl = Wust.Incl. FIND AbwPrGrp NO-LOCK USE-INDEX AbwPrGrp-k1 WHERE AbwPrGrp.Firma = Firma AND AbwPrGrp.Knr = SpezPrei.Knr AND AbwPrGrp.Wg_Grp = Artst.Wg_Grp NO-ERROR. IF AVAILABLE AbwPrGrp THEN PreisGrp = AbwPrGrp.Preis_Grp. FIND LAST ArtPreis NO-LOCK USE-INDEX ArtPreis-k1 WHERE ArtPreis.Firma = Firma AND ArtPreis.Artnr = nArtnr AND ArtPreis.Inhalt = nInhalt AND ArtPreis.Jahr = nJahr AND ArtPreis.Preis_Grp = PreisGrp AND ArtPreis.Ab_Datum <= TODAY AND ArtPreis.Aktion = FALSE AND ArtPreis.Aktiv = TRUE NO-ERROR. IF NOT AVAILABLE ArtPreis THEN DO: FIND LAST ArtPreis NO-LOCK USE-INDEX ArtPreis-k1 WHERE ArtPreis.Firma = Firma AND ArtPreis.Artnr = nArtnr AND ArtPreis.Inhalt = nInhalt AND ArtPreis.Jahr = nJahr AND ArtPreis.Preis_Grp = Debst.Preis_Grp AND ArtPreis.Ab_Datum <= TODAY AND ArtPreis.Aktion = FALSE AND ArtPreis.Aktiv = TRUE NO-ERROR. END. IF NOT AVAILABLE ArtPreis THEN DO: FIND LAST ArtPreis NO-LOCK USE-INDEX ArtPreis-k1 WHERE ArtPreis.Firma = Firma AND ArtPreis.Artnr = nArtnr AND ArtPreis.Inhalt = nInhalt AND ArtPreis.Jahr = nJahr AND ArtPreis.Preis_Grp = FwPreisGrp AND ArtPreis.Ab_Datum <= TODAY AND ArtPreis.Aktion = FALSE AND ArtPreis.Aktiv = TRUE NO-ERROR. END. DO WITH FRAME {&FRAME-NAME}: Ansatz = ArtPreis.VK_Brutto * 100 / ArtPreis.VK_Netto. IF lInkl THEN rowObject.VP_Norm:SCREEN-VALUE = STRING(ArtPreis.VK_Brutto). ELSE rowObject.VP_Norm:SCREEN-VALUE = STRING(ArtPreis.VK_Netto). VK_Netto = DECIMAL(rowObject.VP_Norm:SCREEN-VALUE). IF CB_Art:SCREEN-VALUE = 'P' THEN VK_Spez = VK_Netto * (100 - Wert) / 100. ELSE VK_Spez = Wert. IF lInkl THEN VK_Spez = VK_Spez / Ansatz * 100. IF Artst.Listen_EP = 0 THEN Marge = 0. ELSE Marge = 100 - (Artst.Listen_EP * 100 / VK_Spez). rowObject.Marge:SCREEN-VALUE = STRING(Marge). END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE cancelRecord vTableWin PROCEDURE cancelRecord : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ FCancel = TRUE. DO WITH FRAME {&FRAME-NAME}: RUN ENABLE_DISABLE ( INPUT TRUE ). END. RUN SUPER. /* Code placed here will execute AFTER standard behavior. */ END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE copyRecord vTableWin PROCEDURE copyRecord : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DO WITH FRAME {&FRAME-NAME}: RUN ENABLE_DISABLE ( INPUT FALSE ). END. cArtikel = DYNAMIC-FUNCTION('getArtikel':U) NO-ERROR. IF cArtikel = '' OR cArtikel = ? THEN DO: DYNAMIC-FUNCTION('setFlagAbbruch':U, INPUT TRUE, Progname) NO-ERROR. RETURN NO-APPLY. END. nArtnr = INTEGER(ENTRY(2, cArtikel, CHR(01))). nInhalt = INTEGER(ENTRY(3, cArtikel, CHR(01))). nJahr = INTEGER(ENTRY(4, cArtikel, CHR(01))). FNeu = TRUE. FMut = TRUE. FCopy = TRUE. FDisp = TRUE. RUN SUPER. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE deleteRecord vTableWin PROCEDURE deleteRecord : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR Ja AS LOG NO-UNDO. Ja = DYNAMIC-FUNCTION( 'ANTWORT_NEIN':U, INPUT 1000 ). IF NOT Ja THEN DO: RUN TOOLBAR IN hKontainer ( INPUT 'CANCEL':U ) NO-ERROR. RETURN NO-APPLY. END. RUN SUPER. /* Code placed here will execute AFTER standard behavior. */ END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disableFields vTableWin PROCEDURE disableFields : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEFINE INPUT PARAMETER pcFieldType AS CHARACTER NO-UNDO. DO WITH FRAME {&FRAME-NAME}: END. RUN SUPER( INPUT pcFieldType). IF NOT VALID-HANDLE(Fenster) THEN Fenster = FRAME {&FRAME-NAME}:CURRENT-ITERATION. RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&ENABLED-FIELDS}', INPUT TRUE ). RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&Eingabe}' , INPUT TRUE ). RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&List-6}' , INPUT FALSE ). IF NUM-ENTRIES('{&KEY_FELDER}', ',') > 0 THEN DO: RUN FARBE_FELDER ( INPUT Fenster, INPUT '{&KEY_FELDER}', INPUT 15 ). END. DO WITH FRAME {&FRAME-NAME}: ENABLE {&List-5}. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI vTableWin _DEFAULT-DISABLE PROCEDURE disable_UI : /*------------------------------------------------------------------------------ Purpose: DISABLE the User Interface Parameters: Notes: Here we clean-up the user-interface by deleting dynamic widgets we have created and/or hide frames. This procedure is usually called when we are ready to "clean-up" after running. ------------------------------------------------------------------------------*/ /* Hide all frames. */ HIDE FRAME F-Main. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE displayFields vTableWin PROCEDURE displayFields : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEFINE INPUT PARAMETER pcColValues AS CHARACTER NO-UNDO. DEF VAR VP AS DEC DECIMALS 4 NO-UNDO. DEF VAR Wert AS DEC DECIMALS 4 NO-UNDO. DEF VAR Betrag AS DEC DECIMALS 4 NO-UNDO. IF NOT FDisp THEN DO: FDisp = TRUE. RETURN. END. IF FCancel THEN pcColValues = OldColValues. IF NOT FNeu THEN OldColValues = pcColValues. OldColList = DYNAMIC-FUNCTION('getDisplayedFields':U). IF FNeu THEN RUN FEHLWERTE ( INPUT-OUTPUT pcColValues ). DO WITH FRAME {&FRAME-NAME}: END. RUN SUPER( INPUT pcColValues). FCancel = FALSE. DO WITH FRAME {&FRAME-NAME}: F_Knr:SCREEN-VALUE = rowObject.Knr:SCREEN-VALUE. CB_Art:SCREEN-VALUE = rowObject.Proz_Betr:SCREEN-VALUE NO-ERROR. VP = DECIMAL(rowObject.VP_Norm:SCREEN-VALUE). Wert = DECIMAL(rowObject.Wert:SCREEN-VALUE ). IF CB_Art:SCREEN-VALUE = 'P' THEN DO: F_Wert:LABEL = 'Preis'. Betrag = VP * (100 - Wert) / 100. F_Wert:SCREEN-VALUE = STRING(Betrag). END. ELSE DO: F_Wert:LABEL = 'Prozent'. Betrag = (100 - (Wert * 100 / VP)). F_Wert:SCREEN-VALUE = STRING(Betrag). END. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableFields vTableWin PROCEDURE enableFields : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ /* Code placed here will execute PRIOR to standard behavior. */ /* RUN SUPER. */ IF NOT VALID-HANDLE(Fenster) THEN Fenster = FRAME {&FRAME-NAME}:CURRENT-ITERATION. RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&ENABLED-FIELDS}' , INPUT FALSE ). RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&Eingabe}' , INPUT FALSE ). RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&List-6}' , INPUT TRUE ). IF NUM-ENTRIES('{&NUR_LESEN}', ',') > 0 THEN DO: RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&NUR_LESEN}', INPUT TRUE ). END. DO WITH FRAME {&FRAME-NAME}: IF CB_Art:SCREEN-VALUE = 'P' THEN F_Wert:LABEL = 'Preis'. ELSE F_Wert:LABEL = 'Prozent'. DISABLE {&List-5}. END. IF FNeu THEN RETURN. IF NUM-ENTRIES('{&KEY_FELDER}', ',') > 0 THEN DO: RUN SCHUETZE_FELDER ( INPUT Fenster, INPUT '{&KEY_FELDER}', INPUT TRUE ). END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject vTableWin PROCEDURE enableObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ /* Code placed here will execute PRIOR to standard behavior. */ RUN SUPER. { incl/viwenableobject.i } IF SAktiv THEN DO WITH FRAME {&FRAME-NAME}: RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&List-6}' , INPUT TRUE ). END. RUN ENABLE_DISABLE ( TRUE ). END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENABLE_DISABLE vTableWin PROCEDURE ENABLE_DISABLE : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF INPUT PARAMETER ipArt AS LOG NO-UNDO. DO WITH FRAME {&FRAME-NAME}: CASE ipArt: WHEN FALSE THEN DO: Btn_Kopieren:SENSITIVE = TRUE. Btn_Loeschen:SENSITIVE = TRUE. Btn_Excel :SENSITIVE = TRUE. Btn_Kopieren:LABEL = 'Ko&pieren'. END. OTHERWISE DO: Btn_Kopieren:SENSITIVE = TRUE . Btn_Loeschen:SENSITIVE = FALSE. Btn_Excel :SENSITIVE = FALSE. Btn_Kopieren:LABEL = 'Ko&pieren'. END. END CASE. F_Artnr :SCREEN-VALUE = ''. F_Inhalt:SCREEN-VALUE = ''. F_Jahr :SCREEN-VALUE = ''. F_Datum :SCREEN-VALUE = ''. F_Artnr :SENSITIVE = ipArt. F_Artnr :READ-ONLY = NOT ipArt. F_Artnr :TAB-STOP = ipArt. F_Inhalt:SENSITIVE = ipArt. F_Inhalt:READ-ONLY = NOT ipArt. F_Inhalt:TAB-STOP = ipArt. F_Jahr :SENSITIVE = ipArt. F_Jahr :READ-ONLY = NOT ipArt. F_Jahr :TAB-STOP = ipArt. F_Datum :SENSITIVE = ipArt. F_Datum :READ-ONLY = NOT ipArt. F_Datum :TAB-STOP = ipArt. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_FELD_TEST vTableWin PROCEDURE ENTRY_FELD_TEST : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR nPreis AS DEC DECIMALS 4 NO-UNDO. DEF VAR nWert AS DEC DECIMALS 4 NO-UNDO. DEF VAR nBetrag AS DEC DECIMALS 4 NO-UNDO. { incl/viwentryfeldtest.i } DO WITH FRAME {&FRAME-NAME}: CASE FeldName: WHEN 'F_Wert' THEN DO: nWert = DECIMAL(rowObject.Wert:SCREEN-VALUE). IF nWert = 0 THEN RETURN ''. nPreis = DECIMAL(rowObject.VP_Norm:SCREEN-VALUE). IF CB_Art:SCREEN-VALUE = 'P' THEN DO: nBetrag = nPreis * (100 - nWert) / 100. ipHandle:SCREEN-VALUE = STRING(nBetrag). END. ELSE DO: nBetrag = 100 - (nWert * 100 / nPreis). ipHandle:SCREEN-VALUE = STRING(nBetrag). END. RUN BERECHNEN. ipHandle:MODIFIED = FALSE. END. END CASE. END. RETURN ''. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE FEHLWERTE vTableWin PROCEDURE FEHLWERTE : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF INPUT-OUTPUT PARAMETER pcColValues AS CHAR NO-UNDO. DEF VAR i1 AS INT NO-UNDO. IF FCancel THEN RETURN. IF NOT FCopy THEN DO WITH FRAME {&FRAME-NAME}: i1 = LOOKUP('Firma', oldColList, ',') + 1. ENTRY(i1, pcColValues, CHR(01)) = Firma NO-ERROR. i1 = LOOKUP('Proz_Betr', oldColList, ',') + 1. ENTRY(i1, pcColValues, CHR(01)) = STRING(FALSE,rowObject.Proz_Betr:FORMAT) NO-ERROR. END. IF FCopy THEN DO: END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE FIND_DEBITOR vTableWin PROCEDURE FIND_DEBITOR : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR iRecid AS RECID NO-UNDO. DEF VAR cInput AS CHAR NO-UNDO. DO WITH FRAME {&FRAME-NAME}: cInput = 'DEB;' + TRIM(F_Knr:SCREEN-VALUE). RUN 'g-suchen-adresse.w':U ( cInput, OUTPUT iRecid ). IF iRecid = ? OR iRecid = 0 THEN RETURN 'ERROR'. FIND Adresse NO-LOCK WHERE RECID(Adresse) = iRecid NO-ERROR. lLeave = FALSE. iKnr = Adresse.Knr. F_Knr:SCREEN-VALUE = STRING(Adresse.Knr,'999999'). rowObject.Knr:SCREEN-VALUE = STRING(Adresse.Knr,'999999'). rowObject.Kunde:SCREEN-VALUE = Adresse.Anzeig_Br. RUN BERECHNEN. APPLY 'ENTRY' TO rowObject.Menge. lLeave = TRUE. RETURN NO-APPLY ''. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE KOPF vTableWin PROCEDURE KOPF : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF INPUT PARAMETER eh AS COM-HANDLE NO-UNDO. DEF VAR Zelle AS CHAR NO-UNDO. FIND Steuer USE-INDEX Steuer-k1 WHERE Steuer.Firma = Firma NO-LOCK NO-ERROR. Zelle = 'Links1'. eh:Range(Zelle):SELECT. eh:SELECTION:VALUE = Steuer.Firma1. Zelle = 'D1'. eh:Range(Zelle):SELECT. eh:SELECTION:VALUE = 'Alle Kunden dieses Artikel mit Spezpreis'. Zelle = 'Rechts1'. eh:Range(Zelle):SELECT. eh:SELECTION:VALUE = 'Datum : ' + STRING(TODAY,'99.99.9999'). Zelle = 'Links2'. eh:Range(Zelle):SELECT. eh:SELECTION:VALUE = Steuer.Ort. Zelle = 'D2'. eh:Range(Zelle):SELECT. eh:SELECTION:VALUE = ''. Zelle = 'Rechts2'. eh:Range(Zelle):SELECT. eh:SELECTION:VALUE = 'Zeit : ' + STRING(TIME,'HH:MM:SS'). END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE KOPIEREN vTableWin PROCEDURE KOPIEREN : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR Artnr AS INT NO-UNDO. DEF VAR Inhalt AS INT NO-UNDO. DEF VAR Jahr AS INT NO-UNDO. DEF VAR iArtnr AS INT NO-UNDO. DEF VAR iInhalt AS INT NO-UNDO. DEF VAR iJahr AS INT NO-UNDO. DO WITH FRAME {&FRAME-NAME}: ASSIGN {&List-6}. Artnr = INTEGER(rowObject.Artnr :SCREEN-VALUE). Inhalt = INTEGER(rowObject.Inhalt:SCREEN-VALUE). Jahr = INTEGER(rowObject.Jahr :SCREEN-VALUE). FIND Artst NO-LOCK USE-INDEX Artst-k1 WHERE Artst.Firma = Firma AND Artst.Artnr = F_Artnr AND Artst.Inhalt = F_Inhalt AND Artst.Jahr = F_Jahr NO-ERROR. IF NOT AVAILABLE Artst THEN DO: RUN FEHLER ( INPUT 1042 ) NO-ERROR. APPLY 'ENTRY' TO F_Artnr. RETURN NO-APPLY. END. IF Artnr = F_Artnr AND Inhalt = F_Inhalt AND Jahr = F_Jahr THEN DO: MESSAGE 'Kopieren in den selben/gleichen Artikel nicht möglich!' VIEW-AS ALERT-BOX ERROR. APPLY 'ENTRY' TO F_Artnr. RETURN NO-APPLY. END. EMPTY TEMP-TABLE TSpezPrei. FOR EACH SpezPrei NO-LOCK USE-INDEX Spezprei-k2 WHERE SpezPrei.Firma = Firma AND SpezPrei.Artnr = Artnr AND SpezPrei.Inhalt = Inhalt AND SpezPrei.Jahr = Jahr : CREATE TSpezPrei. BUFFER-COPY SpezPrei EXCEPT Artnr Inhalt Jahr TO TSpezPrei ASSIGN TSpezPrei.Artnr = F_Artnr TSpezPrei.Inhalt = F_Inhalt TSpezPrei.Jahr = F_Jahr. END. REPEAT TRANSACTION: FOR EACH TSpezPrei. FIND SpezPrei OF TSpezPrei NO-ERROR. IF NOT AVAILABLE SpezPrei THEN CREATE SpezPrei. BUFFER-COPY TSpezPrei TO SpezPrei. END. RELEASE SpezPrei. LEAVE. END. RUN ENABLE_DISABLE ( INPUT FALSE ). APPLY 'U1'. RETURN NO-APPLY. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE LEAVE_FELD_TEST vTableWin PROCEDURE LEAVE_FELD_TEST : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ { incl/viwleavefeldtest.i } DEF VAR nPreis AS DEC DECIMALS 4 NO-UNDO. DEF VAR nWert AS DEC DECIMALS 4 NO-UNDO. DEF VAR nBetrag AS DEC DECIMALS 4 NO-UNDO. DO WHILE FNeu WITH FRAME {&FRAME-NAME}: CASE FeldName: WHEN 'F_Knr' THEN DO WITH FRAME {&FRAME-NAME}: F_Knr = SELF:SCREEN-VALUE. iKnr = INTEGER(F_Knr) NO-ERROR. IF ERROR-STATUS:ERROR THEN DO: RUN FIND_DEBITOR. IF RETURN-VALUE = 'ERROR' THEN DO: APPLY 'ENTRY' TO F_Knr. RETURN 'APPLY'. END. END. FIND Adresse NO-LOCK USE-INDEX Adresse-k1 WHERE Adresse.Firma = AdFirma AND Adresse.Knr = iKnr NO-ERROR. IF NOT AVAILABLE Adresse THEN DO: RUN FIND_DEBITOR. IF RETURN-VALUE = 'ERROR' THEN DO: APPLY 'ENTRY' TO F_Knr. RETURN 'APPLY'. END. END. IF Adresse.Aktiv = FALSE THEN DO: RUN FEHLER ( INPUT 1021 ). RETURN 'ERROR'. END. iKnr = Adresse.Knr. FIND Debst NO-LOCK USE-INDEX Debst-k1 WHERE Debst.Firma = Firma AND Debst.Knr = iKnr NO-ERROR. IF NOT AVAILABLE Debst THEN DO: RUN FEHLER ( INPUT 1016 ). RETURN 'ERROR'. END. IF Debst.Aktiv = FALSE THEN DO: RUN FEHLER ( INPUT 1019 ). RETURN 'ERROR'. END. rowObject.Kunde:SCREEN-VALUE = Adresse.Anzeig_Br. rowObject.Knr :SCREEN-VALUE = STRING(Adresse.Knr). F_Knr :SCREEN-VALUE = STRING(Adresse.Knr). RUN BERECHNEN. RETURN ''. END. WHEN 'Menge' THEN DO: IF KEYFUNCTION(LASTKEY) = 'BACK-TAB' THEN RETURN. IF VALID-HANDLE(hENTER) THEN DO: IF hENTER:NAME = 'F_Knr' THEN RETURN. END. nArtnr = INTEGER(rowObject.Artnr:SCREEN-VALUE). nInhalt = INTEGER(rowObject.Inhalt:SCREEN-VALUE). nJahr = INTEGER(rowObject.Jahr:SCREEN-VALUE). FIND SpezPrei NO-LOCK USE-INDEX SpezPrei-k1 WHERE SpezPrei.Firma = Firma AND SpezPrei.Knr = iKnr AND SpezPrei.Artnr = nArtnr AND SpezPrei.Inhalt = nInhalt AND SpezPrei.Jahr = nJahr AND SpezPrei.Menge = DECIMAL(FeldInhalt) NO-ERROR. IF AVAILABLE SpezPrei THEN DO: RUN FEHLER ( INPUT 1043 ). RETURN 'ERROR'. END. RETURN ''. END. END CASE. LEAVE. END. DO WHILE TRUE WITH FRAME {&FRAME-NAME}: CASE FeldName: WHEN 'Ab_Datum' THEN DO: IF DATE(FeldInhalt) = ? THEN ipHandle:SCREEN-VALUE = STRING(TODAY). END. WHEN 'Bis_Datum' THEN DO: IF DATE(FeldInhalt) = ? THEN ipHandle:SCREEN-VALUE = STRING(DATE(12,31,2099)). END. WHEN 'F_Wert' THEN DO: IF ipHandle:MODIFIED = TRUE THEN DO: nBetrag = DECIMAL(FeldInhalt). nPreis = DECIMAL(rowObject.VP_Norm:SCREEN-VALUE). nWert = DECIMAL(rowObject.Wert:SCREEN-VALUE ). IF CB_Art:SCREEN-VALUE = 'P' THEN DO: nWert = 100 - (nBetrag * 100 / nPreis). rowObject.Wert:SCREEN-VALUE = STRING(nWert). END. ELSE DO: nWert = nPreis * (100 - nBetrag) / 100. rowObject.Wert:SCREEN-VALUE = STRING(nWert). END. RUN BERECHNEN. RETURN 'ERROR'. END. END. END CASE. LEAVE. END. IF LOOKUP(FeldName, '{&LETZTES_FELD}', ',') > 0 THEN DO: DO WHILE TRUE: IF KEYFUNCTION(LKY) = 'TAB' THEN LEAVE. IF KEYFUNCTION(LKY) = 'RETURN' THEN LEAVE. IF KEYFUNCTION(LKY) = 'F9' THEN LEAVE. RETURN ''. END. APPLY 'ALT-S'. RETURN 'APPLY'. END. RETURN ''. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE LOESCHEN vTableWin PROCEDURE LOESCHEN : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR Ja AS LOG NO-UNDO. DEF VAR dHandle AS HANDLE NO-UNDO. DEF VAR Artnr AS INT NO-UNDO. DEF VAR Inhalt AS INT NO-UNDO. DEF VAR Jahr AS INT NO-UNDO. DO WITH FRAME {&FRAME-NAME}: IF KEYFUNCTION(LASTKEY) <> 'RETURN' THEN DO: F_Datum:SCREEN-VALUE = ''. F_Datum:SENSITIVE = FALSE. F_Datum:TAB-STOP = FALSE. ENABLE {&List-5}. APPLY 'U1'. RETURN NO-APPLY. END. IF DATE(F_Datum:SCREEN-VALUE) = ? THEN DO: F_Datum:SCREEN-VALUE = ''. F_Datum:SENSITIVE = FALSE. F_Datum:TAB-STOP = FALSE. ENABLE {&List-5}. APPLY 'U1'. RETURN NO-APPLY. END. Artnr = INTEGER(rowObject.Artnr :SCREEN-VALUE). Inhalt = INTEGER(rowObject.Inhalt:SCREEN-VALUE). Jahr = INTEGER(rowObject.Jahr :SCREEN-VALUE). FIND Artst USE-INDEX Artst-k1 WHERE Artst.Firma = Firma AND Artst.Artnr = Artnr AND Artst.Inhalt = Inhalt AND Artst.Jahr = Jahr NO-LOCK NO-ERROR. IF NOT AVAILABLE Artst THEN DO: RUN FEHLER ( INPUT 1042 ). F_Datum:SCREEN-VALUE = ''. F_Datum:SENSITIVE = FALSE. F_Datum:TAB-STOP = FALSE. ENABLE {&List-5}. APPLY 'U1'. RETURN NO-APPLY. END. Ja = FALSE. F_Datum = DATE(F_Datum:SCREEN-VALUE). MESSAGE 'Wollen Sie alle Spezialpreise mit Gültigkeit ' SKIP 'bis ' STRING(F_Datum,'99.99.9999') ' dieses Artikels löschen ? ' VIEW-AS ALERT-BOX QUESTION BUTTONS YES-NO UPDATE Ja. IF NOT Ja THEN DO: F_Datum:SCREEN-VALUE = ''. F_Datum:SENSITIVE = FALSE. F_Datum:TAB-STOP = FALSE. ENABLE {&List-5}. APPLY 'U1'. RETURN NO-APPLY. END. FOR EACH SpezPrei USE-INDEX SpezPrei-k2 WHERE SpezPrei.Firma = Firma AND SpezPrei.Artnr = Artnr AND SpezPrei.Inhalt = Inhalt AND SpezPrei.Jahr = Jahr AND SpezPrei.Bis_Datum <= F_Datum TRANSACTION: DELETE SpezPrei. END. dHandle = DYNAMIC-FUNCTION('getDataSource':U) NO-ERROR. IF VALID-HANDLE(dHandle) THEN DYNAMIC-FUNCTION('openQuery':U IN dHandle ) NO-ERROR. F_Datum:SCREEN-VALUE = ''. F_Datum:SENSITIVE = FALSE. F_Datum:TAB-STOP = FALSE. ENABLE {&List-5}. APPLY 'U1'. RETURN NO-APPLY. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE LOESCHEN_INAKT vTableWin PROCEDURE LOESCHEN_INAKT : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ SESSION:SET-WAIT-STATE('GENERAL'). FOR EACH Artst USE-INDEX Artst-k1 WHERE Artst.Firma = Firma AND Artst.Aktiv = FALSE NO-LOCK: FOR EACH SpezPrei USE-INDEX SpezPrei-k2 WHERE SpezPrei.Firma = Artst.Firma AND SpezPrei.Artnr = Artst.Artnr AND SpezPrei.Inhalt = Artst.Inhalt AND SpezPrei.Jahr = Artst.Jahr: DELETE SpezPrei. END. RELEASE SpezPrei. RELEASE Artst. END. SESSION:SET-WAIT-STATE(''). END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE REPORT vTableWin PROCEDURE REPORT : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR excelAppl AS COM-HANDLE NO-UNDO. DEF VAR DatenName AS CHAR NO-UNDO. DEF VAR DateiName AS CHAR NO-UNDO. DEF VAR Zelle AS CHAR NO-UNDO. DEF VAR xText AS CHAR NO-UNDO. DEF VAR Ja AS LOG NO-UNDO. DEF VAR KGeb AS CHAR NO-UNDO. DEF VAR cArtikel AS CHAR NO-UNDO. DEF VAR Artikel AS CHAR NO-UNDO. DEF VAR Kunde AS CHAR NO-UNDO. DEF VAR ARecid AS RECID NO-UNDO. Firma = DYNAMIC-FUNCTION('getMandant':U) NO-ERROR. cArtikel = DYNAMIC-FUNCTION('getArtikel':U) NO-ERROR. IF cArtikel = '' OR cArtikel = ? THEN RETURN NO-APPLY. ARecid = INTEGER(ENTRY(1, cArtikel, CHR(01))). FIND Artst WHERE RECID(Artst) = ARecid NO-LOCK NO-ERROR. FIND FIRST ArtBez OF Artst NO-LOCK NO-ERROR. FIND KGebinde USE-INDEX KGebinde-k1 WHERE KGebinde.Firma = Firma AND KGebinde.Geb_Cd = Artst.KGeb_Cd NO-LOCK NO-ERROR. IF AVAILABLE KGebinde THEN KGeb = KGebinde.KBez. ELSE KGeb = FILL('?', 10). Artikel = STRING(Artst.Artnr,'999999 ') + Artbez.Bez1. IF Artbez.Bez2 <> '' THEN Artikel = Artikel + ', ' + Artbez.Bez2. Artikel = Artikel + ' / ' + KGeb. IF Artst.Jahr > 1900 THEN Artikel = Artikel + ' / ' + STRING(Artst.Jahr,'9999'). IF Artst.Alk_Gehalt > 0 THEN Artikel = Artikel + ' / ' + STRING(Artst.Alk_Gehalt,'zz9.99%'). DatenName = 'ArtikelSpezialPreise.txt'. DateiName = 'ArtikelSpezialPreise.xls' + CHR(01) + 'ArtikelSpezialPreise.xls'. DO WITH FRAME {&FRAME-NAME}: DO WHILE TRUE: excelAppl = DYNAMIC-FUNCTION('CREATEEXCEL':U) NO-ERROR. IF NOT VALID-HANDLE(excelAppl) THEN DO: RUN FEHLER ( INPUT 1035 ). RETURN NO-APPLY. END. LEAVE. END. DO WHILE TRUE: RUN CREATEDATEI ( INPUT DateiName ). IF NOT RETURN-VALUE BEGINS 'ERROR-' THEN LEAVE. CASE RETURN-VALUE: WHEN 'ERROR-PARAMETER' THEN DO: RUN FEHLER ( INPUT 1036 ). RETURN NO-APPLY. END. WHEN 'ERROR-LOESCHEN' THEN DO: RUN FEHLER ( INPUT 1037 ). RETURN NO-APPLY. END. WHEN 'ERROR-VORLAGE' THEN DO: RUN FEHLER ( INPUT 1038 ). RETURN NO-APPLY. END. OTHERWISE DO: MESSAGE RETURN-VALUE VIEW-AS ALERT-BOX ERROR. RETURN NO-APPLY. END. END CASE. LEAVE. END. DateiName = RETURN-VALUE. DO WHILE TRUE: RUN CREATEDATEI ( INPUT DatenName ). IF NOT RETURN-VALUE BEGINS 'ERROR-' THEN LEAVE. CASE RETURN-VALUE: WHEN 'ERROR-PARAMETER' THEN DO: RUN FEHLER ( INPUT 1036 ). RETURN NO-APPLY. END. WHEN 'ERROR-LOESCHEN' THEN DO: RUN FEHLER ( INPUT 1037 ). RETURN NO-APPLY. END. WHEN 'ERROR-VORLAGE' THEN DO: RUN FEHLER ( INPUT 1038 ). RETURN NO-APPLY. END. OTHERWISE DO: MESSAGE RETURN-VALUE VIEW-AS ALERT-BOX ERROR. RETURN NO-APPLY. END. END CASE. LEAVE. END. DatenName = RETURN-VALUE. OUTPUT TO VALUE(DatenName) APPEND. PUT CONTROL '£' Artikel CHR(10). PUT CONTROL '£Knr£Kunde£Menge£ab£bis£P/B£Wert' CHR(10) '£' CHR(10). FOR EACH SpezPrei USE-INDEX SpezPrei-k2 WHERE SpezPrei.Firma = Firma AND SpezPrei.Artnr = Artst.Artnr AND SpezPrei.Inhalt = Artst.Inhalt AND SpezPrei.Jahr = Artst.Jahr NO-LOCK: Kunde = DYNAMIC-FUNCTION('GETADRESSEANZEIGEBR':U, INPUT SpezPrei.Knr, INPUT 0) NO-ERROR. PUT CONTROL '£'. PUT CONTROL STRING(SpezPrei.Knr ,'999999') '£' Kunde '£' STRING(SpezPrei.Menge ,'zzzzzz') '£' STRING(SpezPrei.Ab_Datum ,'99.99.9999') '£' STRING(SpezPrei.Bis_Datum,'99.99.9999') '£' STRING(SpezPrei.Proz_Betr,'%/Fr') '£' STRING(SpezPrei.Wert ,'>>>>9.999') CHR(10). END. OUTPUT CLOSE. RUN OPENEXCEL ( INPUT excelAppl, INPUT DateiName, INPUT '', OUTPUT Ja ). IF NOT Ja THEN DO: RUN FEHLER ( INPUT 1040 ). RETURN NO-APPLY. END. Zelle = 'A3'. excelAppl:Range(Zelle):SELECT. excelAppl:Selection:FormulaR1C1 = 'TEXT;' + DatenName. excelAppl:Application:RUN ( 'DateiEinfügen' ). RUN KOPF ( INPUT excelAppl ). Zelle = 'A1'. excelAppl:Range(Zelle):SELECT. excelAppl:Selection:ColumnWidth = 0.3. DYNAMIC-FUNCTION('RELEASEEXCEL':U, INPUT excelAppl ) NO-ERROR. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE RETURN_FELD vTableWin PROCEDURE RETURN_FELD : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ { incl/viwreturnfeld.i } END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE TEST_EINGABEN vTableWin PROCEDURE TEST_EINGABEN : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF OUTPUT PARAMETER opJa AS LOG NO-UNDO. DEF VAR eHandle AS HANDLE NO-UNDO. DEF VAR cString AS CHAR NO-UNDO. DEF VAR iNummer AS INT NO-UNDO. opJa = FALSE. eHandle = ?. IF NOT FMut THEN RETURN. AAA000: DO WHILE TRUE WITH FRAME {&FRAME-NAME}: LEAVE. END. IF VALID-HANDLE(eHandle) THEN DO: APPLY 'ENTRY' TO eHandle. RETURN NO-APPLY. END. opJa = TRUE. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE updateMode vTableWin PROCEDURE updateMode : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEFINE INPUT PARAMETER pcMode AS CHARACTER NO-UNDO. CASE pcMode: WHEN 'updateBegin' THEN DO: END. WHEN 'updateEnd' THEN DO: END. END. RUN SUPER( INPUT pcMode). CASE pcMode: WHEN 'updateBegin' THEN DO: FMut = TRUE. END. WHEN 'updateEnd' THEN DO: FNeu = FALSE. FMut = FALSE. FCopy = FALSE. END. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE updateRecord vTableWin PROCEDURE updateRecord : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DO WITH FRAME {&FRAME-NAME}: rowObject.Knr:SCREEN-VALUE = F_Knr:SCREEN-VALUE. rowObject.Proz_Betr:SCREEN-VALUE = CB_Art:SCREEN-VALUE. DYNAMIC-FUNCTION('SETMODIFIEDFLAG':U, INPUT Fenster, INPUT TRUE). rowObject.VP_Norm:MODIFIED = FALSE. rowObject.Marge:MODIFIED = FALSE. rowObject.AltPreis:MODIFIED = FALSE. F_Wert:MODIFIED = FALSE. END. FNeu = FALSE. FCopy = FALSE. RUN SUPER. /* Code placed here will execute AFTER standard behavior. */ END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME