JSONB and JSON field types with Postgres SQL [SOLVED]
lazarus / 16-Databases

----------------------------------------------------------------------
stoffman · 2020-11-21 17:36

I'm using TSQLQuery to access Postgres database. And the table I'm
querying has a JSONB type field in it.

If I query for the a standard field and the JSONB field. it just being
ignored and not presented in the dataset.

If I query only for the JSONB field a get an exception: EDatabase -
Missing (compatible) underlying dataset

Anyone has an experience with it ? how it can be solved? (I cannot
cast the field to string in the query)

Thanks

----------------------------------------------------------------------
stoffman · 2020-11-22 20:26

It seems that TSQLQuery cannot handle JSON and JSONB field types.

the Zeos components can
(https://wiki.lazarus.freepascal.org/Zeos_tutorial)