View Single Post

  #2 (permalink)  
Old 12-30-2003
jscott099 jscott099 is offline
Junior Member
White Belt
 
Join Date: Oct 2003
Posts: 8
Here is how it should have been coded

Dim JobFieldArray(,) As Object
ReDim JobFieldArray(6, 1)
JobFieldArray(0, 0) = "Job_ID"
JobFieldArray(0, 1) = MapPoint.GeoFieldType.geoFieldName
JobFieldArray(1, 0) = "Address1"
JobFieldArray(1, 1) = MapPoint.GeoFieldType.geoFieldAddress1
JobFieldArray(2, 0) = "Address2"
JobFieldArray(2, 1) = MapPoint.GeoFieldType.geoFieldAddress2
JobFieldArray(3, 0) = "City"
JobFieldArray(3, 1) = MapPoint.GeoFieldType.geoFieldCity
JobFieldArray(4, 0) = "State"
JobFieldArray(4, 1) = MapPoint.GeoFieldType.geoFieldRegion1
JobFieldArray(5, 0) = "ZIP"
JobFieldArray(5, 1) = MapPoint.GeoFieldType.geoFieldPostal1
JobFieldArray(6, 0) = "Country"
JobFieldArray(6, 1) = MapPoint.GeoFieldType.geoFieldCountry

' The next statement performs a Mappoint Import Data from the SQL table
oDataSetJobs = oMap.DataSets.ImportData("C:\JHS Varicom\DA Conversion\RDA_Data_WorkbenchSQL.UDL!Job_Cust_SLA_ Address_View", _
JobFieldArray, MapPoint.GeoCountry.geoCountryUnitedStates, MapPoint.GeoDelimiter.geoDelimiterDefault)
__________________
Jesse Scott
Varicom, Inc.
Service Management Optimization Dispatching Solutions
Reply With Quote