Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Optimized way to transfer from String to StringBuilder
Message
From
05/02/2014 14:20:05
 
 
To
05/02/2014 14:11:52
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01593079
Message ID:
01593319
Views:
21
>Are you allowing the user to type SQL which you are then executing? Is that why you are trying to strip out reserved words?

No, this is because the development projects build their SQL in ANSI format, without having any dependencies on the backend. So, we do not have to worry about reserved word and avoid unexpected surprises if something becomes a reserved word later on. This is also to be able to move backend at any time without having to change the development projects. So, only the framework would need to be adjusted in case SQL Server would turn a new word into a reserved word in the future or if we change backend and we would need to adjust a new method for the same in consideration to a different set of reserved words.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform