DBTextLimit

Description

Specifies the maximum length of a long VarChar column that can be returned when you include the column in a SQL SELECT statement.

Applies to

UL9 UltraLite
UL10 UltraLite 10

Syntax

DBTextLimit = 'value'

Parameter	Description
value	The maximum length in bytes of a long VarChar column that UltraLite returns when you include the column in a SQL SELECT statement. The range of valid values is from 0 bytes to 65,536 bytes. If you set DBTextLimit to 0 or to a value that exceeds the maximum value, UltraLite returns the maximum length column.

Parameter

Description

value

The maximum length in bytes of a long VarChar column that UltraLite returns when you include the column in a SQL SELECT statement. The range of valid values is from 0 bytes to 65,536 bytes.

If you set DBTextLimit to 0 or to a value that exceeds the maximum value, UltraLite returns the maximum length column.

Default

DBTextLimit='32767'

Usage

You can set the DBTextLimit parameter if you want to include a long VarChar column in a DataWindow object without treating it as a binary large object (blob) and using SelectBlob and UpdateBlob. Setting DBTextLimit preallocates a buffer for retrieving the data.

Examples

Example 1

To have DB-Library or CT-Library return a long VarChar column that is up to 32,000 bytes long when you include the column in a SQL SELECT statement:

Database profile Type 32000 in the DBTextLimit box on the Syntax tab in the Database Profile Setup dialog box.
PocketBuilder application script Type the following in a PocketBuilder application script:
```
SQLCA.dbParm = "DBTextLimit='32000'"
```