SQL Procedure Question

• OLanger

  Grasshopper

  Points: 13

  More actions

  November 13, 2002 at 12:42 pm

  #79865

  How can I handle an error in sql procedure if the data that is being fetched

  by the cursor is being inserted into a table which doesn't allowed duplicates. How can I recover from this error and fetch the next records that the cursor has.

  Thanks in advance

  

• November 18, 2002 at 8:00 am

  This was removed by the editor as SPAM

• David Burrows

  SSC Guru

  Points: 65138

  More actions

  November 19, 2002 at 5:14 am

  #441705

  Why not check if row exists in destination table before insert. This is what I do.

  Far away is close at hand in the images of elsewhere.
  Anon.

• philcart

  SSC-Forever

  Points: 47794

  More actions

  November 19, 2002 at 8:35 pm

  #441793

  You need to check the @@ERROR variable.

  Eg:

  
  
  fetch next from cur into @Var1
  
  while @@fetch_status = 0
  
  begin
  
    update table1 Set Field1 = @Var1
  
    if @@ERROR <> 0
  
      'issue message like "@Var1 could not be updated"
  
    fetch next from cur into @Var1
  
  end
  
  

  Thanks

  Phill Carter

  Edited by - phillcart on 11/19/2002 8:38:12 PM

  --------------------
  Colt 45 - the original point and click interface