Recent

Author Topic: JSONB and JSON field types with Postgres SQL [SOLVED]  (Read 129 times)

stoffman

  • New Member
  • *
  • Posts: 24
JSONB and JSON field types with Postgres SQL [SOLVED]
« 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

« Last Edit: November 22, 2020, 09:27:21 pm by stoffman »

stoffman

  • New Member
  • *
  • Posts: 24
Re: JSONB and JSON field types with Postgres SQL
« Reply #1 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