That awkward moment when you realize the code you have been debugging for an hour actually works fine and updating the entire dataset. You've just been returning only the top 1000 rows.

had this yesterday. queried sql for data, put it into the dictionaries i need, but as it turns out, i was assigning my out values to my properties before getting the data - effectively getting null when i called my properties later.
i love reading about other peoples' brain farts. helps keep the ol' impostor syndrome in check :)

@ArcaneEye man imposter syndrome is the number one killer of confidence