quote:

---

Originally posted by easwar

Hi Michael,
You could use a specific worksheet template where the column is set to desired date format, and then push data into that template?
OriginLab

---

quote:

---

Originally posted by cpyang

So you basically want an option to allow default date column format to be specified such that OC code to PutRecordset can force date column (if has Date in the result) to be forced to that specified format, so you don't need to worry about destination or if contents might contain date.

There is already a POSTREADS structure added in 8.1 to allow nCodePage to be specified, so we can add another member to allow Date format to be specified as well.

We can add this but will have to be SR1 (Oct) as we are releasing 8.5.0 next week.

CP

---

#include <Origin.h>
//the following code assume that there exist a ODBC datasource named sqlsever_qa2 which connect to SQL Sever sample database "NorthWind"
//for more format, see http://msdn.microsoft.com/en-us/library/aa226054(SQL.80).aspx
void	test_format_date()
{
	string strConn = "Data Source=sqlserver_qa2;User ID=test;Password=test;";
	string strQuery = "Select FirstName, LastName, CONVERT(char(25), Employees.BirthDate, 120), CONVERT(char(25), Employees.HireDate, 121) from Employees";
	Object ors;
	try
	{
		ors = CreateObject("ADODB.Recordset");
	}
	catch(int nErr1)
	{
		printf("Fail to create COM Object : ADODB.Recordset.\n");
		return;
	}
	try
	{
		ors.Open(strQuery, strConn, 0, 1);
	}
	catch(int nErr2)
	{
		printf("Fail to execute SQL statement.\n");
		return;
	}
	//dump to active worksheet.
	Worksheet wks = Project.ActiveLayer();
	if ( !wks )
	{
		printf("Fail to get active worksheet.\n");
		return;
	}
	try
	{
		wks.PutRecordset(ors);
	}
	catch(int nErr3)
	{
		printf("Fail to import data to worksheet.\n");
		return;
	}	
}

quote:

---

Originally posted by cpyang

So you basically want an option to allow default date column format to be specified such that OC code to PutRecordset can force date column (if has Date in the result) to be forced to that specified format, so you don't need to worry about destination or if contents might contain date.

There is already a POSTREADS structure added in 8.1 to allow nCodePage to be specified, so we can add another member to allow Date format to be specified as well.

---