sqlceoperateshow.cpp

WinCE开发技巧与实例的配套源码

// SQLCEOperateShow.cpp: implementation of the SQLCEOperateShow class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "sqlcedemo.h"
#include "SQLCEOperateShow.h"

#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

SQLCEOperateShow::SQLCEOperateShow()
{

}

SQLCEOperateShow::~SQLCEOperateShow()
{

}

//DEL bool SQLCEOperateShow::CreateCatlog(CEADORecordset *adoRs)
//DEL {
//DEL 
//DEL }

bool SQLCEOperateShow::CreateTable(CEADORecordset *adoRs)
{
return adoRs->Open(L"CREATE TABLE [tabletest] ( \
	[cust_id] [int] IDENTITY (1, 1) NOT NULL , \
	[FIXED_DAY] [int] NULL , \
	[MONTHLY_TARGET] [money] NULL , \
	[TARGET_PERCENT] [float] NULL , \
	[REGION_ID] [int] NULL , \
	[AREA] [float] NULL , \
	[ADD_DATE] [datetime] NULL )");
}

bool SQLCEOperateShow::InsertData(CEADORecordset *adoRs)
{
return adoRs->Open(L"select distinct(competitorname) changshang from competitor_prod");
}