MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Completely Frustrated With RecordSets

This is a discussion on Completely Frustrated With RecordSets within the MapPoint 2006/2009 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 ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-02-2006
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!!!!!!!!!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 02-02-2006
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?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 02-04-2006
Senior Member
Black Belt
 
Join Date: Nov 2004
Posts: 2,017
Hi,

The result set suport the foreach statement. I think this is also supported in VB. Not sure.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Frustrated - Script timed out Active Server Page webdbx MapPoint 2006/2009 Discussion 1 12-13-2004 02:48 AM
joining recordsets with arrows (II) Anonymous MapPoint 2006/2009 Discussion 0 10-28-2003 06:37 AM
joining recordsets with arrows Anonymous MapPoint 2006/2009 Discussion 1 10-22-2003 07:54 AM


All times are GMT -5. The time now is 04:44 AM.


Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC5
MP2K Magazine
Visitor Map

Ski Deals
Book first-rate ski holidays from the leading travel brands at exceptionally competitive prices. Check out the latest range of ski deal online at Holiday Hypermarket.

Portugal Holidays
Find and book Portugal Holidays with Travel Counsellors. Holiday destinations around the world including Portugal.

Holiday Cuba
Most of all though, you will remember your Holiday in Cuba for the people. Naturally open and friendly with the warmest welcome in the Caribbean. Book at dealchecker.co.uk today.

All Inclusive Maldives
Visit The Holiday Place.co.uk for great deals on all inclusive holidays to the Maldives. Book a holiday to the outstandingly beautiful Maldives.

Balearics
Before booking to the Balearics Islands make sure you check out our travel guide online. The Balearics are renowned for their vibrant nightlife but there are also some stunning Gothic cathedrals, Stone Age ruins and fishing villages.

Inclusive late deals
For inclusive late deals, check out your options at Travel.co.uk and have fun!

Holidays to Cyprus
Take the plunge into a world of summer splendour! Find information on holidays to Cyprus online, only at On The Beach.


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