ADO » Command » Dialect
- Syntax:
- commandobject.Dialect = string
string = commandobject.Dialect
Sets or returns the dialect to be used for the CommandStream or CommandTextproperties.
The Dialect property, new to ADO 2.6, sets or returns the dialect to be used for the
CommandStream or
CommandText properties. This is a provider-independent
Globally Unique IDdentifier which allows the provider to support
multiple dialects. Its main use is in XML-generated Recordsets, where it identifies what form
of XML the Recordset is stored in. The default dialect is standard SQL which has the
following GUID:
{C8B521FB-5CF3-11CE-ADE5-00AA0044773D}
And for the SQL XML format used by SQL Server 2000 the GUID is ...
{5D531CB2-E6ED-11D2-B252-00C04F681B71}
See Also:
