• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 30. Understanding Universal Data... > Programming Stream Objects

Programming Stream Objects

For Access programmers, Stream objects primarily are of interest for returning attribute-centric XML data documents from SQL Server 2000. The T-SQL statement for the query must terminate with the FOR XML AUTO or FOR XML RAW option. Both options return a well-formed XML document using Microsoft’s xml-sql schema. Unlike the .xml files saved from Recordset objects with the adPersistXML option, the stream doesn’t include the schema elements. Like the rowset schema, xml-sql isn’t compatible with Access 2003’s native XML schema. SQL Server HTTP template queries, which can return HTML tables to Web browsers from FOR XML AUTO queries, require the xml-sql schema.


→ For an example of using the FOR XML AUTO option in SQL Server HTTP template queries, see “Using SQL Server 2000’s HTTP Query Features,” p. 976.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint