Page 1 of 1

Errno_ Description command

Posted: Tue Aug 05, 2014 7:55 am
by Eric
This command will create a field named errno_desc and it will fill in this field with errno_ descriptions for all of the undeliverable addresses in the list.

Code: Select all

ON ERROR com_Mesg=MESSAGE()
SET SAFETY OFF
ALTER TABLE ALIAS() ADD COLUMN errno_desc C(30)
Replace all errno_desc with "State Not Found" FOR "1.1" $ LEFT(errno_,3)
Replace all errno_desc with "City not found " FOR "2.1" $ LEFT(errno_,3)
Replace all errno_desc with "Street not found " FOR "3.1" $ LEFT(errno_,3)
Replace all errno_desc with "Address not found" FOR "4.1" $ LEFT(errno_,3)
Replace all errno_desc with "+4 unavailable" FOR "5.1" $ LEFT(errno_,3)
Replace all errno_desc with "Multiple streets match" FOR "6.1" $ LEFT(errno_,3)
Replace all errno_desc with "Multiple addresses match" FOR "6.2" $ LEFT(errno_,3)
Replace all errno_desc with "Cardinal Rule multiple match" FOR "6.3" $ LEFT(errno_,3)
Replace all errno_desc with "Address not found in DPV Database" FOR "N N" $ LEFT(dpv_,3)