Hello,
After the installation of 14.3 Feature pack 3 the SQL queries on DeltaV Live have stopped working.
All these queries were working fine before upgrade to FP3
In the SQL Datasource management, I have allowed unsecured SQL queries.
I am using a SI dongle and can create perform other configuration functions like creating Class based GEMS.
So, i am sure it is not a licensing issue.
Following is the script:
// ********************* Button12.Action.Script(X: number, Y: number): void ********************* //
try
{
var id = Dsp.UnitID.Value
Dsp.UnitName.Value = await SQL.TruBioDS.QueryAsync("SELECT TagName FROM [TruBio].[dbo].[UnitRecord] WHERE Id = " + id.toString());
}
catch(e)
DL.MessageBoxAsync(e.toString(), "Exception", Constants.MessageBoxButtonType.MB_OK, 30);
The query itself seems ok as it can be executed in SQL
Regards,Navin Singh