|2652 day(s) ago||#97|
Date: 2013-02-19 19:37:00
Automatic Line Numbering in GridUsing Event Rule Variables for Automatic Line Numbering
Event rules can be used to create automatic line numbering in form grids. Automatic line numbering means that each line in the grid will have a unique number and the lines will increment automatically as grid lines are added.
To create automatic line numbering event rules:
1. Create a variable to hold the value of the line number. Use the data dictionary item LNID.
2. Initialize the variable on the Post Dialog is Initialized event.
VA frm_LineNumber_LNID = 0
3. On the Grid Record is Fetched event, number the lines as each line is pulled from the database.
If BC LineNumber > VA frm_LineNumber_LNID
VA frm_LineNumber_LNID = BC LineNumber
4. On the Add Last Entry Row to Grid event, increment the line number and assign the new value to the next available line.
VA frm_LineNumber_LNID = VA frm_LineNumber_LNID + 1
GC LineNumber = VA frm_LineNumber_LNID
|2650 day(s) ago||#98|
Date: 2013-02-21 18:04:25
Automatic Line Numbering in GridThanks for the useful information
This will work when adding/entering lines in grid. How about if want to have my own line numbering where records already exist in grid?
JDE E1 Tech.
|Disclaimer:||Most of the posts in this blog cater solutions/suggestions/workaround to issues for specific tools release or JDE E1 version and are just information only. Please be carefule while applying it in your environment. JDEthread will not be responsible for any data loss or spec corruption (if any).|
Copyright © 2010 - 2020 JDEthread.in