Class SY_ZIPCode_svc

Inherits

SY_Service

Properties

LOCAL cMainTable$="SY_ZIPCode"  
LOCAL cIsSysDB=isTRUE  
LOCAL cCanPostValidChars$="ABCEGHJKLMNPRSTVWXYZ"  

string of alphabetic characters used in Canadian Postal Codes, D,F,I,O,Q or U are not used.

PROPERTY CheckForPurchaseControl  
PROPERTY SkipTaxScheduleInAdditionalValidation  
[boolean] when True, skip tax schedule logic in additional validation
PROPERTY TaxScheduleList$  
PROPERTY UsedFirstSalesTaxSchedule   * Read Only *
PROPERTY IgnoreError   * Read Only *

Methods

FUNCTION GetCountryCode(tmpZipCode$, tmpCountryCode$)  

Get Country Code for a ZIP/Postal Code

ParameterDescription
tmpZipCode$ [input, string] ZIP/Postal Code to get the Country Code for
tmpCountryCode$ [output, string] Country Code for the ZIP/Postal Code if a record is on-file
Returns [boolean] SUCCESS if the ZIP/Postal Code exists in one record, FAILURE if it doesn't exist or has multiple records
FUNCTION GetZipCodeKey$(value$)  

Get Zip Code Key, either the stripped Canadian Postal Code value (CAN) or the 5-digit US value (USA)

Returns [string] if value is a valid Canadian Postal Code returns formatted key value else returns first five characters of original value

Properties inherited from: SY_Service

BOF, CurrentBrowseIndex$, CurrentIndex$, EOF, SecurityAccess

Methods inherited from: SY_Service

BindVariable(), CheckMainTable(), Clear(), Find(), FindById(), GetChildHandle(), GetChildKeyReference$(), GetColumns$(), GetDataSources$(), GetDataSourcesAddl$(), GetJson$(), GetKey$(), GetKeyColumns$(), GetKeyPadded$(), GetPartialRecord(), GetRecord(), GetRecordCount(), GetRecordEx(), GetResultSets(), GetTable$(), GetTablePath$(), GetValue(), GetValues(), IsValid(), MoveFirst(), MoveLast(), MoveNext(), MovePrevious(), ReadAdditional(), SetBrowseFilter(), SetBrowseIndex(), SetCacheMode(), SetIndex(), SetKeyValue(), SetParentColumns(), SetParentHandle(), SetUIHandle(), PERFORM ClearEditRcd(), FormatJson$(), GetAddlDataSources(), GetDateColumns$(), InitChildCollection(), MoveFirstLast(), MoveNextPrevious(), OpenMainTable(), ParseKeyDef(), PrepareKeyDef(), ReadRec(), ResolveColumnList$(), SetControls(), SetCurrentKey(), UseKeyColl()