disconnected recordset issue

• sukhoi971

  SSCarpal Tunnel

  Points: 4833

  More actions

  October 15, 2004 at 2:35 am

  #59628

  this is the most likely question asked in an interview

  i have one table in a database

  iam connecting it through vb using ado

  now iam using disconnected recordset

  and the table has one column called id, which is an auto number column,

  now when the 2 persons connect the dataserver and disconnect

  now both of them have 99 records,(there are total 99 records in the table)

  now each one make 1 entry in the  recordset, and the id column of both the clients rs will have 100,

  now at the time of updating, it will create a problem, what is the solution to this type of problem

  pls help in solving this issue, becoz they are going to ask me in an interview

   

   

  <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

  *Sukhoi*[font="Arial Narrow"][/font]

• rajiv-170183

  Ten Centuries

  Points: 1167

  More actions

  October 17, 2004 at 9:17 am

  #526988

  Hey sukhoi

  i too had the same doubt..

  but is n't there a concept called "concurrency"?

  i too dont know much....plz let me also know the solution to this pblm!!

  thanx

  Rajiv.