Varacom  

 
Home   Services   Downloads   Careers   Contact Us                                    
 


Downloads Index
  Overview
  Prowhich
  Control Rec Maint


Downloads, Tricks & Tips

Overview

Here you can find some utilities, tricks and tips that may be of some use to you if you use Progress or MFG/PRO.

The utilities are either open-source or demo/evaluation versions of Varacom software and are subject to the enclose license agreement.

Prowhich (Unix which type command for Progress)

Many Unix developers have become accustomed to using the which commmand that searches the PATH environement variable for a file or command.

Prowhich is a simple unix shell script that searches the PROPATH for a given filename.

eg.
$ echo $PROPATH
.:/usr1/dev/src:/usr1/test/src:/usr1/live/src:/usr/dlc
$ pwd
/home/smp
$ prowhich custmaint.p
/usr1/test/src/custmaint.p
$ vi `prowhich custmaint.p`

You can download prowhich by clicking here.

TIP: if you're vi'ing a file, and you come to an include file that you want to drill down into, but you're not sure where it is in your PROPATH, then simply type:-

:!vi `prowhich include.i`

and you will execute a sub-shell that will vi the correct version of the file include.i that has automatically be located in your PROPATH. When you exit this sub-shell, you return to the original file that you were vi'ing.

MFG/PRO Control Record Maintenance

This is an open-source utility that you can use to maintain arbitary control record information for an MFG/PRO database.

This is simple maintenance procedre for the usrw_wkfl table. The Key 1 (ie, usrw_key1) field is automatically set to the value SZCTRLMT and then the user can create, delete and update records by entering a value for Key 2 (ie, usrw_key2) to make the record unique.

Then you can find the usrw_wkfl record in your custom MFG/PRO code using the key 1 and key 2 values and reference and of the available fields. The Descripiton field is usually used to describe the purpose of the control record, and possibly with field should be updated (eg. "Enter the log directory value in Chr[1]".)

It should work with nearly any version of MFG/PRO that runs in a ChUI environment, and if you want to, you should be able to use the QAD GUI-converter program to make it work in a GUI environment.

Here is a screen shot of this utility in action:-

 

Screen shot of szctrlmt.p


You can download the current version of this utility (szctrlmt.p) by clicking here.

Back to top