• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • datawindow column size error when sql selects retrieve arguments

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

Resolved datawindow column size error when sql selects retrieve arguments

  1. Issue
0
Votes
Undo
  1. SUNG HA
    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)
argument vs. colum specifications error.jpg argument vs. colum specifications error.jpg
Target Properties - Library List not working
alguine tiene el codigo de PowerBuilder SOAP Web S...
Responses (2)
Chris Pollach @Appeon
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
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
David Peace (Powersoft)
  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.