Page 2 of 4 FirstFirst 1 2 3 4 LastLast
Results 11 to 20 of 40

Thread: Variable Creation tool

  1. #11
    This is a great tool. I am already like this tool. it will save lots of coding time.
    This is enough with current feature but I just want to mention my wish here.
    1. Dynamic Prefix
    Sometimes I use my own prefix such as Table name or just number(0,1,2,3...) or IN/OUT(BSFN Input/Output) to group for the same usage. So maybe it would be great if we can put prefix with our own prefix.
    2. Alias only
    Sometimes I just use Alias only(rpt_AN8) if I don't need to see the description. Normally I use it for simple Table IO.
    It works great. Thanks again

  2. #12
    Senior Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    1,005
    Thanks for the feedback. I'll look to add those features soon.

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

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  3. #13
    Senior Member DSauve's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA
    Posts
    1,248
    This tool is nifty. Thank you, Craig.
    One suggestion is to have an option to preview the variables about to be created so you can tweak the names, and then actually create them. Not a big deal, but it might be nice.

    Thanks again!
    Don Sauve
    Wagstaff, Inc.
    E1 9.2, Win2016, SQL Server 2016, TR 9.2.2.6, WebLogic 12.2.1, BI Publisher

  4. #14
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,359
    Agreed, I too will add F4211DocNumber_DOCO to variables, so a prefix in the name is useful.

    Also, for things like when EV01 is in a DSTR, the name for EV01 is always renamed to something like cActivateFunctionality_EV01
    Your add on will create EverestEventPoint01 instead right?

    It might be useful to inherit the DSTR element name?

    And does this cope ok with duplicated DDs in a DSTR? I couldn't find one to test
    Last edited by johndanter; 08-21-2017 at 10:25 AM.

  5. #15
    Member nkuebelbeck's Avatar
    Join Date
    Mar 2012
    Location
    Minnesota
    Posts
    543
    I would rather have a find/go button than tabbing out of the box and it eventually filling the pane with variables.

    A message indicating I've entered a DS or Table that doesn't exist would be handy. Maybe the description of the object I've selected too

    When i click/unclick the options for Data type prefix and DD item suffix, the left hand pane should make those changes.

    Kind of similar to a preview window - also being able to manually then modify would be nice as other have stated

    Great tool though. You da real MVP craig!
    Analyst/Developer
    E1: 9.2 | TR: 9.2.1.4 | JAS: WebLogic | ES: OS400
    DB: DB2 | WebDev Client: Win7Pro (64 bit), VS 2010

  6. #16
    Senior Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    1,005
    Thanks to everyone for the awesome feedback. I'll get to work on it soon.

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

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  7. #17
    New Member Lis's Avatar
    Join Date
    Sep 2005
    Posts
    1

    Thumbs Up Me too prefers similar naming. It becomes easy to track the variables.

    Quote Originally Posted by nkuebelbeck View Post
    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.

    Me too prefers similar naming. It becomes easy to track the variables.

  8. #18
    New Member
    Join Date
    Jun 2005
    Location
    India
    Posts
    29
    Hi Craig,

    Interesting and very useful Tool. Works really nice.
    I agree with nkuebelbeck, we need find/go button to display the variables.

    Thanks
    Imran

  9. #19
    Senior Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    1,005
    OK, updated version. First, the list box is replaced with a ListView with multiple columns. DD Item, Variable, and Name. Variable column will display what the ER variable will look like. When choosing a DSTR, the variable name will be derived from the DSTR member name. You can choose how to prefix and suffix the data item name.

    Prefix:

    None
    Data Type (sz, mn etc.)
    Custom (Enables a text box to enter your own prefix)


    Suffix:

    None
    DD Item (DOCO, AN8 etc.)
    Custom (Enables a text box to enter your own suffix)

    Enter the object name in the first text box. Push Get to validate the object and retrieve the DD items. If you change a Prefix/Suffix option, push Get to re-format the items.

    Right click an entry to manually edit the Variable.

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

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  10. #20
    Senior Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    1,005
    Just wanted to bump this up to make sure those who requested features got a chance to try it.

    thanks
    Craig
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace, NERDup and BusBuild+ 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.