Ismael
|
| Posted: 08/09/2003, 4:05 AM |
|
Hi:
I newby in codecharge and I create a custom update but when I update one record, the custom update duplicate the same data in all the records of the table. Why?
Regards
Ismael
|
|
|
 |
glerma
|
| Posted: 08/09/2003, 3:31 PM |
|
The reason is because if you did a custom update, you probably did not specfify the where clause of the update.
Example if your Custom Update was to update
Field 1 of Table 1
Then the SQL generated would update ALL of the fields because you did not specifiy
the criteria for which column to update.
Make sure to specify which control (Bottom box of your Custom Update Window) to use for your where clause.
Regards,
george
|
|
|
|
|
