Hi Hany, Thanks for ur response. the view for the form which i try in SQL already exist in the database.
Also error which it throws is like some error in the SQL definition. Regards, Gopal Hany Abd El_Fatah wrote: > > 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" > > -- View this message in context: http://old.nabble.com/Remedy-View-forms-and-SQL-tp28677247p28677930.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"