[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference iosg::all-in-1_v30

Title:*OLD* ALL-IN-1 (tm) Support Conference
Notice:Closed - See Note 4331.l to move to IOSG::ALL-IN-1
Moderator:IOSG::PYE
Created:Thu Jan 30 1992
Last Modified:Tue Jan 23 1996
Last Successful Update:Fri Jun 06 1997
Number of topics:4343
Total number of notes:18308

641.0. ""CROSS" or "JOIN" 2 Entry Forms" by NBOIS::MARSING (Gerhard Marsing @NBO) Thu May 07 1992 11:39

hello allin1ers,

i have a problem, that i suppose much a1 specialists have solved it .


there are two entry forms

DEPART_ENTRY   with fields   DEPART_NO, DEPART_NAME, DEPART_FUNCTION_NR
and
FUNCTION_ENTRY with fields   FUNCTION_NR, FUNCTION_NAME


i want to have on a DEPART_NAME field on any other form the recognition list 
output as follows:

DEPART_NAME      FUNCTION_NAME
.....            ......
.....            ......


up to now i built my list temp. outputfile with the following DATAtrieve 
command:

print DEPART_NAME , FUNCTION_NAME of DEPART_DOM cross FUNCTION_DOM with
      DEPART_FUNCTION_NR = FUNCTION_NR and DEPART_NAME starting with ....
      ON OUTPUT.LIS


is there any way to do that "Cross" directly in allin1 ?
what about the Qualifier /SFILE with BIND statement ? does that have anything 
to do with my problem ?
can anyone give a explanation of the /SFILE qual., because there is nothing 
in the a1 documentation ?

many thanks in advance
Gerhard Marsing, thought to be an a1 specialist up to now
T.RTitleUserPersonal
Name		DateLines
641.1/SHOWUTRTSC::BOSMANWe're just sugar mice in the rainThu May 07 1992 12:018
    Hi,
    
    Could you try (I only use the first letters):
    
    /VALID = de.dn
    /SHOW  = ".dn ' ' fe.fn[.dfn]"
    
    Sjaak.
641.2extended problemNBOIS::MARSINGGerhard Marsing @NBOThu May 07 1992 13:4814
thanks,

this implied nested for loop is a solution, but now i want to use it 
in an index form, so i have to built a phantom dataset with this data, 
so i have to do a "real" join to get a new table (like a view in rdb).

any other solution around in shrinking human digital skills pool ?

is there any further solution in combination with SRA (stand. 
Rel.Access) Asset ? i want to access rdb data.

mercy,Gerhard Marsing
641.3SRA, SRA, SRA, SRA!!SHALOT::LANPHEARTest the water or turn the tide?Thu May 07 1992 15:1111
    Hello Gerhard,
    
      Since Joe Duncan hasn't responded (he's not here this week), and I
    happen to sit next to his cube, I'll add his emphasis that yes, you
    want to go with SRA.  Definitely.  Better than that sliced stuff.
    
      Especially for Rdb data.  For example, on a form, Joe just told me
    last week that you can use /TABLE, /FIELDS and /JOIN to really make 
    things work the way you want.
    
    						Cheers, acting Joe, Dan'l
641.4/alias?IOSG::CARLINDick Carlin IOSG, Reading, EnglandThu May 07 1992 15:436
    To produced your "joined" index you may be able to use the /alias
    directive to derive the function_name from the function_nr. I seem to
    remember doing a similar thing in the past. I can't remember the exact
    details, but I'll try an experiment when I get time.
    
    Dick
641.5/AlIAS, as Dick saidIOSG::ALLANDerek, DTN 830-3669Thu May 07 1992 19:2816
	Dick is right. If I understand your example properly your index form
        would be scrolling a phantom bound to your department data-set. One
        of the FMS fields in your display would be called DEPART_NAME in order
        to pick up the corresponding data-set field. The other field in your
        index could be called anything, but would be qualified by

        /ALIAS ="FUNCTION_ENTRY.FUNCTION_NAME[.DEPART_FUNCTION_NR]"
                                              ^
	Note the dot          ................|

        Inside the /ALIAS qualifier you can use the .FIELD syntax to obtain
        the value of the field inside the record being scrolled, and thus use
        it to key into another data-set as above.

	Cheers,
	Derek
641.6SRA knows relational algebraSHALOT::DUNCANJoe - CIS/EIC Doc. Mgmt. Solution Set ConsultantMon May 11 1992 17:3115
    Gerhard,

    Since what you want to do is do a join of two tables (which I assume
    are in and Rdb/VMS database, because of your comment in .2), I would
    definitely recommend considering using VAX SQL Relational Access for
    ALL-IN-1.  If your join is one that you will be doing over and over
    again, then you could create a view in the Rdb database, and then
    access the view using an SRA entry form.  SRA allows you to add
    criteria to be used against views, if these vary at run-time.  Since
    you are in Europe, contact your local ASSETS library for SRA.  In the
    U.S., the proper procedure is to contact the Cross-Industries EIC.  For
    more information on SRA, check out the notes conference, SHALOT::SRA.

    Joe Duncan @ OPA