|
|
|
|
Re: button in reports [message #624266 is a reply to message #624247] |
Fri, 19 September 2014 14:27   |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
shahzad-ul-hasan wrote on Fri, 19 September 2014 15:14
Tell me the procedure
I don't know it, I don't have enough information (tables' description and stuff).
I think that it is "stupid" to run a report, have a list of tens or hundreds of students, and then clicking that button of yours tens or hundreds of times in order to insert values into a certain table (which would be used for ... what? Sending an e-mail to parents?). A procedure would
insert into msgout (id,msgto,msg)
select
stuid,
'<is it a hardcoded telephone number? Wrong! That information should be stored somewhere>',
'Respected parents your child got' || obt ||'/' || tot || 'in ' ||ty
from <a table you use in that report>
where <condition here, if necessary>;
No clicking, no nothing. Let Oracle do the dirty job.
|
|
|
|