Home » Developer & Programmer » Forms » item property copy value from item (forms 11g)
item property copy value from item [message #594325] Tue, 27 August 2013 08:11 Go to next message
Messages: 34
Registered: April 2009
Location: Adelaide
I have control block. In which user enters two values. Next is data block in which two items have property 'copy value from item' set to 'control block.item1' and 'control block.item2' resp. If thees items are made database items then in execute query will they be sent as parameters in addition to default where clause? if I check last query then query does not hv these parameters but the records returned are already filtered by control block items.
Re: item property copy value from item [message #594346 is a reply to message #594325] Tue, 27 August 2013 13:23 Go to previous message
Messages: 21042
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, no parameters are used here.

I'd say that "copy value from item" property did the same job as if in a PRE-QUERY trigger you set
:data_block.item1 := :control_block.item1;
:data_block.item2 := :control_block.item2;
so that executing a query knows which records to return (or, something like entering search criteria into the data block manually).
Previous Topic: Form record locking
Next Topic: advantages of forms
Goto Forum:

Current Time: Mon Mar 27 15:41:36 CDT 2017

Total time taken to generate the page: 0.10134 seconds