Not true. She doesn't need the T table. First off, if it isn't an ARS table there might (probably won't) be a T table unless it was created manually. However, you can still use the view instead. If it is a Remedy created table, then the view name has a specific format. All none alphanumeric characters are replaced with an underscore. Also, view names in an Oracle (and I assume the others) database is only 30 characters long if Remedy created the view. So if your view (form) name is longer than 30 characters just drop the exceeding characters. There is one other caveat in case you have more than one view name that is the same until past the 30 character limit. The last letter (number 30) is replaced by a sequential number starting with the second form and incrementing for each form. Check out my examples but please don't name your forms as such or think that I have mine named like this.
Form Name: CTM:People Site AP:Administration Join View Name: ctm_people_site_ap_administrat Form Name: CTM:People Site AP:Administration Role Join View Name: ctm_people_site_ap_administra2 Please only use this as an example. I didn't verify my thoughts from off the top of my head. Also, if you want the list of views just run this: select view_name from user_views order by 1 That will work in an Oracle db for sure. Also, I have not found a case sensitivity for form or field names when writing SQL queries. HTH, Brian Goralczyk On Thu, Mar 27, 2008 at 11:27 AM, Drew Shuller <[EMAIL PROTECTED]> wrote: > Yes, if it's owned by aradmin, she'll need the T table. > > Drew > > On Thu, 27 Mar > 2008, Nisha Ramtri wrote: > > > Lisa, > > > > This error normally occurs when the table name that is being provided is > > different from the actual name in the db. Check for the name, spelling > of > > the table in the database. The table name is case sensitive also. Hence > take > > care of that as well while providing the name of the table. Also make > sure > > that the table is in the aradmin d/b. Hope that helps. > > > > Rgd, > > Nisha. > > > > > > On 3/27/08, Kemes, Lisa <[EMAIL PROTECTED]> wrote: > >> > >> ** Also, I am typing the table name in CAPS. > >> > >> > >> Lisa > >> > >> > >> ------------------------------ > >> *From:* Action Request System discussion list(ARSList) [mailto: > >> [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa > >> *Sent:* Thursday, March 27, 2008 12:05 PM > >> *To:* [email protected] > >> *Subject:* View Forms > >> > >> > >> ** > >> > >> I'm trying to create a View Form that connects to a table on an Oracle > >> database and I'm getting the error message: > >> > >> "Requested database table not found. Please check the spelling (table > >> name is case-sensitive) (ARERR 481)." > >> > >> The table has aradmin added to the permission list. Is there anything > >> else I'm missing? > >> > >> AR Server 7.01 Patch 6 > >> Windows 2003 app Server > >> > >> *Lisa Kemes * > >> AR System Developer > >> Tyco Electronics > >> 717-810-2408 tel > >> 717-810-2124 fax > >> [EMAIL PROTECTED] > >> > >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > >> html___ > >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > >> html___ > >> > > > > > > > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
