PB 12.6 GetItemString returns only a partial string

[Former Member]

I have a DW which basically returns a large string, size is about 66K, but upon using the GetItemString(row,"col name"), I got only 32K string back.

The code is similar to this:

String a

a = dw_1.GetItemString(row, "sql_text")

messagebox("len",string (len(a)) )

I think i might have hit the limit of this function as I understand that string can accommodate much more than 32K length.

Any advise or work-around or solution is appreciate it since now I have to go out of PB to another application in order to obtain the whole string.

Thanks.

[Former Member]

Hi Binh;

  PB's standard operating mentality is to limit large textual data to 32K from your DBMS by default. Internally of course, it can handle strings up to 2Gig ( that's 1,073,741,823 Unicode [Double-Byte]  characters of course  ).

   To enable large textual data streams, you will need to change your DB connection settings to over-ride the 32K default. The settings & location will vary depending on the DB Client Type you are connecting with.

   For the ASE DBMS when using its native DB Client for example, you will need to add the following to your DBParm field in SQLCA, as follows:

SQLCA.DBParm = "PacketSize=2048,Async=1,DBTextLimit='100000000'"

FYI: Check the PB Help file for the exact setting required for your DB Client.

HTH

Regards ... Chris