BOOLEAN FIELDS TRANSLATED TO '1' or '0' insteat of .t. or .f. in PG 16
Posted: Sat Feb 01, 2025 2:18 am
Hi all,
In SQLExpress, I uploaded a table from ADS/adt to Postgresql 16 using ODBC. Everything looks fine in pgAdmin 4. But when i make a cursor using SQLDataset():New()
and retrieve a boolean field in my test application, like oCursor:fieldget("myBooleanFld"), I get string "1" for TRUE and string "0" for FALSE instead of .t. or .f.
I appreciate your help
Thanks
Joe
In SQLExpress, I uploaded a table from ADS/adt to Postgresql 16 using ODBC. Everything looks fine in pgAdmin 4. But when i make a cursor using SQLDataset():New()
and retrieve a boolean field in my test application, like oCursor:fieldget("myBooleanFld"), I get string "1" for TRUE and string "0" for FALSE instead of .t. or .f.
I appreciate your help
Thanks
Joe