Differences in Delimit Characters

OLE DB Programmer's Reference

The examples in the preceding sections (see "Delimited Identifiers" and "Delimited Identifiers Returned from the Provider") used square brackets ([ ]) as delimit characters, which is a common implementation. However, it is possible to use other delimit characters as well. A consumer cannot rely on any particular delimit character when working with multiple data stores but should check for a provider's delimit characters. This ensures interoperability.

The OLE DB method IDBInfo::GetLiteralInfo allows consumers to interrogate providers to determine their delimit characters. The consumer should use DBLITERAL = DBLITERAL_QUOTE. In the returned DBLITERALINFO structure, the pwszLiteralValue column contains the delimit characters.

If the pwszLiteralValue column contains just one character, the same character is used at both ends of the delimited identifier. A common example is the double quotation mark ("), which is used as follows: "USA"."New Jersey"."New Albany". If the pwszLiteralValue column contains two characters, the first character begins the delimited identifier and the second character terminates it; the double bracket characters are an example of this.

1998-2001 Microsoft Corporation. All rights reserved.



Microsoft Ole Db 2.0 Programmer's Reference and Data Access SDK
Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)
ISBN: 0735605904
EAN: 2147483647
Year: 1998
Pages: 1083

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net