So you want a view form 1 record that has only 1 column? What do you have in the Form Properties, View Information tab?
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Gopal-srg Sent: Wednesday, May 26, 2010 2:11 AM To: arslist@ARSLIST.ORG Subject: Remedy View forms and SQL 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"