search

jcaillon / 3P

3P (short for Progress Programmers Pal), is a notepad++ plugin designed to help writing progress 4GL (OpenEdge ABL) code. It transforms notepad++ into a full featured IDE for openedge code editor, providing syntax checking, compilation, auto-completion, tool-tips and much more!
https://jcaillon.github.io/3P/
GNU General Public License v3.0
78 stars 35 forks source link

Unable to locate the browses queries in .w with the 3P code explorer #158

Open hgrandperrin opened 7 years ago

hgrandperrin commented 7 years ago

It is a bit boring to have to search by hand for the definitions of the browse queries The graphic world is clearly not the strength of 3P. Thanks in advance. Sorry for my poor English...

In short: in the list of items of code explorer, there are all events, proc, functions ... but we do not see the list of triggers as OPEN-QUERY of the browsers. This development would be desirable.

jcaillon commented 7 years ago

Sorry I don't speak french!

jcaillon commented 7 years ago

Jokes aside, please provide more information on your request

hgrandperrin commented 7 years ago

Moi non plus !

hgrandperrin commented 7 years ago

An exemple : &Scoped-define OPEN-QUERY-bw_menus_autorises OPEN QUERY {&SELF-NAME} FOR EACH t_BOi_MENU WHERE t_BOi_MENU.vishab = TRUE NO-LOCK, ~ EACH t_BOI_HABMEN OF t_BOi_MENU WHERE t_BOI_HABMEN.PROFIL = l_profil NO-LOCK INDEXED-REPOSITION.

jcaillon commented 6 years ago

The user should modify this : 

&ANALYZE-SUSPEND _QUERY-BLOCK BROWSE BW_aagrac
/* Query rebuild information for BROWSE BW_aagrac
     _START_FREEFORM
OPEN QUERY {&SELF-NAME} FOR EACH AAGRAC
    WHERE AAGRAC.ANNIDEAFC = AGREMT.ANNIDEAFC
    AND AAGRAC.NUMINTDOSAFC = AGREMT.NUMINTDOSAFC
    AND AAGRAC.NUMINTAGR = AGREMT.NUMINTAGR
    NO-LOCK,
    FIRST ZTYACC WHERE AAGRAC.TYPEACCUEIL = ZTYACC.TYPEACCUEIL NO-LOCK.
     _END_FREEFORM
     _Options          = "NO-LOCK"
     _TblOptList       = ", FIRST, FIRST, FIRST, FIRST"
     _Query            is NOT OPENED
*/  /* BROWSE BW_aagrac */
&ANALYZE-RESUME

Stuff between _START_FREEFORM and _END_FREEFORM shoud then be copied to : &Scoped-define OPEN-QUERY-BW_aagrac

See below...

/* Definitions for BROWSE BW_aagrac                                     */
&Scoped-define FIELDS-IN-QUERY-BW_aagrac ZTYACC.LIBTYPEACCUEIL AAGRAC.NBPLACCAFACC   
&Scoped-define ENABLED-FIELDS-IN-QUERY-BW_aagrac   
&Scoped-define SELF-NAME BW_aagrac
&Scoped-define QUERY-STRING-BW_aagrac FOR EACH AAGRAC     WHERE AAGRAC.ANNIDEAFC = AGREMT.ANNIDEAFC     AND AAGRAC.NUMINTDOSAFC = AGREMT.NUMINTDOSAFC     AND AAGRAC.NUMINTAGR = AGREMT.NUMINTAGR     NO-LOCK, ~
           FIRST ZTYACC WHERE AAGRAC.TYPEACCUEIL = ZTYACC.TYPEACCUEIL NO-LOCK
&Scoped-define OPEN-QUERY-BW_aagrac OPEN QUERY {&SELF-NAME} FOR EACH AAGRAC     WHERE AAGRAC.ANNIDEAFC = AGREMT.ANNIDEAFC     AND AAGRAC.NUMINTDOSAFC = AGREMT.NUMINTDOSAFC     AND AAGRAC.NUMINTAGR = AGREMT.NUMINTAGR     NO-LOCK, ~
           FIRST ZTYACC WHERE AAGRAC.TYPEACCUEIL = ZTYACC.TYPEACCUEIL NO-LOCK.
&Scoped-define TABLES-IN-QUERY-BW_aagrac AAGRAC ZTYACC
&Scoped-define FIRST-TABLE-IN-QUERY-BW_aagrac AAGRAC
&Scoped-define SECOND-TABLE-IN-QUERY-BW_aagrac ZTYACC