Results 1 to 40 of 40

Thread: [VB6/VBA] JSON parsing to built-in VBA.Collections with JSON Path support

Threaded View

  1. #29

    Thread Starter
    PowerPoster wqweto's Avatar
    Join Date
    May 2011
    Location
    Sofia, Bulgaria
    Posts
    6,167

    Re: [VB6/VBA] JSON parsing to built-in VBA.Collections with JSON Path support

    Quote Originally Posted by xiaoyao View Post
    I think the best way is probably to use Script.dictionary instead of Collection objects, so that the number of code can be minimized, but i can't do this new module, can only imagine.
    There is #Const ImplScripting = False at the beginning of the source code. Setting this to True and adding reference to Microsoft Scripting Runtime forces the module to use Scripting.Dictionary internally.

    This is something I don't recommend as everything becomes slower and Scripting.Dictionary based JSON documents consume orders of magnitute more memory than VBA.Collections based ones.

    Also the newer code is not well tested (at all) with Scripting.Dictionary internal representation.

    Quote Originally Posted by xiaoyao View Post
    Collection also can list all keys? and find key Exists?
    You finally found out about the hot water! :-)) Yes, it's possible both in x86 and x64 impl using their internals (private data).

    cheers,
    </wqw>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width