1. Kevin Thompson
  2. PowerBuilder
  3. Tuesday, 20 July 2021 22:12 PM UTC

I'm trying to display in a datawindow a column that is over 32,767 characters, it's 36,220 characters.  I tried to increase the limit in the edit table to 50,000 and also setting to 0.  Every retrieve on displayed 32,767.    

I check the length of the length of the column and shows the 36,200 characters.  Using PB 2017 R3 build 1915.  I've change PBMaxTextSize='50000' in the PBODB170.INI.  Any suggestion would be great.

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 21 July 2021 00:04 AM UTC
  2. PowerBuilder
  3. # 1

Hi Kevin;

  The DWO's maximum String column size is 32K.  The PBMaxTextSize setting is only for the SelectBLOB command.

  I had an application like yours once and ending up splitting the text into two columns. Then after the two retrieve's using PowerScript to concatenate the two string columns into one. On an Insert or Update, splitting the text if > 32K back into the two DWO columns. Food for thought. HTH

 Regards ... Chris

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.