XSLT Extension Functions

// Titles.h : Declaration of the CTitles

#pragma once

// code generated on Monday, October 27, 2003, 12:28 PM

[
	#error Security Issue: The connection string may contain a password
// The connection string below may contain plain text passwords and/or
// other sensitive information. Please remove the #error after reviewing
// the connection string for any security related issues. You may want to
// store the password in some other form or use a different user authentication.
db_source(L"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\\CODE\\vc_local\\article\\extFunc\\bib2.mdb;Mode=Share Deny None;Extended Properties=\"\";Jet OLEDB:System database=\"\";Jet OLEDB:Registry Path=\"\";Jet OLEDB:Database Password=\"\";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password=\"\";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False"),
	db_command(L" \
	SELECT \
		Comments, \
		Description, \
		ISBN, \
		Notes, \
		PubID, \
		Subject, \
		Title, \
		`Year Published` \
		FROM Titles")
]
class CTitles
{
public:
// This table/command contains column(s) that can be accessed
// via an ISequentialStream interface.  Not all providers, however,
// support this feature, and even those that do support it, are
// often limited to just one ISequentialStream per rowset.
// If you want to use streams in this accessor, use the sample
// line(s) of code below, and set the DBPROP_ISequentialStream
// rowset propery to true.  You can than use the Read() method
// to read the data.  For more information on
// ISequentialStream binding see the documentation

	// In order to fix several issues with some providers, the code below may bind
	// columns in a different order than reported by the provider

	// [ db_column(1, status=m_dwCommentsStatus, length=m_dwCommentsLength) ] ISequentialStream* m_Comments;	// Description of book
	[ db_column(1, status=m_dwCommentsStatus, length=m_dwCommentsLength) ] TCHAR m_Comments[8000];	// Description of book
	[ db_column(2, status=m_dwDescriptionStatus, length=m_dwDescriptionLength) ] TCHAR m_Description[51];	// Table of Contents, Pages, Index
	[ db_column(3, status=m_dwISBNStatus, length=m_dwISBNLength) ] TCHAR m_ISBN[21];	// International Standard Book Number
	[ db_column(4, status=m_dwNotesStatus, length=m_dwNotesLength) ] TCHAR m_Notes[51];	// General Notes
	[ db_column(5, status=m_dwPubIDStatus, length=m_dwPubIDLength) ] LONG m_PubID;	// Publisher's ID Number
	[ db_column(6, status=m_dwSubjectStatus, length=m_dwSubjectLength) ] TCHAR m_Subject[51];	// Keywords
	[ db_column(7, status=m_dwTitleStatus, length=m_dwTitleLength) ] TCHAR m_Title[256];	// Book title
	[ db_column(8, status=m_dwYearPublishedStatus, length=m_dwYearPublishedLength) ] SHORT m_YearPublished;	// Year Published

	// The following wizard-generated data members contain status
	// values for the corresponding fields. You
	// can use these values to hold NULL values that the database
	// returns or to hold error information when the compiler returns
	// errors. See Field Status Data Members in Wizard-Generated
	// Accessors in the Visual C++ documentation for more information
	// on using these fields.
	// NOTE: You must initialize these fields before setting/inserting data!

	DBSTATUS m_dwCommentsStatus;
	DBSTATUS m_dwDescriptionStatus;
	DBSTATUS m_dwISBNStatus;
	DBSTATUS m_dwNotesStatus;
	DBSTATUS m_dwPubIDStatus;
	DBSTATUS m_dwSubjectStatus;
	DBSTATUS m_dwTitleStatus;
	DBSTATUS m_dwYearPublishedStatus;

	// The following wizard-generated data members contain length
	// values for the corresponding fields.
	// NOTE: For variable-length columns, you must initialize these
	//       fields before setting/inserting data!

	DBLENGTH m_dwCommentsLength;
	DBLENGTH m_dwDescriptionLength;
	DBLENGTH m_dwISBNLength;
	DBLENGTH m_dwNotesLength;
	DBLENGTH m_dwPubIDLength;
	DBLENGTH m_dwSubjectLength;
	DBLENGTH m_dwTitleLength;
	DBLENGTH m_dwYearPublishedLength;


	void GetRowsetProperties(CDBPropSet* pPropSet)
	{
		pPropSet->AddProperty(DBPROP_CANFETCHBACKWARDS, true, DBPROPOPTIONS_OPTIONAL);
		pPropSet->AddProperty(DBPROP_CANSCROLLBACKWARDS, true, DBPROPOPTIONS_OPTIONAL);
		// pPropSet->AddProperty(DBPROP_ISequentialStream, true);
	}
};