2 Replies Latest reply: Aug 22, 2011 11:28 AM by Laurent Jonette RSS

    Set 1 or 0 to variable if selected field is on a specific table

      Hello,

       

      is it possible to set a variable with the result 1 or 0 if selected(s) field(s) is(are) on a specific table?

       

      I have 3 tables (Table_NAV; Funds;Memory) and a reference date set by a variable (vDateRef)

      Table_NAV
      Funds
      Memory
      Date
      Funds_Nbr
      Contract_Nbr
      Funds_Nbr
      Type
      Funds_Nbr
      NAV
      Name
      Date


      ISIN
      Units


      StartDate

       

      The 2 first have date all days. Last one only endmonth.

       

      Wath I want is use the vDateRef if selected Fields are on table "Table_NAV" or "Funds" otherwise a endmonth date if selected fields are on table "Memory".

       

      thanks for your help.

       

      Laurent