(800) 219-8613sales@ashwoodcomputer.com
 
FacebookTwitterYouTubeLinkedin
Ashwood Computer, Inc.
Ashwood Computer, Inc.
Your Total Solution Provider
  • Home
  • About Us
    • Blog
    • Careers
  • Products & Services
    • ForeMost
    • FastBac DR
    • Training & Education
    • Fund Accounting
    • Evoke by BlueFinity
  • Testimonials
  • Contact
Menu back  

Sometimes the Simple Things… Dictionary Ideas

September 26, 2017Leave a commentProgramming

Sometimes its the simple things in life. I have a favorite Dictionary record I’d like to share with all of you. It is the constant “1”. What can you do with a Dictionary Record of “1”? First, create a dictionary record with the constant “1” and call it “ITEMS” (see below).

Then if you want to know how many employees you have in each department (Assuming you have an EMPLOYEE file with a DEPT attribute)

LIST EMPLOYEE BREAK-ON DEPT BY DEPT TOTAL ITEMS DET-SUPP ID-SUPP (Your flavor of mutlivalue may vary on this)

You will get a list of departments with the number of employees in each department.

So anything you need to know how many of a certain type of item is in your file, you can modify the above query to provide that information.

Pick Flavor Dict Item (Thanks to Clif Oliver)

ITEMS

0001 S
0002 0
0003 ITEMS
0004
0005
0006
0007
0008 F;C1
0009 R
0010 8

Information Flavor Dict Item

ITEMS

0001 I
0002 1
0003
0004 ITEMS
0005 8R
0006 S

D3jBaseMultivalue BASICmvBasemvEnterprisePick BASICQMUniDataUniVerse
Share this post
FacebookTwitterGoogle+PinterestLinkedIn
Related posts
Ashwood Computer, Inc.
BASIC Code to calculate a programs elapsed wallclock time
July 17, 2017
Leave Comment

Cancel reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

clear formSubmit

Get in touch

    Name *

    Email Address *

    Message *

    Ashwood Computer, Inc.
    • Address
      10671 Techwoods Circle Cincinnati, Ohio 45242
    • Telephone
      (800) 219-8613
      (513) 563-2800
    • Fax
      (513) 554-6412

    Find us on:

    FacebookTwitterYouTubeLinkedinMail
    Ashwood’s Blog
    • As one of the only IBM Business Partners serving MultiValue Database Users we’re excited to offer this New IBM Storage Solution!
      February 11, 2021
    • Improve Your Back-Up Processes with Ashwood’s Pre-Processor – FastBac!
      February 10, 2021
    • Interested In Low Code For Your MultiValue System? You Need EVOKE From BlueFinity!
      January 20, 2021
    Our Value – Added
    • Quality Policy

      Ashwood Computer, Inc. provides quality products and services that consistently meet our customer's requirements, while continually searching for ways to improve them.

    • Experienced Staff

      Our experienced project managers will help you successfully accomplish your goals on time and with optimum results! Our continuing success is attributed to the diverse backgrounds of our technical staff and our overall company drive for Total Customer Satisfaction!

    • ForeMost

      ForeMost ERP is an impressive new 'Hybrid' Solution developed utilizing our mvTools.
      ForeMost is dramatically improving our customers information systems and business operations. Moreover ForeMost provides our customers a significant competitive advantage!

    © 2017 Ashwood Computer, Inc.

    Ashwood Computer adheres to ISO 9001:2008 standards, a quality management system recognized around the world for quality design and production.