1. SUNG HA
  2. PowerBuilder
  3. Wednesday, 05 June 2019

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)
Olan Knight Accepted Answer Pending Moderation
1
Votes
Undo

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
Yes, see this before with sql computed columns or retrieval arguments, just edit source to fix.
There are no comments made yet.
  1. Friday, 7 June 2019
  2. PowerBuilder
  3. # 1
Chris Pollach Accepted Answer Pending Moderation
-1
Votes
Undo

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.
  1. Thursday, 6 June 2019
  2. PowerBuilder
  3. # 2
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.