David J Murray
~ Learn and Do - Excel and Share ~

SB+ 5.4 New Select Feature

Aug 4, 2006

Image by Chaos07 from Pixabay

You're Reading: SB+ 5.4 New Select Feature

A post in MVDBS & SystemBuilder & U2 & UniVerse

One of the really good features of the 5.4 upgrade is the ability to add the ‘Additional Selection Parameters’ to the end of an S: process.

The format is (from the SB+ reference manual, page 3-237):

S:SELECT filename [ selectioncrit ] [ dispfields ] [ (options [ (processafter ] ]

Now add 5.4 stuff,

S:SELECT filename [ selectioncrit ] [ dispfields ]
[ (options
[ (processafter :@VM:@VM:
processdrilldown:@VM:
drilldownchartext:@VM:
drilldownguitext:@VM:
downloadentirelist]]

See the Selection Process for more info. The downloadentirelist is ‘1’ for all in list.

So, what is the big deal?

Well, it means that I can create a process (Paragraph) that will always select the criteria I want. I can then pass as parameters (@PARAM) what type of format I want the list returned as.

Sometimes I want the user to select a subset of the list or just one item. Sometimes I want the whole list – for a report. Sometimes I want it in @VALUE, sometimes data stacked.

Therefore, I can use the process in as intuitive help, as a validation, as a selection in a report and many other places. I always get the same list back, and there is only ONE place to edit and control for changes.

Always the same financial transactions, same postcodes, same whatever…

It was always possible to do this by the changing the options, but now the S: process is complete.

Useful.

About the Author

<a href="https://davidjmurray.org/author/davidjmurray/" target="_self">djm</a>

djm

I have been in the computer/IT industry for over 35 years. After spending half a life-time in highly proprietary database environments, I have succumbed to the WordPress Eco-system and I'm well down the chasm. I am specializing in AWS hosting, Wordpress CMS, Elegant Themes, in particular Divi and Extra themes.

0 Comments

Submit a Comment

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Pin It on Pinterest

Share This