Joe, I think Smiley is heading down the wrong path using Direct SQL. Seems like what Smiley really wants to do can be done with a push fields.
Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, May 07, 2012 1:30 PM To: arslist@ARSLIST.ORG Subject: Re: to commit or not to commit... that is the question Wait a minute.. what exactly are you after here.. 1) Are you attempting to write a Direct SQL in a Set Field action an set values from a SQL to certain fields on the current form? (In which case the $1$, etc values will apply).. In this case results are returned back to the fields mapped using the $ variables.. 2) Are you trying to write a Direct SQL statement (update) that does not return any result back but just runs a transaction against the database? In this case you are to use the Direct SQL action (not the set field action with SQL results selected as the set fields operation). And you said you weren't able to find the column ID of a new field created by you? If you do not want to list the fieldname and ID's using the SQL I gave you earlier, you could also see the field ID of this new field from your Admin (Development Studio) client. The Properties of the field should display the Database ID of that field. The Database ID is your column number that you are seeking.. I find it a lot easier to list these using the SQL that I gave you earlier.. Joe -----Original Message----- From: smiley Sent: Monday, May 07, 2012 1:18 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: to commit or not to commit... that is the question well.... close but still no cigar. I'm in ARUtilities in the SQL section, to see the views and columns. If I do a simple SQL like this - SELECT * FROM HPD_Help_Desk --- what I see are rows with COLUMN names. The COLUMN NAMES are: Column 1, Column 2, .... etc until I see Column 237... which seems to be cut off. There is data in many columns. At one point Joe you very helpfully said to use $1$ for the 1st column, etc. I'm wondering... what is My New Fields' Column Number? It is not the Field ID. It is a Column number. I'm wondering how to see My Field Name and its column number, within the particular Form/View I'm in. I did try this: select $1$, $2$, $3$ from HPD_Help_Desk --- and I received an error. I sure don't see any help with this in the manuals. I also tried this - and also received an error: select * from HPD_Help_Desk WHERE "Column 5" = 'AR_ESCALATOR'; AND I tried this also to no avail: Select F950000018 from HPD_Help_Desk; I'm not sure what to do. I appreciate ANY HELP AT ALL. Thanks!!! _______________________________________________________________________________ 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"