
var objDB;

event OnInitialize()
{
	::SvsDump("OnInitialize:" + ::SvsGetActionName());
	objDB = new DirectQueryDB;
	::SetTimer(0, 5000, -1);
}

event OnTerminate()
{
	objDB.DisConnect();
	::SvsDump("OnTerminate:" + ::SvsGetActionName());
}

event OnTimer(timerid,counter)
{
	::SvsDump("OnTimer Id:" + ::CStr(timerid) + " counter:" + ::CStr(counter));

	if(!mConecctDB()){
		 return;
	}
	var vFieldNum, vRecordNum, vFieldName, vFieldType, vData;
	if(!objDB.QuerySQL("SELECT * FROM TABLE1", vFieldNum, vRecordNum, vFieldName, vFieldType, vData)){
		::SvsDump("Fail to query sql. Msg:" + objDB.GetLastError());
		objDB.DisConnect();
		return;
	}

	::SvsDump("FieldName:" + ::CArrayToStr(vFieldName, ",", F));
	::SvsDump("Data:" + ::CScript(vData));
}

function mConecctDB()
{
	var vDBInfo = "MS Access Database;" &
	              "DBQ=dbsample.mdb;" &
	              "DriverId=25;" &
	              "FIL=MS Access;" &
	              "MaxBufferSize=2048;" &
	              "PageTimeout=5;" &
	              "+DATASOURCE=MS Access Database";

	if(!objDB.Connect(vDBInfo, "", "", "")){
		::SvsDump(objDB.GetLastError());
		return F;
	}
	return T;
}