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

[Message index]

		SQL "AS" for PostgreSQL fixed By: zsolt on Thu, 17 May 2007 23:45
		Re: SQL "AS" for PostgreSQL fixed By: mirek on Fri, 18 May 2007 10:11
		Re: SQL "AS" for PostgreSQL fixed By: zsolt on Sat, 19 May 2007 14:02

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: Tue Nov 03 13:59:40 GMT+1 2026

Total time taken to generate the page: 1.48113 seconds