Question
2
Replies
64
Views
Social Security Administration
Posted: March 17, 2020
Last activity: March 18, 2020
Connect SQL
Hi All, We have a requirement to pass schema name as parameter in the connect-sql rule. We tried passing it using a data page but it didn't work. Did anyone know the solution for this ?
***Edited by Moderator: Pallavi to update platform capability tags***
Hi
You can not pass parameters to the Connect SQL rule.
Try using the data page itself :
Ex: Select ID,Name from {Class:ClassName} where ID='{ASIS:Testpage.ID}';
Insert into {Class:ClassName}(ID,Name)values('{ASIS:Testpage.ID}','{ASIS:Testpage.Name}');