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

QueryAllRecords Fails

This is a discussion on QueryAllRecords Fails within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have the following set of data in a tab-separated TXT file: 46038 North Zone 46032 North Zone 46027 North ...

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

    QueryAllRecords Fails

    I have the following set of data in a tab-separated TXT file:

    46038 North Zone
    46032 North Zone
    46027 North Zone
    46013 South Zone
    46018 South Zone
    46019 South Zone
    46020 South Zone

    I import this data successfully into Mappoint using ImportTerritories method. Immediately after importing the data, I do a query on the Mappoint control using QueryAllRecords method. The method returns 7 records and I am able to access each record successfully.

    After this I add a zipcode to territory North Zone using TERRITORY MANAGER. Immediately after this I again query the dataset. Now, the recordset returned is EMPTY! (EOF and BOF are TRUE); RecordCount = 7 (NOT 8!) and I am not able to access the individual records.

    If I close the TERRITORY MANAGER and requery, the dataset is still EMPTY! (EOF and BOF are TRUE); But now RECORDCOUNT=8!!! But I am still not able to access the individual records.

    Why does this happen? How can I access the Dataset again to get 8 records? Is this a bug?

    Thanks and regards

  2. #2
    jtere856 is offline Junior Member White Belt
    Join Date
    Nov 2002
    Posts
    2

    I am having the same troubles

    I have created an addin with MapPoint 2002 which grabs the dataset on the active map and updates our SQL database.
    If I first import the data and the save the dataset to our database everything runs smoothly, however if I change territories while in MapPoint and then try to update nothing happens.

    After changes the dataset contains approx. 3000 records when I do a recordcount. After setting the recordset to the dataset.QueryAllRecords I find that there aren't any records in the recordset. How could there be 3000 records in the data set and zero in the recordset? Here is code on how I set things up.

    Dim rsMapPoint as MapPoint.Recordset
    Dim mpDataSet as MapPoint.DataSet
    Dim objApp as MapPoint.Application
    Dim mpMap as MapPoint.Map
    Dim iRecordCount as Integer

    Set mpMap = objApp.ActiveMap
    Set mpDataSet = mpMap.DataSets(1)
    iRecordCount = mpDataSet.RecordCount 'iRecordCount contains 3034

    Set rsMapPoint = mpDataSet.QueryAllRecords

    After this code I find that rsMapPoint contains zero records after doing a BOF/EOF test.

    Does anyone know why this happens?
    Like I said above if I import data and then run this same code without making any changes in MapPoint the rsMapPoint recordset contains the same number of records as the mpDataSet dataset. Only after making manual changes do I have problems.
    Thanks for any input,
    Jon

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. OLE error 80040E04 when using QueryAllRecords or QueryCircle
    By stephenmillington in forum MapPoint Desktop Discussion
    Replies: 6
    Last Post: 12-08-2005, 07:04 AM
  2. Find fails with full install but not partial
    By Tony Kobine in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 08-19-2005, 03:50 AM
  3. Link Data Wizard fails
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-24-2004, 08:03 PM
  4. QueryAllRecords Fails
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 08-29-2002, 05:08 PM
  5. --VB DEVELOPER-- The method QueryAllRecords of a d....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 05-27-2002, 07:50 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