Hi, then you can check the fields type if it's supported from remedy or not, and if the view exist in the DB so all what you need is to write the view name in the view form not the SQL
On Wed, May 26, 2010 at 11:39 AM, Gopal-srg <srgr...@gmail.com> wrote: > 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" > -- BR, Hany _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
