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!!! -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/to-commit-or-not-to-commit-that-is-the-question-tp7535439p7536181.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"
