-
1
- #1
I've been reviewing the clipper code of our programmer who has already left, and I could not see how he was able to update records of a different table.
The two tables involved are ITEMS.DBF and TRANSACT.DBF. ITEMS.DBF has fields CODE and DESCRIPTION, while TRANSACT.DBF has fields INVOICE, CODE and DESCRIPTION. Values of CODE and DESCRIPTION of TRANSACT.DBF are taken from the same field names of ITEMS.DBF. In ITEMS.DBF, when the DESCRIPTION is updated, somehow the DESCRIPTION of TRANSACT.DBF is also updated.
I suspect indices of tables created at the start of the program are responsible, but I could not see in the code how the two tables are connected.
I also studied the code for ITEMS.DBF on how it updates records using SELECT ITEMS, REPLACE ITEMS->DESCRIPTION WITH [value] commands, but nothing was mentioned about TRANSACT.DBF.
Sorry if what I'm describing is confusing. I'm also confused.
The two tables involved are ITEMS.DBF and TRANSACT.DBF. ITEMS.DBF has fields CODE and DESCRIPTION, while TRANSACT.DBF has fields INVOICE, CODE and DESCRIPTION. Values of CODE and DESCRIPTION of TRANSACT.DBF are taken from the same field names of ITEMS.DBF. In ITEMS.DBF, when the DESCRIPTION is updated, somehow the DESCRIPTION of TRANSACT.DBF is also updated.
I suspect indices of tables created at the start of the program are responsible, but I could not see in the code how the two tables are connected.
I also studied the code for ITEMS.DBF on how it updates records using SELECT ITEMS, REPLACE ITEMS->DESCRIPTION WITH [value] commands, but nothing was mentioned about TRANSACT.DBF.
Sorry if what I'm describing is confusing. I'm also confused.