Login
`
Templates, Tools and Utilities
|
||
Icetips Article
Back to article list
Search Articles
Add Comment
Printer friendly
Direct link
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)
Today is November 21, 2024, 3:40 am This article has been viewed 35233 times.
|
|