U++ framework: U++ SQL » SqlFormat() bug with Date and Time types

Home » U++ Library support » U++ SQL » SqlFormat() bug with Date and Time types

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SqlFormat() bug with Date and Time types [message #9603]

Sun, 20 May 2007 15:03

zsolt
Messages: 702
Registered: December 2005
Location: Budapest, Hungary

Contributor

SqlFormat() generates some trash characters with Date and Time arguments.
As a result, you can not use dates and times in your SQL queries.
Here is the testcase:

#include <Core/Core.h>
#include <Sql/Sql.h>

using namespace Upp;


CONSOLE_APP_MAIN
{
	Date sysdate = GetSysDate();	
	String s = SqlFormat(sysdate);
	Cout() << "Todays date is: " << s;
	while(1)
		Sleep(1000);
}

Report message to a moderator

Re: SqlFormat() bug with Date and Time types [message #9604 is a reply to message #9603]

Sun, 20 May 2007 15:21

zsolt
Messages: 702
Registered: December 2005
Location: Budapest, Hungary

Contributor

As a fast hack, I use this code in SqlCase.cpp

String SqlFormat(Date x)
{
	return FormatDate(x, "'YYYY-MM-DD'");
	//return MakeSqlValue(SQLC_DATE, x);
}

String SqlFormat(Time x)
{
	return FormatTime(x, "'YYYY-MM-DD hh:mm:ss'");
	//return MakeSqlValue(SQLC_TIME, x);
}

But I think, this should depend on current database handler.

Report message to a moderator

Re: SqlFormat() bug with Date and Time types [message #9605 is a reply to message #9604]

Sun, 20 May 2007 18:31

mirek
Messages: 14290
Registered: November 2005

Ultimate Member

Sorry, I should have perhaps renamed (or hide) SqlFormat.

It works OK. Just it creates the text that is to be compiled for target RDBMS (those odd characters...).

Use SqlCompile to get the final text.

Mirek

Report message to a moderator