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 previous message
wqcmaster is currently offline  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);
}
 
Read Message
Read Message
Previous Topic: How to display fields from different tables in one SQLArray
Next Topic: Accessing Database from multiple files
Goto Forum:
  


Current Time: Fri Mar 29 11:55:11 CET 2024

Total time taken to generate the page: 0.01790 seconds