Grouping Master/Detail Relationships in ACE

Path: emory!swrinde!cs.utexas.edu!uunet!boulder!csn!yuma!ccncsu!lamar!sharif From: sharif@lamar.ColoState.EDU (Thomas Abdallah) Newsgroups: comp.databases.informix Message-ID: <19910@ccncsu.ColoState.EDU> Date: 10 Dec 91 21:00:58 GMT Sender: news@ccncsu.ColoState.EDU Organization: Colorado State University, Fort Collins, CO 80523 Newsgroups: comp.databases.informix Summary: Organization: Colorado State University, Fort Collins, CO 80523 Keywords: I have a question regarding the ACE report writer's ability to handle multiple Master/Detail relationships. Here's the layout I'm working with. formdef(*formid, ftype, fname, appnum) skunkmark(*formid, sheetnum, sidenum, rownum, colnum) recorddef(*formid, question, qtype, qlength, qstart, qend) * - This is a key attribute. An ER-D representation of this arrangement looks like: +---------+ |skunkmark| +---------+ \\|/ | +---------+ | formdef | +---------+ | /|\\ +---------+ |recorddef| +---------+ What I would like to do is generate a report that looks like the following. Type of Form: __(ftype)__ ID #: _(formid)_ Application Name: _____(fname)_____ Application #: _(appnum)_ Skunk Marks: Sheet # Side # Row # Column # _(sheetnum)_ _(sidenum)_ _(rownum)_ _(colnum)_ _(sheetnum)_ _(sidenum)_ _(rownum)_ _(colnum)_ _(sheetnum)_ _(sidenum)_ _(rownum)_ _(colnum)_ _(sheetnum)_ _(sidenum)_ _(rownum)_ _(colnum)_ Questions: Question # Type Length Start End _(question)_ _(qtype)_ _(qlength)_ _(qstart)_ _(qend)_ _(question)_ _(qtype)_ _(qlength)_ _(qstart)_ _(qend)_ _(question)_ _(qtype)_ _(qlength)_ _(qstart)_ _(qend)_ _(question)_ _(qtype)_ _(qlength)_ _(qstart)_ _(qend)_ _(question)_ _(qtype)_ _(qlength)_ _(qstart)_ _(qend)_ _(question)_ _(qtype)_ _(qlength)_ _(qstart)_ _(qend)_ _(question)_ _(qtype)_ _(qlength)_ _(qstart)_ _(qend)_ _(question)_ _(qtype)_ _(qlength)_ _(qstart)_ _(qend)_ Now, if I were attempting this with only one detail table it would be a piece of cake. However, I cannot find, anywhere in the Documentation, how to get multiple groups to output. I imagine that what I'm looking for is something like the ON EVERY ROW statement, except that I would like to use this multiple times. I am using the 4.01 SE Engine with the ISQL front-end on an HP9000-835 running under HP-UX 7.0. Any comments and/or suggestions would be greatly helpful. - Thanks in advance ! Thomas-Sharif Abdallah (Data Manager - Tri-Ethnic Center for Prevention Research, Colorado State University) +-------------------------------------+ | email: sharif@lamar.colostate.edu | | fax : (303) 491-0527 | | phone: (303) 491-7863 | | usmail: C076 Clark Building | | Colorado State University | | Fort Collins, CO 80523 |