Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    35

    concurrency issues

    Hi,

    I have an MySql database and six users who access the database via a Delphi front end. The users need to download a copy of the db, make modifications, then upload. The question is that when they add a record (which will increment the customerID for example) and upload it how can I take care of the issues of having multiple records with the same ID number and thus causing an error.

    Many thanks,

    Jo

  2. #2
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Generally you give each user a unique valid range of customerIDs. User 1 has values 1 to 1000, User2 values 1001 to 2000 and so on. In this way you can avoid the conflicts you are encountering.

    Best I can come up with for this problem.

  3. #3
    Join Date
    Sep 2003
    Posts
    35
    Hi Certus,

    Many thanks for the help, it seems the most logical way forward and easy to implement.

    Many thanks

Posting Permissions

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