U++ framework: U++ SQL » SQL "AS" for PostgreSQL fixed

Home » U++ Library support » U++ SQL » SQL "AS" for PostgreSQL fixed

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

SQL "AS" for PostgreSQL fixed [message #9582]

Thu, 17 May 2007 23:45

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

Contributor

To be able to use SqlId::As() with PostgreSQL, you have to change Sql/SqlVal.cpp:

SqlCol SqlId::As(const char *as) const
{
	//return id.IsNull() ? ToString() : ToString() + SqlCase(MSSQL, " as ")(" ") + as;
	return id.IsNull() ? ToString() : ToString() + SqlCase(MSSQL | POSTGRESS, " as ")(" ") + as;
}

[Updated on: Thu, 17 May 2007 23:46]

Report message to a moderator

Re: SQL "AS" for PostgreSQL fixed [message #9584 is a reply to message #9582]

Fri, 18 May 2007 10:11

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

zsolt wrote on Thu, 17 May 2007 17:45

To be able to use SqlId::As() with PostgreSQL, you have to change Sql/SqlVal.cpp:

SqlCol SqlId::As(const char *as) const
{
	//return id.IsNull() ? ToString() : ToString() + SqlCase(MSSQL, " as ")(" ") + as;
	return id.IsNull() ? ToString() : ToString() + SqlCase(MSSQL | POSTGRESS, " as ")(" ") + as;
}

Thank you. Also fixed SqlCol::As.

Mirek

Report message to a moderator

Re: SQL "AS" for PostgreSQL fixed [message #9602 is a reply to message #9584]

Sat, 19 May 2007 14:02

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

Contributor

thanks.

Report message to a moderator

Previous Topic:	Please help the SQL-challenged
Next Topic:	SqlFormat() bug with Date and Time types

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Sep 06 23:01:48 GMT+2 2026

Total time taken to generate the page: 0.00570 seconds