I am totally confused
I am trying to select one particular record from a table, based on an integer variable, which happens to be the primary key for the table namely Prototype_ID
I then want to update a column in that record namely Occurances by one.
I know how to select say the first row of a table using s.ExecuteQuery and then I use 'MYCURSOR' and update the column Occurances
But when I try to select a record using the predetermined integer variable with a PreparedStatement 'MYCURSOR' is not found
I am not understanding the differences here