Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
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 Go to next message
wqcmaster is currently offline  wqcmaster
Messages: 33
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);
}
Re: PATCH/BUGFIX Oracle asTable Failure - Solution [message #45039 is a reply to message #44983] Sun, 23 August 2015 20:27 Go to previous message
mirek is currently offline  mirek
Messages: 12105
Registered: November 2005
Ultimate Member
Thank you, patch applied.
Previous Topic: How to display fields from different tables in one SQLArray
Next Topic: Accessing Database from multiple files
Goto Forum:
  


Current Time: Sun Nov 17 11:45:48 CET 2019

Total time taken to generate the page: 0.01589 seconds