Global Param in Data Source
Posted: Fri Aug 22, 2014 3:03 pm
Is it possible to use Global Param in Data Source (SQL-Connector) like
?
Code: Select all
SELECT * FROM Data WHERE Id=[$Global Param]
Code: Select all
SELECT * FROM Data WHERE Id=[$Global Param]
Code: Select all
((SqlDataConnector)DataSources.Get("<Data Connector Name>").Connector).Query = "<queryString>";
//My function:
public static void SetupSqlDataConnector(string dataCacheName, string queryString) {
((SqlDataConnector)DataSources.Get(dataCacheName).Connector).Query = queryString;
}
//I call it like this:
// You need to declare a test variable in the module that will be bound at runtime. I call it KeyVariable here.
<Library>.<Data Class>.SetupSqlDataConnector("MySqlConnector", string.Format("exec GetMySqlConnectorInfo_for_Key @Key=N'{0}'", KeyVariable));