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.