Re: change a field value

From: Jack Jackson (jacknospam_at_pebbleridge.com)
Date: 09/29/04

  • Next message: Leonid: "Re: Database views" 
    Date: Tue, 28 Sep 2004 21:57:11 -0700

    [specialwtvalue] is the same as "specialwtvalue" - it is a text
    string, not a variable. I think you want to remove the brackets:
    INSERT INTO sortorde (specialwt) VALUES (specialwtvalue)

    You say you want to change the value of specialwt. However, your code
    inserts a new record, it doesn't modify an existing record. Which do
    you want to do?

    On Tue, 28 Sep 2004 09:29:02 -0700, "Helen123"
    <Helen123@discussions.microsoft.com> wrote:

    >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!

  • Next message: Leonid: "Re: Database views"
    Loading