Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008
    Location
    pakistan
    Posts
    109

    Unanswered: How to declare and call in forms 6i

    I want that when i run the form and i declare a global variable when execute the query and it shows forms fields it declare auto after executing the query the customer id and put it in the next block i use the folllowing query is that rite coz i don't have table some one ask this to me

    Code:
    begin
    :GLOBAL.cs_id := :blck.fild;
    :1stblock.fildname := :global.cs_id;
    or
    :2ndblock.field := :cs_id;
    end;
    
    :GLOBAL.<Variable name> := null; 
    in when new form tigger

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    In WHEN-NEW-FORM-INSTANCE trigger? Well, most probably all items are empty at that moment so - setting a global variable to any item's value is meaningless.

    In order to set second block's item to first block item's value, you don't need a global variable - in POST-QUERY trigger simply set
    Code:
    :second_block.cs_id := :first_block.cs_id

Posting Permissions

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