I am new at database programming and I am using vb6 and trying to update a record in an oracle db, but I cannot seem to find out how to set the where clause to be equal to the record. The update statement updates all the records to the one that is supposed to be the last record. I loop through two control arrays to get my values and then execute the ssql. Please help??? Here is my loop:


For ncounter = 0 To 9
nMonth = Int(txtMonth(ncounter))
nDay = Int(txtDay(ncounter))
ssql = "UPDATE tgirdba.holiday SET month= ' " & nMonth & " ' , " & "day= ' " & nDay & " ' " & "WHERE ?????????"
cnInjury.Execute (ssql)
ssql = ""
Next ncounter

Thanks in advance!!
Heidi