Contents Index QuotePrefix property RefreshSchema method

ASA Programming Guide
  Adaptive Server Anywhere .NET Data Provider API Reference
    AsaCommandBuilder class

QuoteSuffix property


Description 

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 Adaptive Server Anywhere QUOTED_IDENTIFIER option is set to off, it can be double quotes. The default is an empty string.

Usage 

Adaptive Server Anywhere 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 

Identifiers

QUOTED_IDENTIFIER option [compatibility]


Contents Index QuotePrefix property RefreshSchema method