"Update Tracking Set Return = Return + 1"

Doesn't work in code, although it does work from admin!

Syntax error near "Return = Return + 1"

I am sure it is because of "Return" self reference, but how can I do this?

If you're using mySQL, it's probably because "Return" is a reserved word. Rename the field something other than Return

http://dev.mysql.com/doc/refman/5.0/...ved-words.html

DOH! uh yup, uh yup, figured that out after taking a break and shedding some code blindness! Thx.