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.....
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.