Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Datawindow converting a boolean to varchar(5) - Postgresql DB backend

  1. How-to
0
Votes
Undo
  1. Richard Murray
    Richard Murray
  2. PowerBuilder
  3. Monday, 14 June 2021 19:54 PM UTC

I have a datawindow against a Postgresql DB. When selecting a boolean column from the database and trying to update it, the datawindow converts the column to a varchar(5), which I assume is for 'FALSE', is there a setting in the PBODB.INI to convert this correctly? Or how do I fix it?

The fix turned out to be, was to set the column as varchar and then the driver converts it to the table's definition, of boolean.

NSSM - PB as service - Log files and Err files bei...
Need some help with syntax
Responses (1)
Georgios Papageorgiou
Georgios Papageorgiou Accepted Answer Pending Moderation
  1. Saturday, 21 September 2024 09:32 AM UTC
  2. PowerBuilder
  3. # 1

Hi PowerSphere ( and especially Appeon :) )

 

Any news on this ?  (was it fixed )

 

@Richard

You wrote:

"The fix turned out to be, was to set the column as varchar and then the driver converts it to the table's definition, of boolean."

But where did you "set the column as varchar" ?

 

Regards

Georgios

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.