Duplicate records using uid

Results 1 to 2 of 2

Thread: Duplicate records using uid

  1. #1
    Join Date
    Dec 1969

    Default Duplicate records using uid

    I want to be able to code the follwoing error. If I have a person already registered under their uniquie identifier that is trying to reregister, instead of the duplicate primary key error, how can I code in a redirect that says you&#039;ve already registered this uid???<BR><BR>Thanks!<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Duplicate records using uid

    Hmmm...you can select using the unique id and see if it returns any values, and if not, then submit. You can actually do that inside of a stored procedure and have the stored procedure return success in an output parameter. You can try to use On Error Resume Next to maybe capture the error.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts