mORMot Open Source

HollosCs

Member

Registered: 2015-12-08

Posts: 56

rest to dataset

Hello!

I have a TSQLRestServerFullMemory.
Create TSQLRestClientURIDll client and get tale data with and get table data with client.List() or client.RetrieveListJSON().
Program is working, BUT how can I convert retrieved data for DataSource.Dataset?

Thx, Csaba

edwinsn

Member

Registered: 2010-07-02

Posts: 1,218

Re: rest to dataset

Please full text search into the mORMot library path for the various forms of the 'ToDataSet' function scattered around several units.

---

Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.

HollosCs

Member

Registered: 2015-12-08

Posts: 56

Re: rest to dataset

The problem is ToDataset(), BinaryToDataSet() convert from rawbytestring or ISQLDBRows, not from List and from json.
I use TSQLRestClient. List(), RetrieveList(), because i have TSQLRestServerFullMemory base server, not http connection or pure sql command.

edwinsn

Member

Registered: 2010-07-02

Posts: 1,218

Re: rest to dataset

Oops...
I myself use ToClientDataSet() to convert from TSQLTableJSON to TClientDataSet.

You can also check TSynSQLTableDataSet and \SQLite3\Samples\ThirdPartyDemos\EMartin\TSynRestDataset\SynRestVCL.pas to see which suites your needs.

---

Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.