Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread How i can export a query result dataset to json in fast mode ?
Mon, Apr 16 2018 6:41 AMPermanent Link

Mauro Botta

Hi

How i can export a query result dataset to json in fast mode ?

and re-import dataset in EDB dataset.

like TEDBQuery.ExportJson...


For a a local datasnap call.





Berlin
Last EDB
Mon, Apr 16 2018 10:03 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mauro,

<< How i can export a query result dataset to json in fast mode ? >>

You can't really do so directly in EDB at the moment.  I can certainly add this as an option, however.  JSON is particulary well-suited to import/export from EDB, due to the richer types.

Tim Young
Elevate Software
www.elevatesoft.com
Mon, Apr 16 2018 10:11 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Mauro

>How i can export a query result dataset to json in fast mode ?
>
>and re-import dataset in EDB dataset.
>
>like TEDBQuery.ExportJson...
>
>
>For a a local datasnap call.

EWB will handle JSON but I don't think what you want is possible. What you can do is create a VIEW for the query and export that in either csv or xml format.

Alternatively you could write your own JSON handler. I did for my string table implementation and its not difficult or there are third party components available.

Roy
Image