Water Off formula

To localize the Water Off formula you must modify the select statement that gets address data from the database. The default code is shown below, along with modified code for different regional settings.

Default formula (US)

sqlStr = "select CUSTPROB.SERVNO as ""SRNumber"",
CUSTPROB.SERVNO as ""colViewer"",
'1' as ""gcWorkOrderKey"",
ADDRESS.STNO + ' ' + ADDRESS.STNAME + ' ' + STATE + ' ' + ZIP as ""Address"",

Canada

sqlStr = "select CUSTPROB.SERVNO as ""SRNumber"",
CUSTPROB.SERVNO as ""colViewer"",
'1' as ""gcWorkOrderKey"",
ADDRESS.CASTNO + ' ' + ADDRESS.CASTNAME + ' ' + CAPROVINCE + ' ' + CAPOSTCODE as ""Address"",

UK

sqlStr = "select CUSTPROB.SERVNO as ""SRNumber"",
CUSTPROB.SERVNO as ""colViewer"",
'1' as ""gcWorkOrderKey"",
ADDRESS.GBHOUSENO + ' ' + ADDRESS.GBSTNAME + ' ' + GBCOUNTY + ' ' + GBPOSTCODE as ""Address"",

Australia

sqlStr = "select CUSTPROB.SERVNO as ""SRNumber"",
CUSTPROB.SERVNO as ""colViewer"",
'1' as ""gcWorkOrderKey"",
ADDRESS.AUHOUSENO + ' ' + ADDRESS.AUSTNAME + ' ' + AUSTATE + ' ' + AUPOSTCODE as ""Address"",

New Zealand

sqlStr = "select CUSTPROB.SERVNO as ""SRNumber"",
CUSTPROB.SERVNO as ""colViewer"",
'1' as ""gcWorkOrderKey"",
ADDRESS.NZHOUSENO + ' ' + ADDRESS.NZSTNAME + ' ' + NZSTATE + ' ' + NZPOSTCODE as ""Address"",