Hi all - This Direct SQL seems like it should work, but I am getting an error message (in Mid-Tier, 7.6.03).
UPDATE HPD_Help_Desk SET UM_Opened_By = '$USER$', UM_Opened_Date = DATEDIFF(second,'01/01/1970 00:00:00','$TIMESTAMP$') +14400 WHERE Incident_Number = '$Incident Number$' ; The above Direct SQL should translate to this: (which actually works as is in ARUtilities' SQL); UPDATE HPD_Help_Desk SET UM_Opened_By = 'myuserid', UM_Opened_Date = DATEDIFF(second,'01/01/1970 00:00:00','05/09/2012 03:00:00 PM') +14400 WHERE Incident_Number = 'INC000000031826' ; So what is Direct SQL doing to this sQL??? Is it the $Incident Number$ or $USER$ or $TIMESTAMP$ ??? I actually tried it withOUT the $TIMESTAMP$... and I had some NULL / IS NULL etc in there and had to take that out as I couldn't get the nulls to work in the WHERE statement. I thought it was working --- although that was in the BMC Remedy Client, not Mid-Tier. It is easier for me to test in the Client because I don't have to Flush Cached every time I tinker with the AL's. So close.... On the Client I was testing and found that the fields were being updated every Other time! However I am looking at ARUtilites in a SELECT statement after every step to see what happened... and maybe IT is only working every other time. Good grief! Any other ideas out there? Or maybe sympathy?? I know the Client works differently than the Mid-Tier but this is very tiring. Thanks for listening!! -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Direct-SQL-in-Active-Link-problems-tp7547138.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
