OraFAQ Forum: Forms » WRITE THE VALUES ON 2 LINES DIFFERENTS

Home » Developer & Programmer » Forms » WRITE THE VALUES ON 2 LINES DIFFERENTS (FORM 11G ORACLE )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

WRITE THE VALUES ON 2 LINES DIFFERENTS [message #557765]

Fri, 15 June 2012 10:22

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,

Report message to a moderator

Re: WRITE THE VALUES ON 2 LINES DIFFERENTS [message #557769 is a reply to message #557765]

Fri, 15 June 2012 12:41

joy_division
Messages: 4963
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.

Report message to a moderator

Re: WRITE THE VALUES ON 2 LINES DIFFERENTS [message #557792 is a reply to message #557769]

Fri, 15 June 2012 15:24

Littlefoot
Messages: 21813
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).

Report message to a moderator

Re: WRITE THE VALUES ON 2 LINES DIFFERENTS [message #557795 is a reply to message #557792]

Fri, 15 June 2012 15:30

vantran
Messages: 11
Registered: April 2012
Location: CANADA, MONTREAL

Junior Member

Thank you.

Nice a week end.

Report message to a moderator

Previous Topic:	USE of JOIN In Forms 6i
Next Topic:	How to compare two text boxes with IN operator form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 22:25:02 CDT 2024