{\rtf1\ansi\ansicpg1252\deff0\deftab360{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fswiss\fcharset0 Arial;}}\viewkind4\uc1\pard\lang1033\f0\fs20 I do not have an explanation as to how you may have possibly lost that view (any number of reasons for that from accidental deletion by a DBA to your guess as good as mine), but if you create a new field on the form (just a dummy field) the AR System should be able to rebuild that view as views get updated with alterations on the underlying T table structure.. You can drop the field after the view has been rebuild..\par \par Cheers\par \par Joe\par \par -----Original Message-----\par From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Dwayne Martin\par Sent: Wednesday, February 13, 2008 11:22 AM\par To: [EMAIL PROTECTED] Subject: Form sql view not found\par \par \par Hello Everyone,\par \par We have a form named \ldblquote LA:SoftwareInstall.\rdblquote For years we have queried the database using the view name \ldblquote la_softwareinstall.\rdblquote Now that view is no longer present. If I look at a list of all our views on the database (Oracle 10.2 db) I see views for the other forms, but nothing resembling \ldblquote la_softwareinstall.\rdblquote It is missing in both our test and live databases.\par \par Last year we copied our existing database to a new server, then installed the 7.1 ARS system on top of it. Is it possible that the \ldblquote la_softwareinstall\rdblquote view somehow got left behind in the database copy?\par \par Is there an easy way to get it back again? I know we could use a complicated "create view" statement directly in Oracle, but would that even be wise?\par \par Dwayne Martin\par James Madison University\fs18 \f1\fs20\par }
