record set boolean

  1. 6 years ago

    Joel_Eisenstat

    25 Jun 2017 User since 2016

    Good morning ,
    In retrieving a boolean value from a record set it always defaults to 0 . The Creo query as well as Postgres clients show t.
    Console.write(rs.active); --> 0 .
    Thanks ,
    Joel

  2. marco

    26 Jun 2017 Administrator User since 2016

    @Joel_Eisenstat can you please paste here the CREATE TABLE statement?
    How the active field is defined?

    Thanks.

  3. Joel_Eisenstat

    26 Jun 2017 User since 2016

    I use SEQUEL for Postrgres to create tables/columns, in this case a boolean , For Creo there are 2 controls associated with boolean columns t/f, a toggle for active ( 0/false for non active, 1/true for active) and a 2 segment segmented control where 0 segment is for Male, 1 for female. When the records set is displayed from the Postgres1.Query1 the column row in question displays as 't', but somethings off when using select(sql) . All others column types do not seem to have an issue .
    Joel
    There is a delay as I switched providers ( have optic to the house now ) messed my IP with AWS so it will take a day or so to figure that out .

  4. marco

    10 Jul 2017 Administrator User since 2016

    Hi @Joel_Eisenstat we just improved PostgreSQL boolean conversion in the next upcoming beta version.
    Please let us know if it will fix your issues.
    Thanks.

  5. Joel_Eisenstat

    10 Jul 2017 User since 2016

    Thanks again ...

or Sign Up to reply!