QuoteSuffix Property

The ending character or characters to use when specifying database objects whose names contain characters such as spaces.

Syntax

string QuoteSuffix

Access

Read-write

Property Value

The ending character or characters to use. This can be square brackets, or, if the ASE QUOTED_IDENTIFIER option is set to off, it can be double quotes. The default is an empty string.

Usage

  • ASE objects can contain characters such as spaces, commas, and semicolons. The QuotePrefix and QuoteSuffix properties specify delimiters to encapsulate the object name.

  • Although you cannot change the QuotePrefix or QuoteSuffix properties after an Insert, Update, or Delete operation, you can change their settings after calling the Update method of a DataAdapter.

See also

  • The Adaptive Server Enterprise Reference Manual for more information about identifiers.

  • The Adaptive Server Enterprise Reference Manual for more information about the QUOTED IDENTIFIER option.