Skip to main content
Archived

Add SQL Special Expressions to all SQL Text Editors

Related products:Transformers
siennaatsafe
bruceharold
cfvonner
  • siennaatsafe
    siennaatsafe
  • bruceharold
    bruceharold
  • cfvonner
    cfvonner

cfvonner
Supporter

I can't tell you how many times I forget the exact syntax for "FME_SQL_DELIMITER ;" when I'm working with SQLCreator, SQLExecutor, the "SQL To Run Before/After Write" parameters, or anywhere else I enter SQL statements. I have to look it up every time.


I propose a new "SQL Special Expressions" or similar group entry in the left-hand side of the SQL Text editor (see image)

and the very first item on that new group entry would be "FME_SQL_DELIMITER". This would be similar to the Special Characters group entry in most attribute text editors (see image):

There might be other handy SQL-related expressions that could go in this group entry.

<strong>This post is closed to further activity.</strong><br /> It may be a question with a best answer, an implemented idea, or just a post needing no comment.<br /> If you have a follow-up or related question, please <a href="https://community.safe.com/topic/new">post a new question or idea</a>.<br /> If there is a genuine update to be made, please contact us and request that the post is reopened.

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings