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 3 of 3

Querying Data

This is a discussion on Querying Data within the MapPoint Desktop Discussion forums, part of the Map Forums category; I am using the Mappoint control in VB 6 to generate maps from data stored in Access. When mapping is ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    Querying Data

    I am using the Mappoint control in VB 6 to generate maps from data stored in Access. When mapping is completed, I want to be able to drill through from regions on map to the underlying data. So when I hover on a region (say county or zip) Mappoint tells me how many names are aggregated. I want to click through to those names.

    Any ideas on how to do this? I guess I can use QueryAllRecords and loop through the entire recordset, but this will probably be too slow. Seems like there should be an easy way to do this. Am I missing something?

    Thanks in advance for any/all help!

    - Lou

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Hi…if I understand your issue correctly, what I’d do is set up a handler for the selection changed event. In that event, pull a key from the selected object and then retrieve the data from a parallel database. i.e. not from MapPoint. Note, if you go this route, don’t leave a modal dialog hanging in the event handler…if you do, MP will throw an OLE timeout error. In VB 6, an easy way around this is to enable a sleeping timer control in the selection changed handler and then let the timer control pop up the dialog box.

    Another strategy to solve your issue would be to geocode your aggregated data as a pushpin set with fields for each of the data you want to show. In this method, you get all the nice MP balloon etc. The downside is your user has to click on a mysterious pin rather than a nice, labeled region.

    Hope this helps.

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    Querying Data

    Thanks for your help. I have pretty much already resigned myself to going against a parallel db and will do so. Thanks also for the tip regading modal dialogs - learned about this one the hard way...

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Importing new GIS data and querying it.
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-26-2002, 08:29 AM

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