On Sun, 27 Aug 2006 09:05:50 -0700, Mimi Lakew wrote: >Hi Lisr, > > I am trying to use Direct SQL action which I never used before. My > understanding is, on the SQL statement the table name has to be defined. Like > "select * from tablename" I am trying to search an ARS form, is there anyway > to find what the table name is on the database for the form?
The *real* table name will be Tnnn where nnn are digits. However Remedy sets up "views" and you can use the form name with the proviso that any non alphanumeric character in the name will be changed to an underscore. So a form called "My Form" would be My_Form. This also applies to field names. It is better to use these views as they are consistent across the same tables on different installations of ARS. "MY Table" might be T123 one box and T456 on another - a maintenance nightmare and a wonderful source of error :-) HTH -- Regards Dave Saville _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
