*newbie* please help! [message #668826] |
Thu, 15 March 2018 14:37 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/40686a6a722ee089a57079b110aa896a?s=64&d=mm&r=g) |
mattsme
Messages: 3 Registered: March 2018
|
Junior Member |
|
|
so i have everything working almost,
this is my post query trigger
select mtitle into :registration.modtitle from module
where mcode = :registration.mcode;
select fee into :registration.fee from module
where mcode = :registration.mcode;
read_image_file(
'c:\student\'||:student.netid||'.jpg', 'jpg', 'registration.photo');
so when i select the first student all items are correct.
however for the next student i select i get the right photo but in all other fields it just displays all modules/fees
what am i doing wrong?
[Updated on: Thu, 15 March 2018 14:39] Report message to a moderator
|
|
|
Re: *newbie* please help! [message #668830 is a reply to message #668826] |
Fri, 16 March 2018 04:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
What's the relationship between the blocks?
What do you mean by "in all other fields it just displays all modules/fees"? A field can only show one value at a time.
|
|
|
|