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
NewToOracle10g
Messages: 31
Registered: April 2009
Location: Adelaide
Member
Hi
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
Littlefoot
Messages: 19648
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: Wed Oct 01 03:51:00 CDT 2014

Total time taken to generate the page: 0.22545 seconds