suhaafaneh
asked on
Post-query trigger doesn’t fire
On developer 2000 forms 6 , we have a form with 7 blocks, one of them is a control block ( not database), we use it to enter the specified record primary key and in the key-next-item it will execute query for the remind 6 database blocks and each block have a post-query trigger . the problem is that the post-query trigger does not fire for all blocks. even they have records and they retreive them.
POST_QUERY trigger MUST reside in the block in which you fetch records. This is the case you described. Try also to put the focus on the block:
GO_BLOCK('the_block_name') ;
execute_query;
May be you leave the focus on your control block, but it has no postquery trigger.
GO_BLOCK('the_block_name')
execute_query;
May be you leave the focus on your control block, but it has no postquery trigger.
ASKER
we use the go_block and the do_key
and i used the debugger but it didn't fire the post-query for all database blocks just for 2 of them
and i used the debugger but it didn't fire the post-query for all database blocks just for 2 of them
You either do not execute query against the block and simply insert records there or do not go to the block. Check carefully the logic ...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I've seen this before...and the cause was as Mark noted
<snip>
Another possibility is that the main query in a child block did not find any records. In that case,
the post-query will not be executed for that child block.
</snip>
Regards,
JT
<snip>
Another possibility is that the main query in a child block did not find any records. In that case,
the post-query will not be executed for that child block.
</snip>
Regards,
JT
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept markgeer's comment as answer
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
jpkemp
EE Cleanup Volunteer
I will leave a recommendation in the Cleanup topic area that this question is:
Accept markgeer's comment as answer
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
jpkemp
EE Cleanup Volunteer
Do_Key('Execute_Query'); instead of Execute_Query;