OraFAQ Forum: Application Express, ORDS & MOD_PLSQL

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Form with associated label (APEX'4)

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

Form with associated label [message #648279]

Fri, 19 February 2016 11:05

pcouas
Messages: 112
Registered: February 2016

Senior Member

Hi,

I have an form with some fields and i want only showing associated label when i typing text ?

I have tried without succes to define an text field on display only with SQL select teu_group_name from lo_teu_group where teu_group_uid=&P154_TEU_GROUP_UID
But my other items is not understood by sql !
i have tried too with P154_TEU_GROUP_UID and #P154_TEU_GROUP_UID#

My Database field is TEU_GROUP_UID, without succes
select teu_group_name from lo_teu_group where teu_group_uid=TEU_GROUP_UID
BUT
select teu_group_name from lo_teu_group where teu_group_uid=1 Is ok

Regards
Phil

[Updated on: Fri, 19 February 2016 11:56]

Report message to a moderator

Re: Form with associated label [message #648289 is a reply to message #648279]

Fri, 19 February 2016 12:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You should reference page items with a colon, i.e.

select teu_group_name 
from lo_teu_group 
where teu_group_uid = :P154_TEU_GROUP_UID;

Report message to a moderator

Re: Form with associated label [message #648353 is a reply to message #648289]

Sun, 21 February 2016 23:32

pcouas
Messages: 112
Registered: February 2016

Senior Member

Thanks

Report message to a moderator

Previous Topic:	communication between two form without reset all variables
Next Topic:	Region Template position

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 09:42:06 CST 2025