Currently I am using SQL Executer alongwith FeatureHolder but in this the query is initiating on each line read. I want something to be executed on process start for one time only.
Can anybody help me in this.
Question
Deleting records from table before inserting it.
+1I am reading input data stored in Excel format, then making geometry out of it and then writing it to oracle spatial but before writing I have to delete previous records from the tables which I am about to write, the records which I want to delete can be identified from a database field which is there in every table I am about to process.
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.
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.
Hi,
If you want to execute the query only when the first line comes, you can add sequential number to lines (the Counter), then test whether the line is the first one or not (the Tester).
Takashi
+5Maybe this is thinking too simple, but wouldn't the Oracle Writer Mode 'Update' not accomplish exactly this? That is, given the key is set correctly.