PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Why is my Database text field truncated  (Read 744 times)

PxPlus

  • Administrator
  • Diamond Member
  • *****
  • Posts: 1062
    • View Profile
Why is my Database text field truncated
« on: June 21, 2018, 02:48:40 PM »
When PxPlus access an external data using the ODBC, MySql, Oracle, ADO, or DB2 interface it needs to set aside a buffer into which the records returned to the program will be build.  This internal buffer will be allocated during the open based on the total length of the data fields in the table.

When referencing text fields, such as CHAR of VARCHAR, the database interfaces set a default text field maximum of 8192 characters.  You can change this by specifying TEXTMAX=nnnn as an option in the OPEN directive. 

Note: This default can also be set in the PxPlus INI in the respective database definition section: [ODBC], [MYSQL], [OCI], [ADO], and [DB2]