Question
2
Replies
48
Views
Social Security Administration
Posted: 7 months ago
Last activity: 7 months ago
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***
Posted: 7 months ago
Posted: 7 months ago
Please find the below URL which might be helpful
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}');