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

Completely Frustrated With RecordSets

This is a discussion on Completely Frustrated With RecordSets within the MapPoint Desktop Discussion forums, part of the Map Forums category; Does the Mappoint RecordSet object come up short, or is it just me? Here's my issue. I provide a user ...

  1. #1
    EdB
    EdB is offline Member Green Belt
    Join Date
    Aug 2002
    Posts
    56

    Completely Frustrated With RecordSets

    Does the Mappoint RecordSet object come up short, or is it just me?

    Here's my issue. I provide a user with the opportunity to enter an address for me to find. If the results are not found exactly, I pop up the ShowFindDialog. So, they identify their item and Mappoint places a pushpin on the map. It names it based on the item that they selected from the dialog. Now, I need to find out the name of that pushpin.....keeping in mind that there may be other pushpins on the map already, and I do know their names.

    I can see the RecordCount of the DataSet in question, but I can not see an Item property on the RecordSet object to cycle through the names of the pushpins on the map and see if the name matches a known name.

    I looked to the Fields property and although I have items in the recordset/dataset, fields reports 0.

    HELP!!!!!!!!!

  2. #2
    EdB
    EdB is offline Member Green Belt
    Join Date
    Aug 2002
    Posts
    56
    OK, so I figured this out......but the recordset object IS wanting.

    Unless I am totally missing something....

    if I do this:

    objRecordSet = app.ActiveMap.DataSets(1).QueryAllRecords

    I need to cycle through the RecordSet using MoveFirst and MoveNext to get the number of records in the recordset.......how about a count property? Is that too much to ask?

  3. #3
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    Hi,

    The result set suport the foreach statement. I think this is also supported in VB. Not sure.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Frustrated - Script timed out Active Server Page
    By webdbx in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 12-13-2004, 03:48 AM
  2. joining recordsets with arrows (II)
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-28-2003, 07:37 AM
  3. joining recordsets with arrows
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 10-22-2003, 08:54 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