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

Recordset exception. What am I doing wrong?

This is a discussion on Recordset exception. What am I doing wrong? within the MapPoint Desktop Discussion forums, part of the Map Forums category; Here is some test code in my program that I used to hunt down an exception. MapPoint.DataSet assignedMembers = oMap.DataSets.AddPushpinSet( ...

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

    Recordset exception. What am I doing wrong?

    Here is some test code in my program that I used to hunt down an exception.

    MapPoint.DataSet assignedMembers = oMap.DataSets.AddPushpinSet(
    "Membership2" );
    // Add 0 or more pushpins to the dataset
    MapPoint.Recordset rs;
    for ( int i = 0; i < 500 ; i++)
    {
    rs = assignedMembers.QueryAllRecords();
    }

    Regardless of how many pushpins are added to the dataset, there will always
    be an unknown COM exception thrown when i = 201.

    Is there something that needs to be done to dispose, reset, delete, release,
    or reset the Recordset?

    Help me Obe Wan Kenobe. You are my last hope.

    --
    Regards.
    Mark K Vallevand
    mark.vallevand@unisys.com

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Someone made this suggestion:

    I think you either need to call ReleaseDispatch() between invocations of
    QueryAllRecords() or create a "new" Recordset each time and delete when you're done.

    I don't grok this. ReleaseDispatch() is on what object? I don't see it anywhere.

    What do you mean by "new" and "delete" Recordset? QueryAllRecords() returns a Recordset. I assume that C# manages this object like others. I don't need to explicitly delete it.

    I'm missing something obvious or fundamental.

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    OK. This guy was talking C++. This is C#.

    Has anyone ever called any of the query methods and gotten more than 200 recordsets?

    I think there is a bug here.

    Regards.
    Mark K Vallevand
    mark.vallevand@unisys.com

  4. #4
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    OK. I found it. If you force garbage collection, the recordset objects get released and the COM interface is happy.

    Added this code:
    System.GC.Collect();

    System.GC.WaitForPendingFinalizers();

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unknown Host Exception
    By amitsh in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 12-19-2008, 01:39 AM
  2. OutOfMemory Exception
    By Gianmaria in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-24-2006, 01:26 PM
  3. Regarding COM exception at the end of execution...
    By Anonymous in forum MP2K Magazine Articles
    Replies: 0
    Last Post: 05-12-2005, 01:23 PM
  4. What am i doing wrong???
    By alt-088 in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 09-16-2004, 04:37 PM
  5. Deriving a recordset from a mappoint recordset
    By RichardHayes in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-06-2002, 03:44 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 84 85 86 87 88 89 90 91 92 93 94 95 96