Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best Json tool for Working with VFP9SP2
Message
From
06/11/2023 02:41:05
 
 
To
03/11/2023 18:21:14
General information
Forum:
Visual FoxPro
Category:
Web Services
Miscellaneous
Thread ID:
01687181
Message ID:
01687193
Views:
46
Thank you, for your time.

I won't process a lot of records, just some records. On the other hand, I need to process those records (receive the jsons recods conmvert it to cursors, do some processes on each record and this processes would give me a result in a cursor and convert this cursor back into json so the web service can return them properly. I should mention that the requirement to use Json comes from a partner to the company which I work for, we need to share some data. So, return "standard" Json should important too. Is nfJson capable of those two important aspects?

TIA


>Hank already pointed you to a solution probably good enough.
>
>>By "best" I mean the easiest, fastest and most standardized tool to interact with VFP 9.
>
>I doubt you will tax vfp with nfJSON while you still have lots of control.
>But as you specifically ask to create a cursor and "fastest", I'd look at creating a byte stream
>from JSON, which is string handling.
>Marshalling once into Dotnet or even calling another process to parse hundreds of MByte
>to either create csv, SDF or a dbf as byte stream will have a fixed call overhead and process
>each JSON record faster, so for large reccount() and large recsize() with many I, D,Y fields
>calling into Dotnet or a C process will be faster - you could also write out the dbf file as stteam.
>
>HTH
>thomas
>
>
>>Hi. I'll begin to develop a small web service in VFP 9. This web service will receive and send Json data. But I need to know what is the best available tool for encoding/decoding Json strings. By "best" I mean the easiest, fastest and most standardized tool to interact with VFP 9. Of course, if it would allow me to create cursor from Json, that would be a big plus.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform