Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Form with associated label (APEX'4)
Form with associated label [message #648279] Fri, 19 February 2016 11:05 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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;
Re: Form with associated label [message #648353 is a reply to message #648289] Sun, 21 February 2016 23:32 Go to previous message
pcouas
Messages: 112
Registered: February 2016
Senior Member
Thanks
Previous Topic: communication between two form without reset all variables
Next Topic: Region Template position
Goto Forum:
  


Current Time: Fri Mar 29 08:59:55 CDT 2024