A trick for beginners…

I was using a paragraph process to select, sort and return items from another file. I wanted to reverse the order of the items based on entry date/time. But do you think that I could get the descending ‘BY’ feature to work.

The line was:


EXEC 'S: SSELECT TRANS BY.DSND DATE BY.DSND TME WITH CLIENT.ID = "' : CLIENT.ID : '" (ARZ'

Can you spot it? A hint – I normally work with uniVerse…

OKies, it is the BY.DNSD sort expression. As SB+ is PICK flavour based, it should be BY-DNSD!

Had me for 1/2 hour – debugging and generating code and checking and stomping around the office.