1 2 3 4 5 6 7 8 9 10 11 12 13 14
|
Dim num As Integer
cmd.Connection = conn
cmd.CommandText = "SELECT MAX(INT_NUM_INT) from INTERVENTION"
cmd.CommandType = CommandType.Text
Dim dr As OracleDataReader = cmd.ExecuteReader()
num = CInt(dr.Read()) + 1
'MsgBox(num.ToString) --->>> cela renvoie 0 alors qu'il me faudrait 1 + MAX(INT_NUM_INT)
For i As Integer = 0 To Me.List_Intervention.Items.Count()
If intervention.CompareTo(List_Intervention.Items(i).ToString) Then
cmd.CommandText = "INSERT INTO INTERVENTION (INT_NUM_INT, INT_LIB_INT) values ('" & num & "','" & intervention & "' )"
cmd.CommandType = CommandType.Text
cmd.ExecuteNonQuery()
List_Intervention.Update() |