Lazarus

Programming => Databases => Topic started by: stoffman on November 21, 2020, 06:36:14 pm

Title: JSONB and JSON field types with Postgres SQL [SOLVED]
Post by: stoffman on November 21, 2020, 06:36:14 pm
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

Title: Re: JSONB and JSON field types with Postgres SQL
Post by: stoffman on November 22, 2020, 09:26:59 pm
It seems that TSQLQuery cannot handle JSON and JSONB field types.

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

TinyPortal © 2005-2018