#include <Origin.h>
////////////////////////////////////////////////////////////////////////////////////
#include <variant.h>
#include <VariantTypes.h>	
//#pragma labtalk(0) // to disable OC functions for LT calling.

////////////////////////////////////////////////////////////////////////////////////
// Include your own header files here.


////////////////////////////////////////////////////////////////////////////////////
// Start your functions here.

#define DB_SETUP_STR "Provider=MSDASQL.1;Password="";User ID=Admin;Data Source=PD0;Extended Properties="
#define DB_FILE_FULLPATH "<Your Full Path>\DataSet1.1.db"
#define TABLE_NAME "PINGVELOCITIES"

#define DB_EXTENDED_1 "DSN=PD0;Database="
#define DB_EXTENDED_2 ";StepAPI=0;SyncPragma=;NoTXN=0;Timeout=1000;ShortNames=0;LongNames=0;NoCreat=0;NoWCHAR=0;LoadExt="

BOOL LoadSQLite()
{
	Worksheet wks;
	wks.Create("new");
	
	Object ocrs;
	
	ocrs = CreateObject("ADODB.Recordset"); 
	if( !ocrs )
		return FALSE;
	ocrs.CursorLocation = 3;
	string strConn = DB_SETUP_STR + "\"" + DB_EXTENDED_1 + DB_FILE_FULLPATH + DB_EXTENDED_2 + "\"" + ";";  //user code
	
	ocrs.open("select * from " + TABLE_NAME + ";", strConn, 1, 3);
	
	ocrs.MoveFirst();
	int nRowIndex = 0;
	
	Object ocfield;
	int ct = 0;
	while( !ocrs.eof )
	{
		if( nRowIndex > ocrs.RecordCount )
			break;
		
		for(int ii = 0; ii < ocrs.fields.Count; ii++)
		{
			ocfield = ocrs.fields(ii);
			
			int nFieldType = ocfield.Type;
			string strValue, strCell;
			strValue = ""; 
			
			char t;
			if(nFieldType == 128)
			{ // bin type
				ct++;
				if(ct >= 65){ // data starts on row 65 in this example db 
					// should be
					//"02007E003C00F8FF1E00470051000100060038004E00FDFFF8FF44005400FFFFD3FF6D005600D4FFB8FF98007400DAFFBEFF94007C00EBFFC9FFC90078000A00FAFF92006D00E2FF2B0017017200B3FFFFFF4B016400BEFF090059016F00A0FF3400A8014F0090FF21008D014C0079FF150072014E0055FF32009001390075FFE3FF94013E0064FFFDFF5C013F0098FFC4FF04014E009BFFC1FF0A013500F4FF
					
					///OrigiinLab 11/19/2009 BETTER_HANDLE_FOR_BLOB_DATA
					//if( ocfield.Value != NULL ){
					//	strValue = (string)ocfield.Value;
					//}
					//for(int i = 0; i < 160; i++)
					//{
						//t = strValue[i];
					//}
					_VARIANT		var;
					var = ocfield.Value;					
					ASSERT((VT_ARRAY | VT_UI1) == var.vt); 
					vector<BYTE>			vby;
					vby.Append(var); //now vby contains data like "02007E003C00F8FF1E00470051000100060038004E00FDFFF8FF44005400FFFFD3FF6D005600D4FFB8FF98007400DAFFBEFF94007C00EBFFC9FFC90078000A00FAFF92006D00E2FF2B0017017200B3FFFFFF4B016400BEFF090059016F00A0FF3400A8014F0090FF21008D014C0079FF150072014E0055FF32009001390075FFE3FF94013E0064FFFDFF5C013F0098FFC4FF04014E009BFFC1FF0A013500F4FF
					//you can see in variable window in Code Builder, vby = {2, 0, 126, 0, 60, 0, ..., 244, 255}
					//and then you can decide what to do with this buffer, like just output the content below:
					int nBytes = vby.GetSize();
					for ( int ii = 0; ii < nBytes; ii++ )
					{
						printf("The vby[%d] = 0x%02X\n", ii, vby[ii]);
					}
					///end BETTER_HANDLE_FOR_BLOB_DATA
					
					
				}
			}
		}
		ocrs.MoveNext();
		nRowIndex++; 
		if( ocrs.eof )
			break;
	} 
	return TRUE;
}