U++ framework: U++ Developers corner » How should we deal with SQL column names in conflict with SQL standard keywords

Home » Developing U++ » U++ Developers corner » How should we deal with SQL column names in conflict with SQL standard keywords

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How should we deal with SQL column names in conflict with SQL standard keywords [message #35280]

Sat, 28 January 2012 15:28

mirek
Messages: 14291
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.

Report message to a moderator

[Message index]

		How should we deal with SQL column names in conflict with SQL standard keywords By: mirek on Sat, 28 January 2012 15:28
		Re: How should we deal with SQL column names in conflict with SQL standard keywords By: mr_ped on Mon, 30 January 2012 08:52

Previous Topic:	How do you develop in U++?
Next Topic:	SCGI Class

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Oct 11 08:56:33 GMT+2 2026

Total time taken to generate the page: 0.00611 seconds