David,
>UPDATE-SQL doesn't seem to work with properties. For example, the following creates an error that TEXTLASTNAME isn't found.
The other gave you the workarounds, the reason it fails is that when the SQL executes your object is not "really" in scope even though you are inside the method, it's pretty annoying but the workarounds are easy to do.