Unfortunately it needs to be in the def, but based on your select statement,
you are looking in arcontainer, which is where Deployable Apps are
stored...if you were looking in form, then I might have hope...:) 

-----Original Message-----
From: Richard Marsha [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 14, 2008 12:15 PM
To: [EMAIL PROTECTED]; LJ LongWing
Cc: Rick M
Subject: Re: Form Application from Def file

LJ,
I'm not sure about a .def file, but here is how I think you can get it from
the DB:

--------------------------------------------
select distinct a.name, a.containerid
from arcontainer a, 
     (select containerid 
          from arreference 
          where referenceobjid = (select schemaid 
               from arschema 
               where name = 'Sample:ClassCentral')) b where b.containerid =
a.containerid
--------------------------------------------

Be sure to replace 'Sample:ClassCentral' for your form name.

--=Richard

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Reply via email to