Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!sdd.hp.com!spool.mu.edu!uunet!fciva!dag
From: dag@fciva.FRANKCAP.COM (Daniel A. Graifer)
Newsgroups: comp.databases
Subject: Question on Multi-Occurence Forms in Accell
Message-ID: <593@fciva.FRANKCAP.COM>
Date: 1 Apr 91 22:05:26 GMT
Article-I.D.: fciva.593
Reply-To: dag@fciva.UUCP (Daniel A. Graifer)
Organization: Coastal Capital Funding Corp., McLean, VA
Lines: 23

I am developing an application in Accell 1.4/Unify 4.0 and I am having
a problem with one of my forms.  The form is multi-occurance, and for
each record key found in the target table, I need to find 5 other related
record keys in the same table.  Finding these records requires three double
nested SET/SELECT/EXECUTING statements.  The problem is that non-database
screen fields are not inherently multi-valued, even if you include them in
the repeating area, or set their multi-occurance attribute explicitly.  Thus,
each time the user changes record, the 5 other records have to be relocated.

This all takes too long (about 1 second per 'master' record key).  Is there
some way to store the other 5 key values for each record so that I don't
have to find them again every time the user hits NEXT/PREVIOUS RECORD?  The
only idea I've come up with is to write a set of c-hook functions to 
initialize, load, and query an array of tuple-numbers pointed at by some
global.  That's awfully kludgy.  Any other ideas?

Thanks in advance
Dan
-- 
Daniel A. Graifer			Coastal Capital Funding Corp.
Sr. Vice President, Financial Systems	7900 Westpark Dr. Suite A-130
(703)821-3244				McLean, VA  22102
uunet!fciva!dag				fciva.FRANKCAP.COM!dag@uunet.uu.net