How to insert Variables from a Table into a calculation?

Discussion created by firebase on Jul 26, 2017
Latest reply on Jul 29, 2017 by firebase

I am using the great MBS Plug-in.


One function for external SQL DBs is


    MBS("SQL.SetParamValues"; $Command; $Var1 ; Var2 ; $Var3 )


to Insert Parameter into SQL requests with MBS Plug-in like


    MBS("SQL.NewCommand"; $Connection; "INSERT INTO table (:1,:2,:3) VALUES ")


Now I have a several very long tables with about 250+ fields in an external DB.


I would like to map the field translations of insert and selects (to/from) to the external DBS with a FM Table.


So instead of real live Variables i would likt to insert Values from a Table with FM SQl Select


    $Var = ExecuteSQL ("SELECT Values FROM SQL " ;"";"")

    $Values = ExecuteSQL ("SELECT Values FROM SQL " ;"";"")

    MBS("SQL.SetParamValues"; $Command; $Var)

    MBS("SQL.NewCommand"; $Connection; "INSERT INTO table ("&$Values&") VALUES ")