| help [message #84956] |
Fri, 14 May 2004 18:25  |
Thirumal
Messages: 6
Registered: March 2004
|
Junior Member |
|
|
Can you help me about
1.I have a table called EMP, in which I have salary column. In Developer 2000 (Forms), I have created a multi record (base table) block. Supposing that number of records displayed are 5. There are different columns of that block like empno, ename, sal. In all the 5 sal columns, I have entered values. Now I want to compute salary of all those records. How can I do that ?
2. What’s the default parameter in key commit trigger?
|
|
|
|
| Re: help [message #85026 is a reply to message #84956] |
Mon, 24 May 2004 03:39  |
Anupam
Messages: 62
Registered: July 2001
|
Member |
|
|
first answer
u can create a parameter
and in when-new-record-instance
write this code
select sum(sal) into :parameter.para_name from emp;
:displaY_item:=:parameter.para_name;
leave out all the properties of display item and just
swith off the database property to no
hope it ll help u
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
