QueryAllRecords Fails

Anonymous
08-29-2002, 10:00 PM
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

jtere856
11-25-2002, 05:09 PM
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

 
Web mp2kmag.com
mapforums.com