I am making a program that uses dbase 4 to handle the database. The program is networked and it is possible that more than two workstation will be running the same program and at the same time add, edit or delete records on the database.
I have some problem with the index of the table. I have a table with the employee records and another table that records the log of each employee. Everytime the employee will time in, it is recorded on the log table. One of the field of the log table is the empno which is the primary key of the table in order to know which employee has time in. I am using a master-detail relationship where the employee table is the master while the log table is the detail (They are connected using the empno field). I noticed that some employee name would share the same record on the log table even if they don't have the same empno. If I choose a certain employee, all the records on log whose empno is the same with the empno I choose on the employee table would appear. But when I click another employee, the record on the log would still appear even if it doesn't have the same empno. I tried to delete the index and place it back using the Database Desktop and after that the problem would be gone. Why does this happen? How do I solve this so I don't need to use the Database Desktop to delete and place the index back? How do I reindex the table during runtime? Would it be fine if I reindex the table even if it is shared by the other workstation?
By the way, I already set the localshare to true under the BDE Administrator on the Init tab.
I hope somebody can help me. Thanks in advance.
Carlo
I have some problem with the index of the table. I have a table with the employee records and another table that records the log of each employee. Everytime the employee will time in, it is recorded on the log table. One of the field of the log table is the empno which is the primary key of the table in order to know which employee has time in. I am using a master-detail relationship where the employee table is the master while the log table is the detail (They are connected using the empno field). I noticed that some employee name would share the same record on the log table even if they don't have the same empno. If I choose a certain employee, all the records on log whose empno is the same with the empno I choose on the employee table would appear. But when I click another employee, the record on the log would still appear even if it doesn't have the same empno. I tried to delete the index and place it back using the Database Desktop and after that the problem would be gone. Why does this happen? How do I solve this so I don't need to use the Database Desktop to delete and place the index back? How do I reindex the table during runtime? Would it be fine if I reindex the table even if it is shared by the other workstation?
By the way, I already set the localshare to true under the BDE Administrator on the Init tab.
I hope somebody can help me. Thanks in advance.
Carlo
