I want to update a field to reflect a new value in the record, I'm currently using a statement that looks like this:

"Update * From table_name"

However I'm missing something because I get an error that says syntax error.

Can you help me out with this?

Thanks
PinkPanther