Dave,
Thanks for your help but to make sure I understand correctly, are you saying unless the forn name has a non alphanumeric character the table name should be the same with the form name? If the form name is 'EmployeeInformation' then the table name would be 'EmployeeInformation' kind of.....
Thanks again
Dave Saville <[EMAIL PROTECTED]> wrote:
Dave Saville <[EMAIL PROTECTED]> wrote:
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
How low will we go? Check out Yahoo! MessengerÂ’s low PC-to-Phone call rates. __20060125_______________________This posting was submitted with HTML in it___
