Welcome Guest Login SignUp

Home

Technical

Functional

CNC

AS400

DB2

    Citrix

JDE News

Live Radio

Feedback

JDE Forum Comments/Reviews/Queries
2652 day(s) ago   #97
Name: TechZone
Category: Technical
Location: Singapore
Date: 2013-02-19 19:37:00
Replies(1)

Status:
  #97

Automatic Line Numbering in Grid

Using 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.

VA frm_LineNumber_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
End If

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

Cheers
TechZone
2650 day(s) ago   #98
Name: Yash
Category: Technical
Location: India
Date: 2013-02-21 18:04:25
Replies(1)

Status:
  #98

Automatic Line Numbering in Grid

Thanks 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?

Thanks
JDE E1 Tech.
Post Comments/Queries
Email:*
Name:*
Details:*
 
   
* Required Entry Field(s).  * Your comments may subject to varification.  * Your email ID will not appear in the forum.
 
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