It's possible to assign the name of a table from a variable?

I have a table (Tables) that gathers the name of several tables.

I have created a variable that takes the name of each table:

let myT := this.text(name.Table),

but when I want to use the variable myT to substitute the table name using select :

sum ((select myT).Incomes) - sum ((select myT).Debits,

not working (table myT not found).

I hope your answer. Thanks.

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Clonev,

    you can use the eval() function for this:

    let myT := this.text(name.Table);

    let script:= "sum ((select"+myT+").Incomes) - sum ((select"+ myT+").Debits";



    • clonev
    • clonev
    • 8 mths ago
    • Reported - view

    Thanks Steven. I will try it, this afternoon.

Like Follow
  • 8 mths agoLast active
  • 2Replies
  • 144Views