Skip to main content
Released

improve SQLExecutor to operate the same way on all databases it supports

Related products:FME Form
  • August 11, 2017
  • 4 replies
  • 79 views
1
Forum|alt.badge.img+1

It would be good if the SQL Executor operates the same way on any database formats its supports.

Recently I've had an issue whereby I cannot execute a 'DELETE from <my-table>' statement on SpatiaLite, but I can execute the same statement on Oracle Spatial.

See the following Knowledge Centre question and supporting answers/comments at

https://knowledge.safe.com/questions/50230/sql-executor-and-spatialite-delete-or-drop-command.html

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.

4 replies

L

I have a feeling this is also the cause why "with" statements don't work either.

chau
Contributor
Forum|alt.badge.img+3
  • chauContributor
  • Contributor
  • January 9, 2018

I think my issues with creating views (and indices, though they can be made using the SQLite non-spatial) are due to the same limitations.

kimo
Contributor
Forum|alt.badge.img+10
  • kimoContributor
  • Contributor
  • September 10, 2018
At least add a note in the documentation! ie We only support read-only SQL Executor queries.

 

But why? I am using spatialite precisely to do fast sql selections for real-time updates. I really need a Truncate function. Drop and Create is not possible because it invokes a file lock.

 

 

andreaatsafe
Safer
Forum|alt.badge.img+17

I'm please to let you know that a recent update to FME 2020.2 beta (build 20709 and newer) has enabled SQL executing statements for the SpatiaLite format in the SQLCreator and SQLExecutor. We now support more than read-only SQL statements when using the SpatiaLite format (eg. INSERT/UPDATE/DELETE/CREATE/DROP).

You can find the latest beta build here: www.safe.com/beta

- Andrea

Community Stats

32,751
Posts
124,206
Replies
41,258
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.