Home » U++ Library support » U++ SQL » PostgreSql does not handle BOOL correctly
| Re: PostgreSql does not handle BOOL correctly [message #60062 is a reply to message #60061] |
Thu, 27 July 2023 16:15   |
omari
Messages: 276
Registered: March 2010
|
Experienced Member |
|
|
Running this statement :
select TESTPARTNER_ID, TESTPARTNER_NAME, TESTPARTNER_ADDRESS, IS_OK from TESTPARTNER where IS_OK = 1 order by TESTPARTNER_NAME
in postgresql Sql console, print the same error message.
the correct statement is:
select TESTPARTNER_ID, TESTPARTNER_NAME, TESTPARTNER_ADDRESS, IS_OK from TESTPARTNER where IS_OK = '1' order by TESTPARTNER_NAME
where IS_OK = '1'
instead of
where IS_OK = 1
regards
omari.
|
|
|
|
Current Time: Wed Jun 04 00:42:34 CEST 2025
Total time taken to generate the page: 0.23825 seconds
|
Members
Pages
Help
Register
Login
Home
