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"

Reply via email to