🚀 go-pugleaf

Dear Romain,

  Thank you for the second time you have been able to solve a problem for me.
Your
SQL solution was the only one that worked. I think its time you wrote a book
on  Visual Dbase.

Thanks Again,
Bob Knapp

Romain Strieff [TeamB] wrote:

> In article <35ED6C73.CA7B92E@erols.com>, nectel@erols.com grudgingly
> admits...
> >
> > This command works fine from dbase :
> >
> > UPDATE  DATA1.DBF  SET VALUE1 = '1000'  WHERE  VALUE2 = 'TEST'
> >
> > All VALUE1 occurances are changed to 1000 when VALUE2 is equal to TEST.
> >
> > 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.
> >
> >
> &Macro the whole line.
> cmd=[UPDATE DATA1.DBF SET VALUE1=']+TEMP1+[' WHERE VALUE2=']+TEMP2+[']
> &cmd.
>
> --
> Romain Strieff [TeamB]