Database

[Category("Date Info"),Bindable(true)]
public string Date
{
	get
	{return this.dateString;}
	set
	{this.dateString = value;}
}

this.datePicker1.DataBindings.Add("Date",this.dvDataSource,"Birthday");

this.BindingContext[this.dvDataSource].RemoveAt(this.BindingContext[this.dvDataSource].Position);

this.BindingContext[this.dvDataSource].AddNew();

1.  Thread 1 begins tran and select [record 123] (I presume a X-lock *Exclusive lock* is acquired)<br />
2.  Thread 2 begins tran and *attemp* to select [record 123] (but must wait before select comes thru because Transaction Isolation is set to Serializable -- ie. pessimistic -- I presume Thread 2 is also trying to acquire X-lock at this time but need to wait)<br />
3. Thread 1 commit updates on [record 123]<br />
4. Thread 2 select on [record 123] comes thru <br />
5. Thread 2 update<br />
6. Thread 2 commits update<br />

<br />
   1.  Thread 1 begins tran and select [record 123] (I presume a S-lock *shared lock* is acquired)<br />
   2.  Thread 2 begins tran and select [record 123] and it comes thru (Thread 2 also acquire a S-lock at this point)<br />
   3. Thread 1 commit updates on [record 123 \ file updated: firstname] (Thread 1 acquired a U-lock *update lock* at this point)<br />
   4. Thread 2 commit updates on [record 123 \ file updated: lastname] (CAUTION: firstname commited by Thread 1 overwritten by Thread 2 at this time) (Thread 2 acquired a U-lock *update lock* at this point)<br />

<br />
    Dim objRs As ADODB.Recordset<br />
    Set objRs = New ADODB.Recordset<br />
<br />
    Or Dim Objrs As New Adodb.Recordset<br />
<br />
    objRs.Open "users", objConn, adOpenKeyset, adLockOptimistic, adCmdTable