/************************************************************************************************************

	ÀÛ¼ºÀÚ : newtype

	ÃÖÁ¾ ¼öÁ¤ÀÏ : 2003.08.09

	¼³¸í : SQLCEÀÇ RDA±â´ÉÀ» À§ÇÑ Å¬·¡½º
	          RDAÀÇ Push´Â ºüÁ®ÀÖ½À´Ï´Ù.

			  ¡Ø ¹Ýµå½Ã ¼­¹ö URL ¹Ø¿¡ Mobile/sscesa20.dllÀÌ Á¸ÀçÇØ¾ß ÇÑ´Ù.
			     ex )   http://192.168.0.2/Mobile/sscesa20.dll

	ȯ°æ : SQLCE 2.0, EVC 3.0

	Å×½ºÆ® : Windows 2000, Windows XP, EVC3.0, PPC3.0, PPC2002, ADOCE 3.1

	»ç¿ë ¹æ¹ý :
  
    CCERda Rda;

	// ÃʱâÈ­
	Rda.Initialize(  L"192.168.0.2",    // ¼­¹ö URL
	                      L"Northwind",     //  DB Name
						  L"sa",	L"sa",       //  DBÁ¢±Ù »ç¿ëÀÚ, ¾ÏÈ£  
						  L"\\Northwind.sdf" );  // Àӽà DBÀ̸§ 


	// Pull
	Rda.Pull( L"Orders",					// Àӽà Å×À̺í À̸§
	              L"SELECT OrderID, ShipName FROM Orders"  );


    // SubmitSQL
	Rda.SubmitSQL( L"UPDATE Orders SET ShipName='newtype' WHERE OrderID=10248" );


/**************************************************************************************************************/
// CERda.h: interface for the CCERda class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_ISSCEMODULE_H__9ABFCD69_98B4_4DFA_B8CC_157BB1C55AA0__INCLUDED_)
#define AFX_ISSCEMODULE_H__9ABFCD69_98B4_4DFA_B8CC_157BB1C55AA0__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

#include <COMDEF.H>
#include <ca_mergex20.h>
#include "VORecordset.h"

class CCERda  
{
public:	
	CCERda();
	virtual ~CCERda();

	void Initialize( LPCTSTR RemoteServerURL, LPCTSTR RemoteDBName, 
		             LPCTSTR RemoteDBAccount, LPCTSTR RemoteDBPassword, 
					 LPCTSTR LocalDBFilename );
	HRESULT SubmitSQL( LPTSTR SelectString);
	HRESULT Pull( LPTSTR TableName, LPTSTR SelectString, 
		          BOOL Tracking=FALSE, LPTSTR ErrorTable=_T("tblError") );
private:
	ISSCERDA    *m_pIRda;           // RDA Pointer

	BOOL	 m_Init;				// Initialize() È£Ãâ ¿©ºÎ
	CString  m_OLEConnectString;    // Remote DB ¿¬°á ¹®ÀÚ¿­ 
	CString  m_LocalDBFilename;     // Local DB Filename

	void CreateDB( LPCTSTR LocalDBFilename );
	void ShowError( LPTSTR ErrorMessage );

};

#endif // !defined(AFX_ISSCEMODULE_H__9ABFCD69_98B4_4DFA_B8CC_157BB1C55AA0__INCLUDED_)