| Execute Data using When validate Record trigger [message #638872] |
Wed, 24 June 2015 00:49  |
 |
tofajjalhnipu66@gmail.com
Messages: 18
Registered: May 2015
Location: Chittagong,Bangladesh
|
Junior Member |
|
|
Hi ,
I have one form . and in this form i have 2 data block ..1st is form style and 2nd is tabular style . Tabular style is just for showing Record. and form style block is for inserting,updating and other work ...
When i run This form ,In tabular block data is execute .my requirement, Click the mouse on any of the records in the block of tabular if I do , then click on the record will be executed at form block . how to do this ?
Could u help me please ...
Regards
Nipu
|
|
|
|
| Re: Execute Data using When validate Record trigger [message #638879 is a reply to message #638872] |
Wed, 24 June 2015 06:00  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
First of all, I don't like the idea of having the same data twice on the screen. What benefit does it provide?
As of your question: you didn't mention Forms version you use. If it is 9i or above, mouse gestures won't work so you'll have to forget about "click the mouse on any record" - you'll have to create a button (for every tabular block record) and click the button instead.
Any option you use, you'll have to prepare query execution for the first block. It is usually done by setting its ONETIME_WHERE (or DEFAULT_WHERE; you'll make that decision) property. Previously mentioned button's WHEN-BUTTON-PRESSED trigger would look like
set_block_property('first_block', 'onetime_where', 'id = ' || :second_block.id);
go_block('first_block');
execute_query;
Note that - if it is a classic master-detail form - contents of the tabular block might change once the query is executed in the first block.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
