Quick References
      ADO
      ASP
      CSS2
      HTML
      JavaScript
      Jet SQL
      VBScript
      WML
      WMLScript
      WSH
      XHTML
      XML DOM
      XSLT

Features
      Knowledge Base
      Tutorials

Partners
     ZVON.ORG
     XML
     Planet Source Code
     VisualBuilder
     Web Design
     Your HTML Source
     XML/XSLT Forums
     ASPAlliance
     Scripts
     
     Programmers Heaven
     Tek-Tips Forums
     Developer Fusion
     Code Project











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-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information