🚀 go-pugleaf

Try,

UPDATE DATA1.DBF SET VALUE1=" + TEMP1 + " WHERE VALUE2=" + TEMP2 + "

the last + " might not be needed.

--
Christopher F. Neumann

"Failure is not an option!"


Bob Knapp <nectel@erols.com> wrote in message 35ED6C73.CA7B92E@erols.com...

>I am trying to perform the UPDATE function with SQL in dbase 7.01. What
>I would like to do is replace all values in a field when a match is
>made.
>
>The problem is this: In the real world '1000' and 'TEST' are being sent
>in as variables and changed all the time.
>
>If I set these values to variables it won't work .  ie. TEMP1 = '1000'
>,  TEMP2 = 'TEST'
>
>        UPDATE DATA1.DBF SET VALUE1=TEMP1 WHERE VALUE2=TEMP2
>
>
>I  even tried to use &TEMP1 and &TEMP2 as well as '&TEMP1' and '&TEMP2'.
>
>Nothing seems to work and there is little or no information on how to
>use SQL with a variable replacement.
>
>What is the secret syntax, or does visual dbase not support common SQL
>language.