MsgTerse

Description

Specifies whether DataWindow Designer 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, DataWindow Designer 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 DataWindow Designer 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 DataWindow Designer 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 parameter to 'Yes' to display shorter ODBC error messages in DataWindow Designer. This might be useful if space on your screen is limited.

Examples

Example 1

To specify that DataWindow Designer 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.
Application Type the following in code:
```
SQLCA.DbParameter="MsgTerse='Yes'"
```