Re: form name

[Joe DeSouza]

**

You're welcome..
 

Joe

----- Original Message ----
From: Mimi Lakew <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Tuesday, October 10, 2006 3:43:35 PM
Subject: Re: form name

** I got it thanks!!!!!

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: arslist@ARSLIST.ORG
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: arslist@ARSLIST.ORG
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

__20060125_______________________This posting was submitted with HTML in it___