If you're going to use C id's instead of your field names, you need to replace HPD_HELP_DESK with the T table. The views like HPD_HELP_DESK don't have the C names, they have the database name you gave your field. (replace spaces with underscore)
You also need to put single quotes around '$USER$' and '$Incident Number$' Jason On May 7, 2012, at 1:48 PM, smiley <nti...@umich.edu> wrote: > Hi again - > > Here is my (hopefully) correct Direct Sql (which is an Action within my > Active Link): > > UPDATE HPD_Help_Desk SET C950000018 = $USER$, C950000019 = $TIMESTAMP$ > WHERE C1000000161 = $Incident Number$ > > The 'C' numbers are my Field ID's. I'm not sure if I'm supposed to indicate > the form HPD:Help Desk with the view HPD_Help_Desk. > > A SQL using the same column names is not working at all in ARUtilities > > SQL, so ... I'm not sure how to test it. > Any ideas how to test this?? > > I'm used to Oracle dbs, not MS SQL Server. > I really appreciate it!!! > Thank you for your help!!! > > -- > View this message in context: > http://ars-action-request-system.1093659.n2.nabble.com/to-commit-or-not-to-commit-that-is-the-question-tp7535439p7536315.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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
