I read "view forms(Created using Native SQL Prev6)" in your email. You cannot make a "view form" in Oracle. You can make an Oracle "View". Also you can make that view in any instance and under any id or schema - not necessarily the ARS one. I also do not understand what "Prev6" is.
If the view was created in SQL, ARS will not know of it. You will have to create an ARS View table pointing to the Oracle view if you want ARS to know about it. You will see only ARS defined objects - View Forms for example - in the ARS tools. You can query Oracle for views tables etc. I suggest you read up a bit on ARS, Oracle, and get an Oracle database tool that presents you a graphical interface like Toad or one from Oracle. I also suggest you brush up on forming SQL queries. Good luck, Ben -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Gopal-srg Sent: May 21, 2010 12:46 PM To: arslist@ARSLIST.ORG Subject: Re: View forms and Remedy Schema tables Hi ben, Thanks for ur response.we are having a situation here like there are some view forms(Created using Native SQL Prev6), somehow for some os these view forms the T ables ,H Tables and B tables has been dropped off from the databse(Oracle). We need to find such those view forms. Are we need to query the oracle databse to know this information or there is another way to find out those view forms that do not T,H and B tables using a AR admin and AR User tool? One more question is, are the view forms without the T,H and B Tbales will be visible in AR Admin tool? Please provide information for the above queries, it will be more helpful... Regards SRG Ben Chernys wrote: > > How to find out almost anything: Look the documentation! > Specifically AR System Database Reference, and, for the "SchemaType" integers, file "ar.h" > (not the best spot) > > select name from arschema where schematype = 3 > > #define AR_SCHEMA_NONE 0 /* null schema */ > #define AR_SCHEMA_REGULAR 1 /* regular schema */ > #define AR_SCHEMA_JOIN 2 /* join schema, has two member schemas */ > #define AR_SCHEMA_VIEW 3 /* view schema, has one base schema */ > #define AR_SCHEMA_DIALOG 4 /* dialog schema, only display-only fields > */ > #define AR_SCHEMA_VENDOR 5 /* vendor schema */ > #define AR_SCHEMA_MAX_SCHEMA_TYPE 5 /* list the max type of schema */ > > Ben Chernys > > Senior Software Architect > Software Tool House Inc. > > Canada / Deutschland / Germany > Mobile: +49 171 380 2329 GMT + 1 + [ DST ] > Email: Ben.Chernys _at_ softwaretoolhouse.com > Web: www.softwaretoolhouse.com > > Check out Software Tool House's free Diary Editor. > > Meta-Update, our premium ARS Data tool, lets you automate your > imports, migrations, in no time at all, without programming, without > staging forms, without merge workflow. > http://www.softwaretoolhouse.com/ > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Gopal-srg > Sent: May 21, 2010 8:30 AM > To: arslist@ARSLIST.ORG > Subject: View forms and Remedy Schema tables > > Hi all, > I need some information regarding the remedy view forms. > How to find the view forms created with Native SQL(Prev6) which are not > having T tables? > > Regards, > SRG > -- > View this message in context: > http://old.nabble.com/View-forms-and-Remedy-Schema-tables-tp28630092p2863009 > 2.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" > > ____________________________________________________________________________ ___ > 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/View-forms-and-Remedy-Schema-tables-tp28630092p2863222 9.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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
