On 13-2-2015 14:55, Kjell Rilbe kjell.ri...@datadia.se [firebird-support] wrote: > I'm writing a utility that will need to do two things for each record in > an external table and for this purpose I use a for select ... do > construct in an execute block. I do it this way because external tables > can't be indexed and I will scan the entire external table anyway. > > The two operations are: > 1. Update one existing record in the target table. > 2. Insert new record in the same target table.
Maybe you can use MERGE, it uses a source, a target and can conditionally insert, update (and delete) record? I assume your target table isn't external and is indexed. Mark -- Mark Rotteveel