Saving ((( ONLY 1 ))) Record with OLEDB

[James Rose]

I can understand not wanting to use an autonumber, for whatever reason, however ALL tables should have an identity field. (almost always!!)

Without the ident, you are going to be running the risk of many issues like this.

I tend to recommend using GUIDs as the ident, becuase if you ever need to deal with replication issues an autonumber field will cause problems.

Sorry, not the answer you wanted, but the answer you need.

[Elagizy]

Well, i tried update command but it makes recordS changes to ONLY 1 VALUE "Pcont".

as you see in the code, Pcont is increasing, i want to make each (1) record has a value of "Pcont"

Record No Pcont

Record 1 ----> 1

Record 2 ----> 2

Record 3 ----> 3

but when i use this code i found that , Pcont get the number of records and save it to ALL records ( which is filtered by WHERE A='" + Form1.DefInstance.Label8.Text + "'")

so i got this :

Record No Pcont

Record 1 ----> 3

Record 2 ----> 3

Record 3 ----> 3

While ProDR.Read
            PCont += 1
            Dim ProIns As New OleDbCommand
            ProIns.CommandText = "Update DDPro Set B='" + PCont + "'"
            ProIns.Connection = New OleDbConnection(ProConn.ConnectionString)
            ProIns.Connection.Open()
            ProIns.ExecuteNonQuery()
            ProIns.Connection.Close()
End While

in the command ( ProIns.ExecuteNonQuery() ) this returns the no. of rows affected , I want the opposite of this command, i want to return the 1ST affected row ONLY.

if i did it, i will be able to get that result :

Record No Pcont

Record 1 ----> 1

Record 2 ----> 2

Record 3 ----> 3

Any help please ?

[Elagizy]

I think that i found the command that returns the 1ST affected row ...

 ? ? ? ProIns.UpdatedRowSource = UpdateRowSource.FirstReturnedRecord

but It seems doesn't work with my cod:pinch:ch: , any body has idea how to use this command :( :(