| formula column error [message #89226] |
Wed, 10 December 2003 04:51  |
Jasmine
Messages: 23
Registered: December 2000
|
Junior Member |
|
|
when i am creating an formula column to calculate
for eg
fun calc
begin
return (sales * rate);
end;
its returning both sales and rate r not defined its the column
name of the table that selected how to write for formula
i used bind variable
:sales and :rate
but it showing errors
how to overcome can any body give one eg
thanks in advance
jasmine
|
|
|
|
| Re: formula column error [message #89227 is a reply to message #89226] |
Wed, 10 December 2003 08:06  |
ram kumar
Messages: 113
Registered: August 2002
|
Senior Member |
|
|
function CF_1Formula return Number is
begin
return(:sal*:comm);
end;
those sal and comm colums must be there in select statement
THE FORMULA CODE SHOULD LOOK LIKE ABOVE
rAM
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
