Can execute query be controlled for blocks
836677Feb 3 2011 — edited Feb 3 2011Hi,
I've 3 blocks in my form. The first and the second block are in query mode, therefore I cannot update, insert, delete values here.
The third block, I have put on another canvas. So the moment there's data in the second block the third block gets displayed. The user is allowed to enter values only in the third block.
Since the first and second block are in query mode I've put the execute_query in the W-N-F-I.
Due to the execute_query in W-N-F-I the 3rd block also starts showing me values, which it shouldn't. It should be a clear block with no values displayed.
Mainly I want the execute_query to work only for first and second block and not for the third block.
I tried putting the execute query in pre-block trigger. But it showing me error as Illegal operation for join condition and the forms gets hanged.
Kindly if you could help on the same
Thanks for your help in adv.