Or create a view form against the arschema table and set schemaId to be the 'Request ID' for the view.
JUST DO NOT CHANGE DATA VIA THIS VIEW FORM. ( You will likely mess things up and BMC support will likely laugh at you and ask if you have an RDBMS backup to restore from.) Note: Set field actions can look in the View form too. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 10/10/06, Joe DeSouza <[EMAIL PROTECTED]> wrote:
** First of all your query is wrong.. It should be select name from arschema where schemaid = 907 After you fix your access issue with the user that is querying the database, you would get the results you want using the above query. Cheers Joe D'Souza Remedy Developer / Consultant, Shyle Networks, New Jersey. ----- Original Message ---- From: Mimi Lakew <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, October 10, 2006 3:26:26 PM Subject: Re: form name ** I am trying to get the form name used in Remedy. I used : SELECT name FROM arschema where schemaid = 'T907' but it is giving me an error message. I don't have access to the SQL Server. "Heider, Stephen" <[EMAIL PROTECTED]> wrote: ** Mimi, If you are asking about the name used in a SQL Server query open up SQL Server Enterprise Manager or SQL Query Analyzer and look at the SQL Views. For each data form there is a SQL View. For the most part the SQL name of a form is the same as the Remedy name with certain characters substituted. See Database Reference Guide v6.3, page 41 for more details. HTH Stephen ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mimi Lakew Sent: Tuesday, October 10, 2006 1:47 PM To: [email protected] Subject: form name ** Hi all, I have a table name on a set field action SQL statement and I want to know what the form name could be. Is there anyway to find out a form name using the table name? I will appreciate your help ________________________________ Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ ________________________________ Get your email and more, right on the new Yahoo.com __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
