| returning values [message #87019] |
Mon, 29 November 2004 21:32  |
sandeep
Messages: 110
Registered: October 2000
|
Senior Member |
|
|
hi,
I have a text item in my form which will accept 1 value or more than 1 value..e.g (123) or (123,124,135). I will be passing this as a parameter to the backend procedure. The procedure should return me the records corresponding to the values. each time the number of values differ,,,can be 1 or more than 1.
Can someone help me in finding the solution
thanks in advance.
|
|
|
|
| Re: returning values [message #87032 is a reply to message #87019] |
Tue, 30 November 2004 08:36  |
ala
Messages: 17
Registered: May 2004
|
Junior Member |
|
|
u can put ur procedure in a loop
for ex....
the number in ur item is 5
in when-validate-item trigger on ur item u can write
declare
begin
x := :ur_item
for i in 1..:ur_item loop
call ur procedure here
end loop;
end;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
