We are in the process of developing a SQL query editor. In this editor users will have the ability to write SQL queries using normal SQL syntax. As users construct these queries, they will use the option of using string variables that will be resolved to literal strings prior to submitting the query to be executed. During the construction process of these SQL queries users may misspell these variables. We would like to use syntax editor to hightlight these and other SQL syntax errors.
For example, take the SQL syntax below. For these examples the variables { Variable1, Variable2, Variable3} are valid variables that can be used in a query. Since the first example has the variable typed correctly this is valid. The second example has a misspelled variable, in these scenario we would like the misspelled variable to be highlighted in some fashion that will bring the user to take action to resolve. Is Syntax editor the best solution to accomplish our desired goal?
Valid Variable List: Variable1, Variable2, Variable3
Valid = Select * from Table where Column = Variable1
Invalid = Select * from Table where Column = Variabl1
Hello Andy,
After investigating this and doing some research, compiling the sql in syntax editor has been determined to be a product idea. You can suggest new product ideas for future versions by submitting here: http://ideas.infragistics.com
Remember when submitting your idea to explain the context in which a feature would be used and why it is needed as well as anything that would prevent you from accomplishing this today. You can even add screenshots to build a stronger case. You can also link back to this thread for additional details.Thank you in advance to submitting your product idea.
Include a link to this thread in your idea so product management will be able to look back at this forum thread.