Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You need to use Getfieldselections() function to fetch the value of the filelds and match the values according to that you check the fields and set value of variable.
Regards,
Anand
Hello Anand,
Thanks for your suggestion.
Unfortunatly, that doesn't help me for this. If there was the same function but with the table it could. What I was trying to do was affect a value to a variable if a field is selected in a defined table (regardless of the field) and an other value if its a selected field from an other table.
But your suggestion have help me for other expression.
Regards
Laurent