Skip to main content
Released

InlineQuerier and SQLExecutor text editor behavior changed in 2016, revert to 20

Related products:FME Form
  • August 24, 2016
  • 3 replies
  • 31 views

Forum|alt.badge.img

***Note from Migration:***

Original Title was: InlineQuerier and SQLExecutor text editor behavior changed in 2016, revert to 2015


The text editing of SQL in the InlineQuerier and SQLExecutor used to allow for simple drag-and-drop of the field names into the notepad space,

now in FME2016 dragging a field name creates double quotes and a line feed character, all of which have to be deleted

please can the drag-and-drop behaviour return to just the field name

- or ideally with the addition of its table prefixed e.g table_name.field_name

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

Forum|alt.badge.img+2
  • August 26, 2016
@j I believe the quotes are added so that if you're working with a case sensitive database like PostGreSQL or Oracle your queries will still work. But the linefeed is irritating and I've logged a change request and will post here when this is addressed - PR71876

 


Update on Newlines:This was a bug introduced in FME 2016.1 and should already be fixed in the latest FME 2017 betas.


Forum|alt.badge.img+1

This has been released as part of FME 2017.0 . Visit http://www.safe.com/downloads to download it and give it a spin.