I am attempting to update a power table from my client that is connected to a SQL database. I have a query that seems to be working, but I am pretty sure it is just setting the values to what they currently are. Every time I attempt to change a value in a cell it just returns to its old value. Here is my query:
Set DirtyWeight = :DirtyWeight, Rock = :Rock, SampleNumber = :SampleNumber, Tops = :Tops, Mud = :Mud, Trash = :Trash, RDS = :RDS, AppPURITY = :AppPurity, PctTare = :PctTare, PercSugar = :PercSugar, POL = :POL, CleanWeight = :CleanWeight, BeetCount = :BeetCount, NScalped = :NScalped, Rocks2 = :Rocks2, RootRot = :RootRot
WHERE SampleNumber = :SampleNumber
AND SeqID = :SeqID
Any ideas to set new values to my cells through a similar update query?