Home » U++ Library support » U++ SQL » PATCH/BUGFIX Oracle asTable Failure - Solution
PATCH/BUGFIX Oracle asTable Failure - Solution [message #44983] |
Thu, 06 August 2015 15:23 |
wqcmaster
Messages: 37 Registered: March 2013
|
Member |
|
|
Hi,
I found following comments in another forum:
-> You can use AS for table aliasing on many SQL servers (at least MsSQL, MySQL, PostrgreSQL) but it's always optional and on Oracle it's illegal.
So, I changed the following Code:
--------------- SqlStatement.cpp --------------------
SqlSet SqlSelect::AsTable(const SqlId& tab) const
{
StringBuffer t;
t << SqlCase(MSSQL|PGSQL, "")("(")
<< "(" << text << ") " << SqlCase(ORACLE,"")("as") << " \t" << tab.ToString() << '\t'
<< SqlCase(MSSQL|PGSQL, "")(")");
return SqlSet(String(t), SqlSet::HIGH);
}
|
|
|
|
Goto Forum:
Current Time: Wed May 15 04:29:42 CEST 2024
Total time taken to generate the page: 0.03443 seconds
|