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.
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.