change a field value

From: Helen123 (Helen123_at_discussions.microsoft.com)
Date: 09/28/04 

Date: Tue, 28 Sep 2004 09:29:02 -0700

I have a table with three fields, they are "aminchar","sortorder" and
"specialwt". The field "specialwt"'s value was empty. Now i want to change
its value based on the "aminchar" and "sortorder"'s value. I did the
following code:
specialwtvalue=str(10-Len(aminchar))
INSERT INTO sortorde (specialwt) VALUES ([specialwtvalue])
=TABLEUPDATE(.T.,.F., 'sortorde')

The specialwtvalue is "7" or "8", but it only accept "specialwtvalue" like a
string, not accept its value in second sentence "INSERT INTO....
VALUE([specialwtvalue]). I don't know how to pass the value of specialwtvalue
to it. Any suggestion, thanks!

Loading