Just to add to Jason, replace spaces & special characters with _.
You should see all your columns in your DB table or view if you describe
(describe or desc) it..
eg:
Desc HPD_Help_Desk
Desc Tnnn (replace nnn with the schemaid as appropriate)
This works on Oracle..
If you are using MS SQL or Sybase, describe will not work.. On MS-SQL &
sybase use:
sp_help HPD_Help_Desk
Joe
-----Original Message-----
From: Jlbess
Sent: Monday, May 07, 2012 2:46 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: to commit or not to commit... that is the question
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!!!
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"