Message
From
30/03/2000 12:26:37
To
30/03/2000 12:07:45
General information
Fórum:
Visual FoxPro
Category:
Bases de dados, Tabelas, Views, Indices e SQL
Título:
Miscellaneous
ID da thread:
00352784
ID da mensagem:
00352800
Views:
22
>I am trying to replace fields from one table to another. There are 3 records where the condition exists for replacement, however, only one replacement is being done. My table that is being written to has data buffering of 0. Here is the psudo-code:
>
>
>REPLACE table2.field1 WITH table1.field1, ;
> table2.field2 WITH table1.field2, ;
> table2.field3 WITH table1.field3 ;
> FOR table1.field5 = table2.field5 AND ;
> table1.field6 = table2.field6
>
>
>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.
Are these two tables related with SET RELATION and you're in TABLE1 while doing your replace?
>
>
>REPLACE table2.field1 WITH table1.field1, ;
> table2.field2 WITH table1.field2, ;
> table2.field3 WITH table1.field3 ;
> FOR table1.field5 = table2.field5 AND ;
> table1.field6 = table2.field6
>
>
>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.
Are these two tables related with SET RELATION and you're in TABLE1 while doing your replace?