You need to sign in to do that
Don't have an account?
ccracy
Duplicate check (via Trigger) when bulk inserting using API
I have writen a 'before insert' trigger to check for duplicates while
creating new Accounts. When I do a bulk insert operation for Accounts
using API, duplicates within this batch are not caught.
I beleive the reson for this is that the trigger is a bulk trigger. It checks for duplicates for the entire batch against Accounts already in the db. Only after having done the duplicate check (for the entire batch), it inserts (creates) the entire batch. Therefore, it misses any duplicate within this batch of Accounts.
Is there a way, where in I can catch duplicates within the batch also.
Thanks,
Rohit M.
I beleive the reson for this is that the trigger is a bulk trigger. It checks for duplicates for the entire batch against Accounts already in the db. Only after having done the duplicate check (for the entire batch), it inserts (creates) the entire batch. Therefore, it misses any duplicate within this batch of Accounts.
Is there a way, where in I can catch duplicates within the batch also.
Thanks,
Rohit M.
Message Edited by ccracy on 08-27-2007 02:02 AM
Code:
Of course this logic may not be what you want but you should get the idea.
Regards,