Archived

Improve SQL inputs on readers

Related products:Integrations

Forum|Forum|9 years ago
December 2, 2016
4 replies
67 views

+11

roland.martin
Contributor

The WHERE and SELECT statements - I would very much like:

To see some code colouring on the SQL view - it seems to just change it to fixed-width text
To be able to input line breaks so that I can understand the query next time I open it
To be able to import (and export) saved *.sql files
To be able to test the statement
If SELECT is blank, I'd like it to automatically populate itself by building the query that FME is using, i.e. "SELECT * FROM [table] WHERE [where_clause]"
It would be amazeballs if you could import the schema from the query and overwrite the attribute names in the reader properties

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.

+11

roland.martin
Author
Contributor
Forum|Forum|9 years ago
December 2, 2016

5. If SELECT is blank, I'd like it to automatically populate itself by building the query that FME is using, i.e. "SELECT * FROM [table] WHERE [where_clause]"

6. It would be amazeballs if you could import the schema from the query and overwrite the attribute names in the reader properties

Upvote

+22

fmelizard
Safer
Forum|Forum|9 years ago
December 3, 2016

Very good suggestions. We have an idea to one day merge the FeatureReader with the SQLCreator and these are very good suggestions for that day...if not before.