set variable into sql statement
i am using the mbs plug-in.
so far i was not able to set a variable into a sql statemnt:
MBS("SQL.NewCommand"; $Connection; "SELECT * FROM mytable")
MBS("SQL.NewCommand"; $Connection; "SELECT * FROM \"$mytable\"")
and any other variation i tired wont work for me.
how can it put a variable into the quotation marks?