I did copy/paste to the last fragment and run it and the result was the same error..
I know it SHOULD work.. it was my first idea to do this but it doesn't work..
it does work on VFP9 but on VFP6 it does not
the result is the same with writing this:
UPDATE TableA SET Column2 = B.Column2 ;
FROM TableA as A ,TableB as B ;
WHERE A.Id = B.Id
an error message "Command contains unrecognized phrase/keyword
Tried it this way too - doesn't work
I got some help and managed to do it this way
REPLACE column2 WITH LOOKUP(tableB.column2,tableA.id,tableB.id,'id') ALL IN tableA
using index on tableB
But I will be glad to learn another way to do it too
Hello,
Im using FoxPro 6 and I have 2 tables, both with 2 columns. The first one (A)
has one column filled with ids and the second column is empty. The second
table (B) has also the same ids and its second column has some values. My
question is how can I insert the values from table B into...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.