| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678 |
- &ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2
- &ANALYZE-RESUME
- /* Connected Databases
- anadat PROGRESS
- */
- &Scoped-define WINDOW-NAME CURRENT-WINDOW
- {adecomm/appserv.i}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS dTables
- /*------------------------------------------------------------------------
- File:
- Description: from DATA.W - Template For SmartData objects in the ADM
- Input Parameters:
- <none>
- Output Parameters:
- <none>
- Modified: February 24, 1999
- ------------------------------------------------------------------------*/
- /* 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 ************************** */
- /* Parameters Definitions --- */
- /* Local Variable Definitions --- */
- DEF VAR iFaknr AS INT NO-UNDO.
- DEF VAR iKnr AS INT NO-UNDO.
- DEF VAR iAufnr AS INT NO-UNDO.
- DEF VAR lSelected AS LOG INIT FALSE NO-UNDO.
- &SCOPED-DEFINE Tabelle Savko
- &SCOPED-DEFINE TabWhere /* USE-INDEX Benutzer-k1 ~
- WHERE {&Tabelle}.Benutzer = tRowObject.Benutzer
- */
- { incl/datdefinition.i }
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
- /* ******************** Preprocessor Definitions ******************** */
- &Global-define DATA-LOGIC-PROCEDURE .p
- &Scoped-define PROCEDURE-TYPE SmartDataObject
- &Scoped-define DB-AWARE yes
- &Scoped-define ADM-SUPPORTED-LINKS Data-Source,Data-Target,Navigation-Target,Update-Target,Commit-Target,Filter-Target
- /* Db-Required definitions. */
- &IF DEFINED(DB-REQUIRED) = 0 &THEN
- &GLOBAL-DEFINE DB-REQUIRED TRUE
- &ENDIF
- &GLOBAL-DEFINE DB-REQUIRED-START &IF {&DB-REQUIRED} &THEN
- &GLOBAL-DEFINE DB-REQUIRED-END &ENDIF
- &Scoped-define QUERY-NAME Query-Main
- /* Internal Tables (found by Frame, Query & Browse Queries) */
- &Scoped-define INTERNAL-TABLES SavKo
- /* Definitions for QUERY Query-Main */
- &Scoped-Define ENABLED-FIELDS Firma Aufnr Faknr Knr Fak_Art Fak_Datum Auf_Tot U_Ref Auf_Datum Lief_Datum~
- Kunde lGeliefert
- &Scoped-define ENABLED-FIELDS-IN-SavKo Firma Aufnr Faknr Knr Fak_Art ~
- Fak_Datum Auf_Tot U_Ref Auf_Datum Lief_Datum lGeliefert
- &Scoped-Define DATA-FIELDS Firma Aufnr Faknr Knr Fak_Art Fak_Datum Auf_Tot U_Ref Auf_Datum Lief_Datum~
- Kunde lGeliefert
- &Scoped-define DATA-FIELDS-IN-SavKo Firma Aufnr Faknr Knr Fak_Art Fak_Datum ~
- Auf_Tot U_Ref Auf_Datum Lief_Datum lGeliefert
- &Scoped-Define MANDATORY-FIELDS Firma Knr
- &Scoped-Define APPLICATION-SERVICE
- &Scoped-Define ASSIGN-LIST
- &Scoped-Define DATA-FIELD-DEFS "d-savko.i"
- &Scoped-Define DATA-TABLE-NO-UNDO NO-UNDO
- &Scoped-define QUERY-STRING-Query-Main FOR EACH SavKo NO-LOCK INDEXED-REPOSITION
- {&DB-REQUIRED-START}
- &Scoped-define OPEN-QUERY-Query-Main OPEN QUERY Query-Main FOR EACH SavKo NO-LOCK INDEXED-REPOSITION.
- {&DB-REQUIRED-END}
- &Scoped-define TABLES-IN-QUERY-Query-Main SavKo
- &Scoped-define FIRST-TABLE-IN-QUERY-Query-Main SavKo
- /* Custom List Definitions */
- /* List-1,List-2,List-3,List-4,List-5,List-6 */
- /* _UIB-PREPROCESSOR-BLOCK-END */
- &ANALYZE-RESUME
- /* ************************ Function Prototypes ********************** */
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD getCurrentRecid dTables _DB-REQUIRED
- FUNCTION getCurrentRecid RETURNS RECID
- ( /* parameter-definitions */ ) FORWARD.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD getQueryBuffer dTables _DB-REQUIRED
- FUNCTION getQueryBuffer RETURNS HANDLE
- ( /* parameter-definitions */ ) FORWARD.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD openQuery dTables _DB-REQUIRED
- FUNCTION openQuery RETURNS LOGICAL
- ( /* parameter-definitions */ ) FORWARD.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD setSelectedSavko dTables _DB-REQUIRED
- FUNCTION setSelectedSavko RETURNS LOGICAL
- ( ipRecid AS RECID, ipFaknr AS INT, ipKnr AS INT, ipAufnr AS INT ) FORWARD.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- /* *********************** Control Definitions ********************** */
- {&DB-REQUIRED-START}
- /* Query definitions */
- &ANALYZE-SUSPEND
- DEFINE QUERY Query-Main FOR
- SavKo SCROLLING.
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- /* ************************ Frame Definitions *********************** */
- /* *********************** Procedure Settings ************************ */
- &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
- /* Settings for THIS-PROCEDURE
- Type: SmartDataObject
- Allow: Query
- Frames: 0
- Add Fields to: Neither
- Other Settings: PERSISTENT-ONLY COMPILE APPSERVER DB-AWARE
- */
- /* 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 dTables ASSIGN
- HEIGHT = 1.62
- WIDTH = 70.4.
- /* END WINDOW DEFINITION */
- */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB dTables
- /* ************************* Included-Libraries *********************** */
- {src/adm2/data.i}
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- /* *********** Runtime Attributes and AppBuilder Settings *********** */
- &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
- /* SETTINGS FOR WINDOW dTables
- VISIBLE,,RUN-PERSISTENT */
- /* _RUN-TIME-ATTRIBUTES-END */
- &ANALYZE-RESUME
- /* Setting information for Queries and Browse Widgets fields */
- &ANALYZE-SUSPEND _QUERY-BLOCK QUERY Query-Main
- /* Query rebuild information for SmartDataObject Query-Main
- _TblList = "AnaDat.SavKo"
- _Options = "NO-LOCK INDEXED-REPOSITION"
- _FldNameList[1] > AnaDat.SavKo.Firma
- "Firma" "Firma" ? ? "character" ? ? ? ? ? ? yes ? yes 8 yes ?
- _FldNameList[2] > AnaDat.SavKo.Aufnr
- "Aufnr" "Aufnr" ? ? "integer" ? ? ? ? ? ? yes ? no 7.2 yes ?
- _FldNameList[3] > AnaDat.SavKo.Faknr
- "Faknr" "Faknr" ? ? "integer" ? ? ? ? ? ? yes ? no 7.2 yes ?
- _FldNameList[4] > AnaDat.SavKo.Knr
- "Knr" "Knr" ? ? "integer" ? ? ? ? ? ? yes ? yes 7.2 yes ?
- _FldNameList[5] > AnaDat.SavKo.Fak_Art
- "Fak_Art" "Fak_Art" "Art" ? "integer" ? ? ? ? ? ? yes ? no 7.4 yes ?
- _FldNameList[6] > AnaDat.SavKo.Fak_Datum
- "Fak_Datum" "Fak_Datum" "Fakt. Datum" ? "date" ? ? ? ? ? ? yes ? no 11 yes ?
- _FldNameList[7] > AnaDat.SavKo.Auf_Tot
- "Auf_Tot" "Auf_Tot" "Auftr. Total" ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
- _FldNameList[8] > AnaDat.SavKo.U_Ref
- "U_Ref" "U_Ref" "Uns. Referenz" ? "character" ? ? ? ? ? ? yes ? no 20 yes ?
- _FldNameList[9] > AnaDat.SavKo.Auf_Datum
- "Auf_Datum" "Auf_Datum" "Auftr. Datum" ? "date" ? ? ? ? ? ? yes ? no 10.8 yes ?
- _FldNameList[10] > AnaDat.SavKo.Lief_Datum
- "Lief_Datum" "Lief_Datum" "Lief. Datum" ? "date" ? ? ? ? ? ? yes ? no 10.8 yes ?
- _FldNameList[11] > "_<CALC>"
- "DYNAMIC-FUNCTION('getAdressAnzeige':U, RowObject.Knr)" "Kunde" "Kunde" "x(60)" "character" ? ? ? ? ? ? yes ? no 60 no ?
- _FldNameList[12] > AnaDat.SavKo.lGeliefert
- "lGeliefert" "lGeliefert" ? ? "logical" ? ? ? ? ? ? yes ? no 8.2 yes ?
- _Design-Parent is WINDOW dTables @ ( 1.14 , 2.6 )
- */ /* QUERY Query-Main */
- &ANALYZE-RESUME
-
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK dTables
- /* *************************** Main Block *************************** */
- { incl/datmainblock.i }
-
- fDesc = TRUE.
- cSort = 'Fak_Datum'.
- &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
- RUN initializeObject.
- &ENDIF
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- /* ********************** Internal Procedures *********************** */
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE DATA.CALCULATE dTables DATA.CALCULATE _DB-REQUIRED
- PROCEDURE DATA.CALCULATE :
- /*------------------------------------------------------------------------------
- Purpose: Calculate all the Calculated Expressions found in the
- SmartDataObject.
- Parameters: <none>
- ------------------------------------------------------------------------------*/
- ASSIGN
- rowObject.Kunde = (DYNAMIC-FUNCTION('getAdressAnzeige':U, RowObject.Knr))
- .
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE dataAvailable dTables _DB-REQUIRED
- PROCEDURE dataAvailable :
- /*------------------------------------------------------------------------------
- Purpose: Super Override
- Parameters:
- Notes:
- ------------------------------------------------------------------------------*/
- { incl/datdataavailable.i }
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI dTables _DEFAULT-DISABLE
- PROCEDURE disable_UI :
- /*------------------------------------------------------------------------------
- Purpose: DISABLE the User Interface
- Parameters: <none>
- 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. */
- IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE INAKTIVIEREN dTables _DB-REQUIRED
- PROCEDURE INAKTIVIEREN :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- { incl/datinaktivieren.i }
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject dTables _DB-REQUIRED
- PROCEDURE initializeObject :
- /*------------------------------------------------------------------------------
- Purpose: Super Override
- Parameters:
- Notes:
- ------------------------------------------------------------------------------*/
- { incl/datinitialize.i }
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE REAKTIVIEREN dTables _DB-REQUIRED
- PROCEDURE REAKTIVIEREN :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- { incl/datreaktivieren.i }
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE REPOS_TABELLE dTables _DB-REQUIRED
- PROCEDURE REPOS_TABELLE :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- { incl/datrepos.i }
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SET_FILTER dTables _DB-REQUIRED
- PROCEDURE SET_FILTER :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- { incl/datsetfilter.i }
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SET_OPENFLAG dTables _DB-REQUIRED
- PROCEDURE SET_OPENFLAG :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- { incl/datsetopenflag.i }
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SET_SORT dTables _DB-REQUIRED
- PROCEDURE SET_SORT :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEF INPUT PARAMETER ipFeld AS CHAR NO-UNDO.
- DEF VAR cFields AS CHAR NO-UNDO.
- DEF VAR qBuffer AS HANDLE NO-UNDO.
- DEF VAR qbFeld AS HANDLE NO-UNDO.
- DEF VAR cTables AS CHAR NO-UNDO.
- cFields = DYNAMIC-FUNCTION('getDataColumns':U ) NO-ERROR.
- IF LOOKUP(ipFeld, cFields, ',') = 0 THEN RETURN NO-APPLY.
-
- cTables = DYNAMIC-FUNCTION('getQueryTables':U ) NO-ERROR.
- cTables = ENTRY(1, cTables, ' ') NO-ERROR.
- CREATE BUFFER qBuffer FOR TABLE cTables NO-ERROR.
- qbFeld = qBuffer:BUFFER-FIELD(ipFeld) NO-ERROR.
- IF NOT VALID-HANDLE(qbFeld) THEN DO:
- DELETE OBJECT qBuffer.
- RUN MELDUNG ( 8013 ).
- RETURN NO-APPLY.
- END.
- DELETE OBJECT qBuffer.
- IF ipFeld = cSort THEN fDesc = NOT fDesc.
- ELSE DO:
- ASSIGN cSort = ipFeld
- fDesc = FALSE.
- END.
- /* fData = TRUE. */
- /* RUN dataAvailable ( INPUT 'SAME' ). */
- /* */
- /* FIND FIRST tRowObject NO-LOCK. */
- /* FIND {&Tabelle} */
- /* &IF '{&TabWhere}' NE '' */
- /* &THEN {&TabWhere} */
- /* &ELSE OF tRowObject */
- /* &ENDIF */
- /* NO-LOCK NO-ERROR. */
- /* IF AVAILABLE {&Tabelle} THEN cRowid = STRING(ROWID({&Tabelle})). */
- /* ELSE cRowid = ?. */
- DYNAMIC-FUNCTION('openQuery':U).
- /* IF cRowid <> ? THEN DYNAMIC-FUNCTION('fetchRowIdent':U, */
- /* INPUT cRowid, INPUT ? ). */
- /* { incl/datsetsort.i } */
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- /* ************************ Function Implementations ***************** */
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION getCurrentRecid dTables _DB-REQUIRED
- FUNCTION getCurrentRecid RETURNS RECID
- ( /* parameter-definitions */ ) :
- /*------------------------------------------------------------------------------
- Purpose:
- Notes:
- ------------------------------------------------------------------------------*/
- { incl/datgetcurrentrecid.i }
- END FUNCTION.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION getQueryBuffer dTables _DB-REQUIRED
- FUNCTION getQueryBuffer RETURNS HANDLE
- ( /* parameter-definitions */ ) :
- /*------------------------------------------------------------------------------
- Purpose:
- Notes:
- ------------------------------------------------------------------------------*/
- RETURN BUFFER rowObject:HANDLE.
- END FUNCTION.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION openQuery dTables _DB-REQUIRED
- FUNCTION openQuery RETURNS LOGICAL
- ( /* parameter-definitions */ ) :
- /*------------------------------------------------------------------------------
- Purpose: Super Override
- Notes:
- ------------------------------------------------------------------------------*/
- DEF VAR Felder AS CHAR NO-UNDO.
- DEF VAR Inhalt AS CHAR NO-UNDO.
- DEF VAR ix AS INT NO-UNDO.
- DEF VAR cFeld AS CHAR NO-UNDO.
- DEF VAR lJa AS LOG NO-UNDO.
- DEF VAR cString AS CHAR NO-UNDO.
-
- DEF VAR cSortFelder AS CHAR NO-UNDO
- INIT 'Faknr,Knr,Aufnr,Fak_Datum,Fak_Art'.
- DEF VAR cIndexAsc AS CHAR NO-UNDO
- INIT 'k9,k10,k1,k8,k6'.
- DEF VAR cIndexDes AS CHAR NO-UNDO
- INIT 'k11,k12,k1,k14,k13'.
- DEF VAR cIndex AS CHAR NO-UNDO.
- /* IF NOT fOpen THEN RETURN FALSE. */
- xWhere = ''.
- xSort = ''.
- xString = ''.
- cString = ''.
- Felder = DYNAMIC-FUNCTION('getForeignFields':U) NO-ERROR.
- Inhalt = DYNAMIC-FUNCTION('getForeignValues':U) NO-ERROR.
- IF cSort = '' THEN cIndex = 'USE-INDEX Savko-k14'.
- ELSE DO:
- ix = LOOKUP(cSort, cSortFelder, ',').
- IF ix = 0 THEN DO:
- MESSAGE 'Sortierung nach diesem Feld könnte länger dauern ! ' SKIP
- 'Soll trotzdem sortiert werden ? '
- VIEW-AS ALERT-BOX QUESTION BUTTONS YES-NO
- UPDATE lJa.
- IF NOT lJa THEN DO:
- APPLY 'U1'.
- RETURN NO-APPLY.
- END.
- cIndex = ''.
- END.
- ELSE DO:
- IF fDesc THEN cIndex = 'USE-INDEX Savko-' + ENTRY(ix, cIndexDes, ',').
- ELSE cIndex = 'USE-INDEX Savko-' + ENTRY(ix, cIndexAsc, ',').
- END.
- END.
- /* ix = LOOKUP('Firma', Felder, ',') / 2. */
- /* cFirma = ENTRY (ix , Inhalt, CHR(01)). */
- /* xWhere = 'Savko.Firma = ' + QUOTER(Firma) + ' '. */
- IF iFaknr > 0 OR
- iKnr > 0 OR
- iAufnr > 0 THEN DO:
- cIndex = 'USE-INDEX Savko-k6'.
- cString = SUBSTITUTE('AND Savko.Knr = &1', iKnr).
- END.
- xString = 'FOR EACH Savko &1 WHERE '
- + 'Savko.Firma = "&2" &3 '.
- xString = SUBSTITUTE(xString, cIndex, Firma, cString ).
- xString = xString + ' NO-LOCK INDEXED-REPOSITION '.
-
- { incl/datopenquery.i }
- IF cIndex > '' AND
- lSelected THEN xSort = ''.
- lSelected = FALSE.
- /* xString = xString + ' ' + xSort.*/
- IF xWhere <> '' THEN DYNAMIC-FUNCTION('setQueryWhere':U , INPUT xWhere ).
- IF xString <> '' THEN DYNAMIC-FUNCTION('setQueryString':U, INPUT xString).
- IF xSort <> '' THEN DYNAMIC-FUNCTION('setQuerySort':U , INPUT xSort ).
- RETURN SUPER( ).
- END FUNCTION.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
- {&DB-REQUIRED-START}
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION setSelectedSavko dTables _DB-REQUIRED
- FUNCTION setSelectedSavko RETURNS LOGICAL
- ( ipRecid AS RECID, ipFaknr AS INT, ipKnr AS INT, ipAufnr AS INT ) :
- /*------------------------------------------------------------------------------
- Purpose:
- Notes:
- ------------------------------------------------------------------------------*/
- DEF VAR cRowid AS CHAR NO-UNDO.
- DEF VAR cValues AS CHAR NO-UNDO.
-
- ASSIGN iFaknr = ipFaknr
- iKnr = ipKnr
- iAufnr = ipAufnr
- lSelected = TRUE.
- DYNAMIC-FUNCTION('openQuery':U) NO-ERROR.
- FIND Savko NO-LOCK WHERE RECID(Savko) = ipRecid NO-ERROR.
- IF NOT AVAILABLE Savko THEN RETURN FALSE.
- cRowid = STRING(ROWID(Savko)).
-
- cValues = DYNAMIC-FUNCTION('fetchRowIdent':U, cRowid, ? ) NO-ERROR.
-
- RETURN TRUE.
- END FUNCTION.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- {&DB-REQUIRED-END}
|