| urgent...plz help. [message #79274] |
Tue, 21 May 2002 00:55  |
Thomas
Messages: 67
Registered: September 1999
|
Member |
|
|
in which trigger and what statements should be given to move to a detail block first item from the master block last item.
also find the number of days between two dates in two fileds and get the value calulted to an other filed. in an other field the result of multipliction of the days and rate should be made possible to appear after exiting the previous field.
|
|
|
|
| Re: urgent...plz help. [message #79276 is a reply to message #79274] |
Tue, 21 May 2002 01:53  |
Remash
Messages: 52
Registered: November 2000
|
Member |
|
|
A simple way is to add a KEY-NEXT-ITEM under the last field of the master block. In the trigger write GO_BLOCK(your detail block), then GO_ITEM(first item in the detail block). Assume DATE1 & DATE2 are two date fields and DAYS, RATE & AMOUNT are numeric fields.
No. of days is :DAYS := (:DATE2 - :DATE1) + 1
:AMOUNT := :DAYS * :RATE;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
