ACL Scripts

Below are a few pre-written scripts I find useful. More will be posted as time goes on.

PARSING TIME:     This script parses time fields from a character format of HH:MM:SS to separate numeric fields.     Time_Parser.BAT

TABLE VERIFICATION:     I use this script in almost every project as it performs a verify, row count and checksum on the selected table.     Table_Verification.BAT

IMPORT TEMPLATE:     This is the beginning of a script with a standard dialog box I use when setting up table imports. It allows the user to choose the table and includes some simple instructions.     Import_Template.BAT

CROSSTAB AGING:     This script ages by calculating the number of days outstanding and applies a set of aging periods while subtotaling the amount. The data is subsequently cross tabulated by customer number.     Crosstab_Aging.BAT

FEEDING A DROP DOWN LIST FROM A TABLE:     This script feeds a drop down list from a table by classifying the possible values and populating the drop down list with them. The script is heavily commented and accented with white space to ease modification for your use. There is also a sample table so you can witness functionality (hence, the zip file).     DropDown_Feed_Example.zip