Message
From
30/03/2000 13:04:29
To
30/03/2000 12:07:45
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00352784
Message ID:
00352832
Views:
16
Which table is selected, table1 or table2?
The FOR is scoped to the table in the current work area
Make sure you selec table2 first.
>I am trying to replace fields from one table to another. >
>It works for one record but the other 2 where the condition "table1.field5 = table2.field5 AND table1.field6 = table2.field6" is true are not being updated. Thanks in advance.
The FOR is scoped to the table in the current work area
Make sure you selec table2 first.
>I am trying to replace fields from one table to another. >
>It works for one record but the other 2 where the condition "table1.field5 = table2.field5 AND table1.field6 = table2.field6" is true are not being updated. Thanks in advance.
Peter Franz