Thursday, December 30, 2010

Creating Sequence Number Field

1. Creating sequence number

1)In the child BC create a new sequence field that maps to an unused column & has a Data Type of DTYPE_NUMBER.

2)Define a BC user property for the Child BC as follows:

Name: Sequence Field
Value:

3)Create a new BC having name=.(Sequence) & class=CSSSequence.
4)The Sequence BC will be based on the same table as the child BC.
5)Create a new Sequence field in the Sequence BC(created above) that points to the same column as that of the Sequence field in child BC.
6)Create a second field in the Sequence BC that is FK field to the Parent BC.
7)Create a link between the Parent & Sequence BC.
8)Expose the new link in the BO that holds the Parent & Child BC.
9)Expose the Sequence field of child BC in the child applet.


Copy paste from another site .But it is helpful

thanks and regards
Joseph


1 comment: