Hi,
It's possible to pass the table name as a parameter?
Something like this:
SELECT f1, f2, f3 FROM
@table_name
ORDER BY f1 DESC
Thanks,
Catalin
Table name as parameter
Re: Table name as parameter
Hello,
Please check the following sample:
https://www.stimulsoft.com/en/samples/p ... -sql-query
Thank you.
Please check the following sample:
https://www.stimulsoft.com/en/samples/p ... -sql-query
Thank you.
Re: Table name as parameter
Hi,
I checked the sample but I didn't saw the answer of my question. I need to pass the table name as a parameter.
or
I try it in both ways but is not working.
Also the sample is wrong:
I checked the sample but I didn't saw the answer of my question. I need to pass the table name as a parameter.
Code: Select all
SELECT f1, f2, f3 FROM @table_name ORDER BY f1 DESC
Code: Select all
SELECT f1, f2, f3 FROM {table_name} ORDER BY f1 DESC
Also the sample is wrong:
Code: Select all
SELECT id, name
WHERE id = {Variable1}
ORDER BY name {Variable2}
Re: Table name as parameter
Hello,
You can use the following query:
select * from {VariableTableName}
and set value for the variable before run report.
Also, please clarify which version are you use?
Thank you.
You can use the following query:
select * from {VariableTableName}
and set value for the variable before run report.
Also, please clarify which version are you use?
Thank you.