How to run a dynamically generated query(text format) in advance sql block?

How to run a dynamically generated query(text format) in advance sql block?

  
Hi,
Am new to outsystems,I want to run a dynamically generated sql(in text format) in advance sql block but am not able to execute the same if i pass the text as parameter(@parameter) and then execute using EXEC @parameter.

did some one face similar issues?
Solution
Did you set the expand inline parameter property to true?

Note: Do not forget to use EncodeSql function to prevent SQL injection in the database.


Solution
Hi Andre,
Thank You for quick Turn around:).It helped:)
Thanks,
Nithin S C