U++ forum: Welcome to the forum

Re: Date emulation for Sqlite [message #6762 is a reply to message #5295]

Sun, 26 November 2006 18:07

fabio
Messages: 9
Registered: November 2006

Promising Member

EditDate not work with SqlCtrl and Sqlite, but you can make new ctrl like SqlEditDate which work with date like "yyyy-mm-dd" in sqlite table. The only requirement is SQL.GetDialect().

You can change method for support more formats like yyyymmdd (string like number) and others.

//----------------------------------------------------------
//Add this class definition in SqlCtrl.h

class SqlEditDate : public EditDate
{
public:
virtual void SetData(const Value& data);
};

//--------------------------------------------------
// Add this method in SqlCtrl.cpp

void SqlEditDate::SetData(const Value& data)
{
Value valdata = data;
if (SQL.GetDialect()==SQLITE3){
switch(data.GetType()){
case STRING_V:
case WSTRING_V:
valdata = Date(atoi(data.ToString().Mid(0,4)),atoi(data.ToString().Mid (5,2)),atoi(data.ToString().Mid(8,2)));
break;
}
}
SetText((WString)convert->Format(valdata));
}
//-------------------------------------------------

Fabio

Attachment: SqlEditDate.txt
(Size: 0.67KB, Downloaded 735 times)

Report message to a moderator