count the no of rows in tabular format [message #85083] |
Mon, 31 May 2004 06:08 |
pattabi
Messages: 4 Registered: May 2004
|
Junior Member |
|
|
hi
i m working with forms 4.5,
when i using tabular format, how to count the no of rows .
how to validate the each filed before it update in the database.
tanx
pattabi
|
|
|
Re: count the no of rows in tabular format [message #85093 is a reply to message #85083] |
Tue, 01 June 2004 03:04 |
Himanshu
Messages: 457 Registered: December 2001
|
Senior Member |
|
|
Hi,
In order to count No of Rows you can create a control item.
Set its Calculation Properties as follows:
Calculation Mode = SUMMARY
Sumaary Function = COUNT
Summarized Block = Block's name for which you require count.
Summarized Item = Name of Any item of the block.
As far as validations are concerned there are several ways
e.g.
You can add Format masks to feilds.
Can add When-validate-item or Whan-validate-record or When-vaildate-form triggers.
If you require to loop in the Tabular block then make use of some Procedure to write your validations and call it in Key-commit trigger.
HTH
Regards
Himanshu
|
|
|