Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2010
    Posts
    1

    Unanswered: Problem Multiple User Single Table insertion !!!

    I hv a table on server where in i have a field say TNO varchar2(10) which is auto-number with data T001, T002, T003 and so on...

    Now problem is when 2 user adds data 1 can insert and other gets error may b coz both read same data nd try 2 insert same record...How can i achieve this ?? is there any lock or smthing tat can help me or any kind of help will be appreciated.....

    Thanks in advance...

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Several things:
    varchar2 is not a SQL Server data type.
    That's no autonumber - it's text. I assume you have written custom code to generate these? If so then your inserts must now be serial and your problem is it sounds like your application is releasing a lock on the table before inserting allowing another thread to generate the same "autonumber".

    We'd need more detail (including your RDBMS, which I suspect is Oracle) before proceeding.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Cross posted here, with some "interesting" comments:
    Help needed for data insertion by multiple user !!! - VBForums

Posting Permissions

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