Home » Developer & Programmer » Forms » *newbie* please help!
*newbie* please help! [message #668826] Thu, 15 March 2018 14:37 Go to next message
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 messageGo to next message
cookiemonster
Messages: 13777
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.
Re: *newbie* please help! [message #668834 is a reply to message #668826] Fri, 16 March 2018 08:05 Go to previous message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
Also, a single select can get both values as you are using the same condition.
Previous Topic: set_menu_item_property error in 12c - FRM41068
Next Topic: trigger to retieve data into non database item
Goto Forum:
  


Current Time: Sun Jan 19 15:44:10 CST 2020