Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008
    Posts
    9

    Unanswered: EXEQUTE_QUERY Isuue

    Hi,

    1. Can't we use 'EXEQUTE_QUERY' in POST-CHANGE or WHEN-VALIDATE-ITEM triggers

    Eg. Following block

    BEGIN
    SET_BLOCK_PROPERTY('ft_members',DEFAULT_WHERE,'mem _id = ' || :ft_members.mem_id);
    EXECUTE_QUERY;
    END;



    2. Will the POST-QUERY trigger runs after above block.


    [Version -Forms Builder (9.0.4.2.0) on XP]
    thax

    Shabar
    Last edited by sudheerah; 04-30-09 at 02:58.

  2. #2
    Join Date
    Jun 2009
    Posts
    10
    There are restrictions on the types of code you can run inside certain triggers.

    Try just doing the SET_BLOCK_PROPERTY in the trigger first, does that work?
    Can you run the EXECUTE_QUERY on a KEY-NEXT-ITEM or something like that?

    Thanks
    Frank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •