Groups | Search | Server Info | Login | Register

Groups > comp.databases.pick > #2385

Can a dictionary do a TRANS to another file, and then a DCount on the same dictionary to count the number of Multi Valued items?

Newsgroups comp.databases.pick
Date 2016-06-01 11:59 -0700
Message-ID <74de3acf-f142-49ec-a1a0-a8947b5d67cd@googlegroups.com> (permalink)
Subject Can a dictionary do a TRANS to another file, and then a DCount on the same dictionary to count the number of Multi Valued items?
From sueglo <suefab2000@gmail.com>

Show all headers | View raw

Hello Group, 

I have an I-Descriptor Dictionary that works going from one file to another and picks up attribute 1 in the other file, works great.  It is a Multivalued Field.
 
I don't know if this is possible or not, and am hoping that one of you might have an idea for me.
 
Here is the Dictionary - 
 
Pa.Cov is the file name, POLKEY IS <4> In PA.COV, 
Polkey is the Recid for the Policies.Vehicles file, Multivalued, which I need to get a count of how many there are.
 
Veh.Ct

1 I
 
2 TRANS('POLICIES.VEHICLES',POLKEY,1,'C')

 
3  

4  VEHCT

5  50L

6  SM

I get the results I want for this - takes me to the right place -

LIST PA.COV VEH.CT 02:53:36
PA.COVERAGES VehCt.........

179356       623713
             623714

182840       637952
             637951

179360       623719

175644       610255
             610256

186264       650926

177237       615841
             615842

186919       653303
             653304

172588       597821
             629263
             597822

175324       609181

179735       625290
             628839

182954       638157
183896       642215


What I would like to get for this info, take the first item for example - 
179356 should show me the number 2 because there are 2 items in the attribute <1>

I tried to add this DCOUNT on to line 2 of the dictionary above, it only gave me the number 1 - even if there were 7 items on line 1.
 
TRANS('POLICIES.VEHICLES',POLKEY,1,'C');DCOUNT(@RECORD<1>,@VM)

Is there any way any of you can think of that I can get the result I would like?  I am all ears!

Thanks, 
Susan

Back to comp.databases.pick | Previous | Next — Next in thread | Find similar

Thread

Can a dictionary do a TRANS to another file, and then a DCount on the same dictionary to count the number of Multi Valued items? sueglo <suefab2000@gmail.com> - 2016-06-01 11:59 -0700
  Re: Can a dictionary do a TRANS to another file, and then a DCount on the same dictionary to count the number of Multi Valued items? kpowick@gmail.com - 2016-06-01 13:54 -0700
  Re: Can a dictionary do a TRANS to another file, and then a DCount on the same dictionary to count the number of Multi Valued items? brac5301@gmail.com - 2016-06-02 08:54 -0700
    Re: Can a dictionary do a TRANS to another file, and then a DCount on the same dictionary to count the number of Multi Valued items? Ross Ferris <ross.ferris@hotmail.com> - 2016-06-05 16:47 -0700
      Re: Can a dictionary do a TRANS to another file, and then a DCount on the same dictionary to count the number of Multi Valued items? sueglo <suefab2000@gmail.com> - 2016-06-06 09:31 -0700
    Re: Can a dictionary do a TRANS to another file, and then a DCount on the same dictionary to count the number of Multi Valued items? sueglo <suefab2000@gmail.com> - 2016-06-06 09:31 -0700
  Re: Can a dictionary do a TRANS to another file, and then a DCount on the same dictionary to count the number of Multi Valued items? wjhonson <wjhonson@aol.com> - 2016-06-07 10:03 -0700

csiph-web