|
-
Oct 19th, 2023, 11:16 AM
#29
Re: [VB6/VBA] JSON parsing to built-in VBA.Collections with JSON Path support
 Originally Posted by xiaoyao
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.
 Originally Posted by xiaoyao
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>
Last edited by wqweto; Oct 19th, 2023 at 11:19 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|