Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert json to cursor
Message
From
31/10/2019 09:10:43
 
 
To
31/10/2019 08:22:55
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
01671750
Message ID:
01671755
Views:
57
Hi!

>I use nfJson for one of my pet projects, and it would return an object containing a .data array property of objects, which can then be used for insert... name into a cursor. Rather straightforward.

I tried
SET TEXTMERGE ON
SET TEXTMERGE TO skeem.txt
TEXT TEXTMERGE noshow
- id v(20) $.id  
- vat_sum N(12,2) $.vat_sum  
- company_id v(20) $.company_id  
- person_id v(20) $.person_id  
- project_id v(20) $.project_id 
- deadline D  $.deadline  
- status v(20) $.status  
- description v(20) $.description 
- currency v(20) $. currency  
- SUM n(12,2) $.SUM 
- date D  $.date  
ENDTEXT
SET TEXTMERGE to
		
nfOpenJson( FILETOSTR('myjson.json') )
LOCATE 
nfOpenJson( value, '$.array', strt( FILETOSTR('skeem.txt'), CHR(13)+CHR(10),' ') )
BROWSE 
But date column is empty. How to parse date column values ?
Andrus
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform