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

Resolved Sybase Server and DBTextLimit in PB 2017 R2

  1. Issue
0
Votes
Undo
  1. Sailaja Jasti
    Sailaja Jasti
  2. PowerBuilder
  3. Thursday, 10 January 2019 01:27 AM UTC

We are connecting to Sybase using SYC driver. I am trying to increase

Though the @@textsize on the database is set to 131072 and SQLCA.DBParm = "DBTextLimit='65536'" in databaseprofile, the text column is still truncating to 32768 when datawindow is created.

But, if size is reduced by changing  SQLCA.DBParm = "DBTextLimit='5000'"  then the datawindow shows the column correctly with 5000 char when it is created.

This is working correctly when I tested it with ODBC driver after adding PBMaxTextSize='65536' in pbodb170.ini

I tried with PB12.6 and see the same problem with the SYC driver.

Is this a bug or am I missing something for the SYC driver?

Thank you,

Sailaja Jasti

Add to Source Control - setting up GIT option
2017 & 2019 in two different machines with same lo...
Responses (1)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 10 January 2019 02:18 AM UTC
  2. PowerBuilder
  3. # 1

That has been a limitation for a long time and isn't limited to Sybase ASE.

You should be able to open the DataWindow in edit source mode and manually change the size of the column in the resultset.

You could submit a bug report to Appeon, maybe they will fix it.

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.
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.