Sql Loader + Trigger

I have a problem, i must load a table by Loader whith append condition, but before i append a new record i must delete from table all the article that have the same date of the article that i must load, e.g:

TABLE pippo

id qta date
--- ------ -------

001      11      03/06/98
002      12      03/06/98
004      0       07/06/98
005      1       07/06/98
006      2       07/06/98
007      3       07/06/98
008      4       07/06/98

ok, in my infile i have all records that have date=07/06/98 and so before load i must delete all records that have date=07/06/98. Note that when i load i don't know the date of the records. I have made a before trigger that delete all records with date=07/06/98 but it don't works correctly it insert in table only half of record e.g. if in file has 60 rec. it insert 30!
Can someone Help me!
****** PLEASE REPLAY MY BY E-MAIL BECAUSE I CAN'T OFTEN READ NEWS !!!!        drmix_at_hotmail.com
Thanks to all for attention, and excuse me for my bad english!!

Bye :-) Domenico Ricci From italy.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 05 1998 - 11:35:45 CEST