Remedy View forms and SQL

2010-05-26 Thread Gopal-srg
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

Re: Remedy View forms and SQL

2010-05-26 Thread Hany Abd El_Fatah
: 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

Re: Remedy View forms and SQL

2010-05-26 Thread Gopal-srg
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

Re: Remedy View forms and SQL

2010-05-26 Thread Hany Abd El_Fatah
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

Re: Remedy View forms and SQL

2010-05-26 Thread Grooms, Frederick W
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