Forum > Databases

Error in query (sqldb) view with return in json (mysql8)

(1/2) > >>

andersonscinfo:
Hello everyone, I have a somewhat strange situation, I have a mysql8 database (which is on a hosting) I have several tables, and they all work very well, I can connect, change, remove, etc., today I needed to create a view in the database and this view returns a json, for some reason sqldb does not allow searching this view, returning the following error attached

Note: sorry for my English (google translate)

af0815:
SQLdb need a "normal" formed dataset returned from server. Jason or XML can only returned if the are packed in a normal column as string or text or blob.

Thaddy:
TJSONDataset?
https://wiki.freepascal.org/fpjsondataset
That works with sqldb.

af0815:
Thaddy, the query on the server produce this JSON instead of a normal resultset. The JSON dataset can IMHO not send this query to the server and work with the result. Your sample use local JSON.

Thaddy:
OP does not state manipulating the data, just displaying it. For that it can be just the JSON dataset.

Navigation

[0] Message Index

[#] Next page