Still getting duplicate runners in listMarketCatalogue!!!

[JayBee]

I complained about this months ago.

How can I run a database with duplicate Primary Keys?

Has anyone got a workaround for this?

[betdynamics]

Yes - it is a pain in the neck.

However, what I do is check to see if the runner already exists - if it does then I ignore it.

[bnl]

However, what I do is check to see if the runner already exists - if it does then I ignore it.

Or even better - handle the duplicate_key exception your db gives you.

Transaction.Start;
  begin
    Market.Insert;
  exception
    when duplicate_key => log_and_ignore;
  end;
  
  for Runner of Runners loop
    begin
      Runner.Insert;
    exception
      when duplicate_key => log_and_ignore;
    end;
  end loop;  
Transaction.Commit;

Or look at MERGE


/Björn