Add BMC field and data to your database

Information relating to the presorting process in AccuZIP6, which may include rate change information and news about important updates as well as regulation changes or DMM Rules interpretation.

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Eric
Moderator
Posts: 1909
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Add BMC field and data to your database

Post by Eric » Wed Jul 22, 2009 10:03 am

If you want to add a BMC field to your database and populate it with the 3 digit BMC ZIP based on your 5 digit ZIP Code, then open your database, pull down the Edit menu to Command, and run this command:

Code: Select all

* Suppress Messages 
ON ERROR com_Mesg=MESSAGE() 

* Add BMC column
ALTER TABLE (ALIAS()) ADD COLUMN bmc C(3) 

* Add BMC number 
REPLACE ALL bmc WITH substr(GetLineValue(ADDBS(xDefFldr)+"iPresort\DMM\AZL601.txt",INT(VAL(LEFT(zip,3))),67,.T.,.T.),9,3)
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply