Add County Information to Simplified Lists

`ON ERROR com_message=message()` `SET SAFETY OFF` `ALTER TABLE (alias()) ADD COLUMN countynm_ C(30)` `ALTER TABLE (alias()) ADD COLUMN countyno_ C(3)` `USE (ADDBS(xDefFldr)+"DMM\_uszips.dbf") IN 0 ALIAS _uszips ORDER USZIP` `REPLACE countynm_ WITH _uszips.countynm FOR SEEK(LEFT(zip,5),"_uszips")` `REPLACE countyno_ WITH _uszips.countyno FOR SEEK(LEFT(zip,5),"_uszips")` `USE IN (SELECT("_uszips"))`

ON ERROR com_message=message()

SET SAFETY OFF

ALTER TABLE (alias()) ADD COLUMN countynm_ C(30)

ALTER TABLE (alias()) ADD COLUMN countyno_ C(3)

USE (ADDBS(xDefFldr)+"DMM\_uszips.dbf") IN 0 ALIAS _uszips ORDER USZIP

REPLACE countynm_ WITH _uszips.countynm FOR SEEK(LEFT(zip,5),"_uszips")

REPLACE countyno_ WITH _uszips.countyno FOR SEEK(LEFT(zip,5),"_uszips")

USE IN (SELECT("_uszips"))

« Back to Commands

New to the
Mailing
Industry?
More Info

Professional Services
More Info

We love the database and how simple it is for us to make simple codes as our business always has since 1955...We are grateful to you and your staff that take client service so seriously.

K.W., Hobe Sound, FL