eSQL returns text that can be evaluated. As long as the syntax is correct it should work.
Something like this should work:
ExecuteSQL ("SELECT ':' + Values FROM SQL " ;"";",")
1 of 1 people found this helpful
I can't test it, but calling MBS functions would be like
Evaluate ( "MBS(\"SQL.SetParamValues\"; $Command; " & $Var & ")" )
MBS("SQL.NewCommand"; $Connection; "INSERT INTO table (" & $Values & ") VALUES ( :1,:2,:3 )" )
then for second calculation you need one more SQL or function to make list of numbers, if it varies.
Your variables look having inverted name, SetParamValues need values to apply (Insert in this case), NewCommand need field names and numbers of parameter (:1 get first value from SetParamValues, and so on).
That was the point. I allways tried to put the values into the MBS function via "evaluate" instead to put the whole function into a text version and then "evaluate" everything together.