[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

1299.0. "Creating index form with two datasets" by QCAV01::SETHU () Mon Aug 24 1992 15:05

Hi,

I am using All-in-1 version 2.4.

I want to build an index form with two datasets.

The first dataset is a master file and it contains the type of reports
which can be created by the users.

Dataset 1 say contains two fields Rept_id and Rept_name.

For example, 

Rept_id  Rept_name 
1	 X
2	 Y
3	 Z

The dataset 2 is in the users area and contains two fields Rept_id and 
date_created.

For example,

Rept_id  Date_created
1	 12-aug-1992
2 	 14-aug-1992

Now, I want to create a phantom dataset so that the index form looks like this

Rept_id Rept_name Date_created
1	X	  12-aug-1992
2	Y	  14-aug-1992
3	Z	  Not created.

The 'Bind' function in the manuals talks of creating phantom-data-set to 
only one dataset. 

Could you please suggest a way by which I can create a index form with
two datasets.

Thanks in advance,


Sethu.
T.RTitleUserPersonal
Name		DateLines
1299.1It can be done, but Digital may get in the way...SHALOT::DUNCANJoe - CIS/EIC Doc. Mgmt. Solution Set ConsultantMon Aug 24 1992 15:5311
    The only two ways that I know that this could be done would be to 1)
    use RdbAccess for RMS with VAX SQL Relational Access for ALL-IN-1
    (SRA), or 2) use the memory DSAB which has been prototyped by our
    group, but is waiting for a paying customer to finish it.

    The problem is, since our group is going away, getting SRA will only be
    simple for customers outside the U.S. (U.S. customers will have to get
    it from European ASSETS Program, I guess).  Also, since our group is
    going away, so goes lots of things like the Memory DSAB.

    Joe Duncan @ OPA
1299.2IOSG::WDAVIESThere can only be one ALL-IN-1 MailMon Aug 24 1992 16:045
    I thought I saw plenty of other requests for this style of
    display -and I'm sure in simple cases that ALL-IN-1 can simulate the
    RDB functionality (unions)
          
    Winton
1299.3/ALIAS to the rescue...?HYTIDE::CREAMERSay Goodnight, CharlotteMon Aug 24 1992 19:0423
	Sethu,

	If your purpose is to display data from two data sets, then 
	Yes, it can be done by using /ALIAS.

	1) Create a DISPLAY_ONLY/NOECHO field on the line before the 
	   field that will come from dataset_2.
	2) In the named data for this field, use:
	   /ALIAS=OA$FUNCTION='.IF #TMP=DATASET_2.DATE_CREATED[.REPT_ID]
	    EQS "" THEN GET #TMP = "Not created."'
	3) In the named data for the date_created field, use:
	   /ALIAS=#TMP.

	This doesn't BIND to both datasets, but does allow you to display
	data from two datasets.  

	You might also look in note 1127.  Someone was trying something
    	similar there.

	HTH,

	Jack
1299.4joins .NE. unionsSHALOT::DUNCANJoe - CIS/EIC Doc. Mgmt. Solution Set ConsultantMon Aug 24 1992 21:098
>    I'm sure in simple cases that ALL-IN-1 can simulate the
>    RDB functionality (unions)

    Unfortunately, they need a relational join.  The performance of V2.0 of
    RdbAccess for RMS is actually pretty  good.

    Joe Duncan @ OPA
1299.5IOSG::WDAVIESThere can only be one ALL-IN-1 MailTue Aug 25 1992 15:121
    .2  is what I was thinking off !