Hi, i think you should first create view with your query in the DB and then create the view form on the new view
On Wed, May 26, 2010 at 10:11 AM, Gopal-srg <srgr...@gmail.com> wrote: > Hi all, > i am just trying to create a remedy view form and environment details are > below > DB : Oracle > ARS: 7.0.01 > > i wont to pull the data from the form which is present in the same > database( > as arsystem tablenamespace) under user sys(System tablenamespace) using > remedy view forms using SQL query. > > my query in Remedy view form is "SELECT TABLE_NAME FROM SYS.ALL_TABLES > WHERE > OWNER='ARADMIN' AND TABLE_NAME='T1' " > > when i am trying to load the columns its throwing error like > "Failure during SQL operation to the database : ORA-00933: SQL command not > properly ended (ARERR 552)." > > > Please help in solving the issue. > > Regards, > SQL > -- > View this message in context: > http://old.nabble.com/Remedy-View-forms-and-SQL-tp28677247p28677247.html > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > -- BR, Hany _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"