Page 1 of 4 1 2 3 ... LastLast
Results 1 to 10 of 40

Thread: Variable Creation tool

  1. #1
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    959

    Variable Creation tool

    Hi folks,

    I'm playing around with a tool and wanted to see what other devs thought ...

    When coding event rules you sometimes need to create a ton of variables, for example, to reference table columns. It's not so much fun to add each DD item for the variables.

    My prototype allows you to enter in a TBLE or DSTR and get the list of DD items within. Then select which ones you want and it will create the variables.

    See attached example. CVExample.pdf

    This is the simple prototype, I was thinking to add options to control how the variable is named and scope etc. Let me know what you think.

    Craig
    Last edited by craig_welton; 08-05-2017 at 12:24 PM. Reason: I can't spell
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  2. #2
    Hi Craig,

    I think this will be a valuable tool.

    Then select which ones you want and it will create the variables.
    It will be nice to have the ability to search for fields by alias and dd item name.
    Regards,

    Hari Sharma
    Aellius
    EnterpriseOne: Integration (.Net, Web Services) | Output Management | Monitoring

  3. #3
    Member nkuebelbeck's Avatar
    Join Date
    Mar 2012
    Location
    Minnesota
    Posts
    532
    there would need to be a way to control the variable names.

    I like to use

    sz[TABLE]_[DD] ex: szF4201_DCTO

    or

    sz[BSFN]_[DD] ex: mnGetAuditInfo_TDAY <---this one is difficult to adhere to because of variable length constraints.
    Last edited by nkuebelbeck; 08-07-2017 at 01:15 PM.
    Analyst/Developer
    E1: 9.2 | TR: 9.2.1.4 | JAS: WebLogic | ES: OS400
    DB: DB2 | WebDev Client: Win7Pro (64 bit), VS 2010

  4. #4
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    959
    Thanks, yes I have that planned. Check boxes to prefix and suffix. If it truncates to much I was thinking of allowing the user to edit the formatted variable name.

    Craig
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  5. #5
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,322
    That's fantastic Craig

    Does it make the whole name itself? And what would happen when there are duplicate DD items in a DSTR?
    EV01 for example, does it make the cEverestEventPoint01_EV01 or do we type the extras in?

    If it's automatic, only pitfal I could think of is duplicate variables
    EV01 is very common. Is it smart enough to create it as different names? E1 warns you and errors when you try to do it manually
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR 9.1.5.3 Unix

  6. #6
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    959
    Hi Hari,

    It will be nice to have the ability to search for fields by alias and dd item name.
    Can you explain that a bit more? Are you thinking a way to search for items from the DD? rather than by object they are used in?

    thanks
    Craig
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  7. #7
    Hi Craig,

    After selecting the table/dstr, produce a list of fields. Then provide the ability to search within those fields. If I type the "numb", for example, it should filter the list to show AddressNumber, UserReservedNumber for example. The search should be case insensitive.
    Regards,

    Hari Sharma
    Aellius
    EnterpriseOne: Integration (.Net, Web Services) | Output Management | Monitoring

  8. #8
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    959
    OK, first stab at this is attached. It's just a simple Win32 executable so should not need any installer. Here are the notes...

    Upon loading the tool will attempt to connect to JDE. If you already have a "session" running (activconsole, fda, rda, etc.) it will connect using that.
    An icon will appear in the system tray that looks like the Variables button in the ER editor.
    Right click the system tray icon to bring up the popup menu where you can quit the program.

    When using an ER editor and pressing the JDE variables button, the tool window appears next to the variables dialog. In the top text box enter an object (DSTR or TBLE) and tab out. The list box below will fill with the DD items. Choose the scope and options (prefix and suffix). Select the DD items to create and press the Add DD Items button.

    The program CreateVar.exe will remain running and hold a session. Close it down when done.

    If you are interested, please give it a try. It's very rough, but with input from other devs, it may have a chance.

    thanks
    Craig
    Attached Files Attached Files
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  9. #9
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,322
    Hi Craig

    Thanks for this. I've installed this and it works great
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR 9.1.5.3 Unix

  10. #10
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    959
    Thanks for giving it a shot. Let me know if you have any ideas or issues.

    Craig
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.