QuotePrefix Property

The beginning character or characters to use when specifying database object names that contain characters such as spaces.

Syntax

string QuotePrefix

Access

Read-write

Property Value

The beginning 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.