1. Sivaprakash BKR
  2. PowerBuilder
  3. Thursday, 2 December 2021 12:31 PM UTC

Hello,

Using PB 2019 R3 build 2703, PostgreSQL 11, Windows 10  [ Both computers ]

We created a datawindow using the following query [ not a real query ]

Select Cast(0 as decimal(17,3)) as billedquantity, Cast(0 as decimal(17,3)) as stockquantity, 
From in_sales_order_detail a

After creating the datawindow, if we view the column specification, we find two different type(s) in two different computers.

IN Compter 1, we see this

IN second computer, we see this

See it's taking decimal(3) in one computer and decimal(6) in another computer.    Whatever changes we make from computer 2, this type get's changed to decimal(6).  The same datawindow, same project, if we open and modify from 1st computer, it's taking as decimal(3).

What will be the issue?  Any idea/suggestion to identify this issue?

Happiness Always
BKR Sivaprakash

 

Accepted Answer
Brad Mettee Accepted Answer Pending Moderation
  1. Thursday, 2 December 2021 15:48 PM UTC
  2. PowerBuilder
  3. # Permalink

Check database driver versions. It sounds like you're using two diff connectors for the database and one is older/different than the other and interpreting the database table info differently.

You should also want to check that the users logging into the database have identical rights.

Comment
  1. Miguel Leeuwe
  2. Friday, 3 December 2021 06:04 AM UTC
Yes, I think v10 might be the only supported driver for now (on 2019): https://docs.appeon.com/pb2019/connecting_to_your_database/ch02s06.html

Nevertheless, if you do a "search" in the 2019 pb help on "postgresql" and then click on "software requirements", then it says that v 10, 11 and 12 are supported. (anyway, no v13 though).

On pb 2021, the V13 should be supported, doing the same search in the pb help.

regards.
  1. Helpful
  1. Sivaprakash BKR
  2. Friday, 3 December 2021 10:50 AM UTC
Thanks Miguel,

The link you provided says

PowerBuilder apps can connect with the PostgreSQL 10 (32-bit and 64-bit) (ANSI and Unicode) database through the PostgreSQL ODBC driver.



It's a bit confusing for me whether it talks about database or driver version...

  1. Helpful
  1. Armeen Mazda @Appeon
  2. Friday, 3 December 2021 16:11 PM UTC
It's talking about database version and assumption is the driver that ships with that database version.
  1. Helpful
There are no comments made yet.
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Saturday, 4 December 2021 04:41 AM UTC
  2. PowerBuilder
  3. # 1

Thanks Armeen,

I think PostgreSQL (https://www.postgresql.org/) windows version installer doesn't come with a ODBC driver. What happens is it installs application stack builder, from which we can install Add-ons, tools, Database Drivers, Database Server et all...

Option(s) available

1.  From this stack builder, we can install ODBC driver. This is one option. Here we usually find the latest ODBC version(s) which is ver 13, as of now.
2.  The other option being is to download psqlodbc driver from https://odbc.postgresql.org/. Here one can find all available ODBC version.  This site claims that it's the official PostgreSQL ODBC driver (See point 1.5 in faq at https://odbc.postgresql.org/faq.html)

These are the two ways to install ODBC driver and I don't think database installation includes any ODBC driver, by default.   

As a new windows installation in one of our machines, we installed the latest (ver 13) of the odbc driver to work along with ver 11 of Postgresql server.  

 

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.