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

Resolved Saving Large Text Fields

  1. How-to
0
Votes
Undo
  1. Kevin Thai
    Kevin Thai
  2. PowerBuilder
  3. Friday, 7 July 2023 15:39 PM UTC

Hi all,

 

I am using PowerBuilder 2022 Build 1892.

 

We have a Microsoft Sql text field that should hold up to 32766 characters. When using that text field in a datawindow column, only 8192 characters are saved. We have no limit on how many characters we can enter. So in this case we have a user trying to save around 9000 characters and it gets cut off after 8192. Is there a way to increase the limit of characters save or is there a work around for this process?

 

Thanks you all!

Consume WebService SOAP pb 2022
PowerBuilder IDE 2022 on Windows 11 ARM
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 7 July 2023 17:32 PM UTC
  2. PowerBuilder
  3. # 1

Hi Kevin;

   Assuming that your SS column is defined as a VarChar(Max) column data type, then you need to set the following DB connection parameters (for example) to connect to your DBMS...

SQLCA.DBParm = "PBMaxTextSize=1024000,PBMaxBlobSize=1024000"

   (Just adjust the values to meet your needs)

  Also note that if your using a newer SS version you should not be using OLEDB but instead the newer SS DB driver "MSOLEDBSQL,

     For example:  SQLCA.DBMS = "MSO"

HTH

Regards .. Chris

Comment
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Friday, 7 July 2023 15:50 PM UTC
  2. PowerBuilder
  3. # 2

What database interface (SQLCA.DBMS=???) is your application using?

Comment
Kevin Thai
  1. Kevin Thai
  2. Friday, 7 July 2023 15:53 PM UTC
OLE DB
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.