U++ forum: Welcome to the forum

Search on this site

Search in forums

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

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

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

Thu, 17 May 2007 23:45

zsolt
Messages: 697
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: 13975
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: 697
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: Wed Apr 24 08:33:54 CEST 2024

Total time taken to generate the page: 0.85315 seconds