Par2: Address Validaton 2007-09-25 -- Brett Carnaby This might give you a bit of a start.
Addrs_tmp FILE,DRIVER('BASIC','/ENDOFRECORD=1,10 /FILEBUFFERS=1
/QUICKSCAN=ON'),NAME(GLO:TempFile),CREATE,RECLAIM,PRE(DLF)
RECORD RECORD
Latitude STRING(32)
Longitude STRING(32)
Description STRING(256)
Original STRING(256)
Score STRING(32)
StreetNumber STRING(32)
Prefix STRING(10)
StreetName STRING(128)
StreetType STRING(20)
Suffix STRING(20)
City STRING(32)
State STRING(32)
ZipCode STRING(32)
END
END
DLAddrFile = GETTEMPFILENAME('')
AddrData = 'http://www.ontok.com/geocoder?key=key&fmt=CSV&q='
AddrData = Clip(AddrData) & Clip(PRP:Address)
AddrData = Clip(AddrData) & ' ' & CLIP(PRP:Address2)
IF CLIP(PRP:City) = ''
AddrData = Clip(AddrData) & ' ' & 'Indianapolis'
Else
AddrData = Clip(AddrData) & ' ' & CLIP(PRP:City)
End
IF CLIP(PRP:State) = ''
AddrData = Clip(AddrData) & ' ' & 'Indiana'
Else
AddrData = Clip(AddrData) & ' ' & CLIP(PRP:State)
END
AddrData = Clip(AddrData) & ' ' & CLIP(PRP:Zip)
x# = InetDownLoad(AddrData,DLAddrFile)
z# = UpdatePropertyAddressValidator()
Remove(DLAddrFile)
Printed November 23, 2024, 2:08 am This article has been viewed/printed 35237 times. |