Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Convert json to cursor
Message
De
31/10/2019 09:10:43
 
 
À
31/10/2019 08:22:55
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Divers
Thread ID:
01671750
Message ID:
01671755
Vues:
58
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform