Execute Dynamic Query within BPM Data Directive

Epicor ERP 10
4

Please excuse any odd formatting from the copy-paste:

Ice.Contracts.DynamicQuerySvcContract tQuery = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.DynamicQuerySvcContract>(Db);

if (tQuery != null)
{		
Ice.Tablesets.DynamicQueryTableset dsQuery = tQuery.GetByID("BAQ");		
if (dsQuery != null)										
{													
Ice.Tablesets.QueryExecutionTableset dsBAQ = tQuery.GetQueryExecutionParameters(dsQuery);								dsBAQ.ExecutionParameter[0].ParameterID = "Key1";	
dsBAQ.ExecutionParameter[0].IsEmpty = false;
dsBAQ.ExecutionParameter[0].ParameterValue =inputstring;					
DataSet results = tQuery.Execute(dsQuery, dsBAQ); 
if (results != null && results.Tables.Count > 0 && results.Tables[0].Rows.Count > 0)
{
DataRow row = results.Tables[0].Rows[0];					
row["RowMod"] = "U";
…										
try									
{
				tQuery.Update(dsQuery, results);
			}												
catch (Exception e)										
{													
string emsg2 = "usefule info " + e.Message;							Ice.Diagnostics.Log.WriteEntry(emsg2);							
}											
}												
dsBAQ = null;										
}
dsQuery = null;											
tQuery.Dispose();
}
6 Likes