Maybe you can implement try..except

While not dssource.eof do begin
try
dstarget.insert;
dstarget['somefield'] := dssource['somefield']
dstarget.post;
except
dstarget.cancel;
end;
dssource.next;
database.commit; //or commit every n records
End;

HTH

> -----Original Message-----
> From: Bayu [mailto:bayu@...]
> Sent: Monday, January 13, 2003 14:24
> To: IB Support
> Subject: [ib-support] Insert Data which not canceled if
> something wrong like violation on unique index
>
>
>
>
> Hi,
>
> I just try freeware IB Data pump from www.clevercomponents.com.
>
> On this product, i can pump from another db to fb/ib.
>
> In this product, when migration still in progress and if the
> target db have unique index and violation occurs about duplicate
> unique index, the migration is still goes and will skip this
> errors. ( On my project if error with duplicate, then process
> will end and no records commiting )
>
> How can i implement this feature in my projets ?
>
> Any suggestion will appreciated
>
> regards
>
> Bayu