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:[email protected]] On Behalf Of Gopal-srg Sent: May 21, 2010 8:30 AM To: [email protected] 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"
