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 » Developing U++ » U++ Developers corner » How should we deal with SQL column names in conflict with SQL standard keywords
How should we deal with SQL column names in conflict with SQL standard keywords [message #35280] Sat, 28 January 2012 15:28 Go to previous message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
Well, this is something that was sort of omitted in the past, however it seems like it would be worth to support columns names that are in conflict with SQL keywords, like:

select FROM from TABLE


which can be legaly written in SQL as

select "FROM" from TABLE


Obviously, putting " around all SqlId names is relatively simple to do, with little complaint that resulting SQL logs will a little bit harder to read.

Then I was thinking about puttin " only around SqlIds that are in conflict.... potentially slow.

Ha! Maybe put it everywhere and then remove all '\"' from SQL logs? Simple enough.
 
Read Message
Read Message
Previous Topic: How do you develop in U++?
Next Topic: SCGI Class
Goto Forum:
  


Current Time: Sat Apr 27 08:00:00 CEST 2024

Total time taken to generate the page: 0.05882 seconds