1. SUNG HA
  2. PowerBuilder
  3. Wednesday, 5 June 2019 15:25 PM UTC

datawindow column size changes from column size-char(30) to argument size-char(1), when sql selects retrieve arguments.  When sql selects retrieve arguments, datawindow column size changes from column size-char(30) to argument size-char(1) for string and string array.

Attachments (1)
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 6 June 2019 17:50 PM UTC
  2. PowerBuilder
  3. # 1

Hi Sung;

  I tried building a few DWO's with my PB2017R3 and Oracle 18C with no column size issues vs the DB Schema.

Unfortunately, I do not have O12C to test with. I am connecting to O18C using the Oracle native driver (SQLCA.DBMS = "ORA") on  W10 test PC's.

Regards ... Chris

Comment
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Friday, 7 June 2019 22:57 PM UTC
  2. PowerBuilder
  3. # 2

THis is a known issue.
I'm not sure what causes this, but I have found it an excellent thing to check the left column of the COLUMNS tab in the DW Painter after you have made a change to an existing DW.

A really fast way to check everything easily isto do an EDIT SOURCE, and you can then both check and correct, if required, the columns.


Olan

Comment
  1. David Peace (Powersoft)
  2. Wednesday, 12 June 2019 15:27 PM UTC
Yes, see this before with sql computed columns or retrieval arguments, just edit source to fix.
  1. Helpful
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.