Home » Developer & Programmer » Forms » WRITE THE VALUES ON 2 LINES DIFFERENTS (FORM 11G ORACLE )
WRITE THE VALUES ON 2 LINES DIFFERENTS [message #557765] Fri, 15 June 2012 10:22 Go to next message
vantran
Messages: 11
Registered: April 2012
Location: CANADA, MONTREAL
Junior Member
HELLO,

I WOULD LIKE TO WRITE 2 VALUES: BLO_ASSGN.no_utils_sqlds, :BLO_ASSGN.TXT_NM_UTILS

IN BLOCK(:BLO_ASSGN) ON FIRST LINE


:BLO_ASSGN.no_utils_sqlds := :BLO_ROLE.concil_role
:BLO_ASSGN.TXT_NM_UTILS:=:BLO_ROLE.DSP_CONCIL_ROLE

THEN

:BLO_ASSGN.NO_UTILS_SQLDS:=:BLO_ROLE.MEMBRE2_ROLE
:BLO_ASSGN.TXT_NM_UTILS:= :BLO_ROLE.DSP_MEMBRE2_ROLE

ON SECOND LINE IN THE SAME BLOCK (:BLO_ASSGN)

HOW COULD I DO THAT ? PLEASE HELP ME !

THANKS,

Re: WRITE THE VALUES ON 2 LINES DIFFERENTS [message #557769 is a reply to message #557765] Fri, 15 June 2012 12:41 Go to previous messageGo to next message
joy_division
Messages: 4520
Registered: February 2005
Location: East Coast USA
Senior Member
You DON'T report messages to get them answered faster. I have deleted your reporting of the message.
Re: WRITE THE VALUES ON 2 LINES DIFFERENTS [message #557792 is a reply to message #557769] Fri, 15 June 2012 15:24 Go to previous messageGo to next message
Littlefoot
Messages: 19650
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
The answer depends on block's layout. It seems that it is a tabular form. If that's so, put values into the first record, then do NEXT_RECORD and put values into the second record.

If it was a form layout, then these items wouldn't share the same name, but coding would be somewhat simpler (you'd put every value into its own item, no additional coding).
Re: WRITE THE VALUES ON 2 LINES DIFFERENTS [message #557795 is a reply to message #557792] Fri, 15 June 2012 15:30 Go to previous message
vantran
Messages: 11
Registered: April 2012
Location: CANADA, MONTREAL
Junior Member
Thank you.

Nice a week end.
Previous Topic: USE of JOIN In Forms 6i
Next Topic: How to compare two text boxes with IN operator form
Goto Forum:
  


Current Time: Wed Oct 01 14:26:32 CDT 2014

Total time taken to generate the page: 0.13182 seconds