My application currently uses the following to set a variable for use by a MS SQL Sever 2014 database trigger. This does not work in PowerServer. Is there a workaround of some variety?
ls_SQL = "Declare @TheUser VARCHAR(128) SET @TheUser='" + as_userid + "'" &
+ " Declare @BinUser varbinary(128) SET @BinUser=CONVERT(varbinary(128), @TheUser)" &
+ " SET CONTEXT_INFO @BinUser"
EXECUTE IMMEDIATE :ls_SQL USING SQLCA;