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: [email protected]
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"
