Any luck, I am trying to get this SQL query working for the same:(sql query to find list of all the fields and the forms used in join forms)
Trying something like below: select queryshort from schema_join where schemaid=3128 result: 4\1\99\536870913\1\1\ so, I see that 536870913 from Form A is joined with 1 from Form B. But it would good to have field db ids listed along with form names ? On Friday, May 29, 2009 12:54:09 AM UTC-7, Frex Popo wrote: > > ** > Dear all, > > I am looking at an issue with some join forms. I found a couple using > fields - in the join criteria - that are not indexed. However since we have > over a 100 join forms and would like to check them all, I would like to > know if anyone - without reinventing the wheel - has a sql query which > looks at the data dictionary tables and tell me which join form(s) is using > a field in the join criteria that is not indexed. > > Environment: ARS7.1/AR SQL 2005 > > Regards > frex > > _Platinum Sponsor: [email protected] <javascript:> ARSlist: "Where > the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
