PROPERTY:  Command::Dialect

commandobject.Dialect = string
string = commandobject.Dialect

 
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}

Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information