MsgTerse

Description

Specifies whether PocketBuilder should display terse error messages for ODBC drivers. A terse error message is one without the SQLSTATE = nnnn prefix, where nnnn is the number of the error message.

By default, PocketBuilder displays ODBC error messages with the SQLSTATE prefix. To display error messages without the SQLSTATE prefix, set MsgTerse to Yes.

Applies to

ODBC

Syntax

MsgTerse = ‘value’

Parameter	Description
value	Specifies whether PocketBuilder should display error messages without the SQLSTATE prefix. Values are: Yes Display error messages without the SQLSTATE prefix. No (Default) Display error messages with the SQLSTATE prefix.

Parameter

Description

value

Specifies whether PocketBuilder should display error messages without the SQLSTATE prefix. Values are:

Yes Display error messages without the SQLSTATE prefix.
No (Default) Display error messages with the SQLSTATE prefix.

Default

MsgTerse = ‘No’

Usage

You can set the MsgTerse DBParm parameter to Yes to display shorter ODBC error messages in PocketBuilder. This may be useful if space on your screen is limited.

Examples

Example 1

To specify that PocketBuilder should display terse error messages without the SQLSTATE prefix:

Database profile Select the Display Terse Error Messages check box on the System tab in the Database Profile Setup dialog box.
PocketBuilder application script Type the following in a PocketBuilder application script:
```
SQLCA.dbParm = "MsgTerse = 'Yes'"
```