Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 2 of 2

sequence of imported data changes

This is a discussion on sequence of imported data changes within the MapPoint Desktop Discussion forums, part of the Map Forums category; I am importing lat/lon data from a comma separted file into a VB app using the MapPoint ActiveX control. I ...

  1. #1
    Harv's Avatar
    Harv is offline Junior Member White Belt
    Join Date
    May 2003
    Posts
    3

    sequence of imported data changes

    I am importing lat/lon data from a comma separted file into a VB app using
    the MapPoint ActiveX control. I need to iterate through all the imported
    data points (... may be several hundred) in the order that they are in the
    source file. However using the ImportData function to import the data into a
    dataset then iterating through the recordset does not retain the original
    sequence of data points in the source file.

    Any idea what causes this, or ways to get around it are appreciated. The
    LinkData function behaves the same, even using a sequnce number field as the
    primary key.

    A code snippet follows (the code simply puts the sequence number of the
    record in the source file, which is one of the fields, into a listbox called
    List1). Although the following code uses the ShowImportWizard, I have tried
    various different versions using ImportData and LinkData functions with the
    same result.

    Dim objDS As MapPointCtl.DataSet
    Dim objRS As MapPointCtl.Recordset

    With MPControl.ActiveMap.DataSets
    Set objDS = .ShowImportWizard
    End With

    Set objRS = objDS.QueryAllRecords
    objRS.MoveFirst
    List1.Clear

    Do
    List1.AddItem objRS.Fields(1).Value
    objRS.MoveNext
    Loop Until objRS.EOF

    -- Harv Hundal

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    I don't know if there is a way around it except to change your program's logic so you don't have to iterate through in the same order..
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Imported data 132 addresses not matched
    By stevewilson in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 05-05-2010, 12:00 PM
  2. Editing Imported Data
    By Rpirong in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-08-2006, 04:07 PM
  3. editing push pin and imported data
    By ToddF in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 04-26-2004, 11:47 AM
  4. creating territories using imported data
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 11-04-2003, 04:45 PM
  5. When I imported data at the county level for MA as....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-20-2001, 09:18 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83