Query Gen Database to get Screens and the Tables/Fields Used by those Sceens

Sort:
You are not authorized to post a reply.
Author
Messages
Layne
Basic Member
Posts: 24
Basic Member
    Does anyone know what combination of tables I would query to get a list of the screens and the tables and fields that are used by these screens. 
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
      I don't have this specific GEN information for you, but ...  you could use a Lawson tool to do this.  Or you could use a script (If you're Unix) that I wrote to create web pages from the information.
      Attachments
      SP
      Veteran Member
      Posts: 122
      Veteran Member
        I haven't looked at what Greg uploaded, but I would start by taking a look at the following gen tables:

        filedef
        filefld
        fileind
        fileindfld
        system
        docfile
        element

        HTH,
        -Shane
        Kwane McNeal
        Veteran Member
        Posts: 479
        Veteran Member
          I just checked out Greg's script. It's good. I have a more spartan script to do the same thing, but his does all the error checking I didn't put into mine.

          Now if you need this info for GEN, I'll dig out my script for that and post it, since dbdoc/dburf do not work for GEN.

          Also, if you need function codes (FCs) for the forms, that isn't in GEN at all. You'll have to either parse the form xml files created by xscrgen, or parse the output from the Xpress servlet.

          Kwane
          You are not authorized to post a reply.