how to apply variable to custom SQL

ReliabilityWolf — Mon, 17 Jun 2024 02:00:03 GMT

in custom SQL, this works.

.....left join c
on d.SCU = c.CU
where d.DE in (' 216532','216534')

in script, I define a variable: inString = ' 216532','216534'

then I like to run custom SQL:

.....left join c
on d.SCU = c.CU
where d.DE in (' inString')

but i doesn't work. how do I use my variable in custom SQL correctly?

Re: how to apply variable to custom SQL

jthi — Mon, 17 Jun 2024 04:52:26 GMT

You can use Eval Insert()

inString = "'216532','216534'";

sql_template = "\[
	.....left join  c
on d.SCU = c.CU
where d.DE in (^inString^)
]\";

sql_str = Eval Insert(sql_template);

topic how to apply variable to custom SQL in Discussions

how to apply variable to custom SQL

Re: how to apply variable to custom SQL