>I'm trying to build a query which will update one table with values from another, matching on primary keys. It's very simple in ACCESS using an INNER JOIN with an UPDATE. I haven't been able to get it to work in VFP. Can it be done?
>
>Thanks!
Nope.
What can be done, though, is to use a SET RELATION between the tables and a REPLACE ALL. This works very fast.
e.g. This will update the UpdateMe table from values in SourceTable
where the primary keys match.
Use SourceTable Order idPK
Select 0
Use UpdateMe
Set Relation To idPK Into SourceTable
Replace All field1 With SourceTable.field1, ;
field3 With SourceTable.field2, ;
etc., etc. ;
For !EOF("SourceTable")
Insanity: Doing the same thing over and over and expecting different results.