Gary, The short answer is yes a view of a view can be modified. There are a couple caviates here.
One. The request ID field in remedy. I suspect from your error message that you have the address1 column matched to column 1 on the view form. even with view forms, Remedy needs a unique identifier field, like the request ID. Two. You have to make sure that the link is setup for you to be able to write to the table from your oracle database. Basically, if it can be done in the database, then you can make Remedy do it very easily. HTH, Brian Goralczyk On Wed, Apr 2, 2008 at 2:13 PM, Gary Dries <[EMAIL PROTECTED]> wrote: > ** I have created a Oracle (10g) to MSSQL (2003) dblink, I am able to > create the view, but I get sever fields that retrun the error > "Failure during SQL operation to the database : ORA-00904: "ADDRESS1": > invalid identifier (ARERR 552)." > We are researching several possible issues, such as permissions, and the > build of the table that I am creating the view of. > One suggetion I found searching the list is to create the view in Oracle > to the SQL db and then create the Remedy view to the Oracle view. > > Is it possible to create a view from a view, and if it is, can the data in > the SQL table be modifed from Remedy in this view of a view of a SQL table? > -- > Gary Dries > > __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"
