Re: 3523 .... lots of issues
Thanks Ira... you have helped me many times and i really appreciate it.
1) yes i am referring to dbf tables. i'm not sure if a pack is being carried out or if the record is being changed. The delete_record-duplicate_record may in fact be a change_record_to_an_existing_record problem.
in any case when i try to undelete the record, it is not there to undelete.
it is most likely that the problem is occurring during data entry on a form based on a set with 1:many relationships. But it is not a particular form. The problem occurs in the Consultants, Orders, Customers, and Orderpayments tables. There are a number of sets with associated forms for these tables.
2) indexes are being corrupted and this may be part of the problem. The index corruption seems to be happening when i copy the 'application files' from my development version to the production application. However i always perform a reindex and compact immediately after updating the application.
i have noticed that occasionally a form based on a set with 1:many relations will display incorrect associations but a reindex always sets things right.
The fact that this index corruption is happening more often and is at least correlated with the 'delete/change record' problem may be at pointing towards the solution... don't know how to follow this up though!!??
3) "10 for 1, 4 for the other" i meant to say "10 years problem free for one application and 4 years problem free for the other.
4) the applications are running on a network using shadow copies. I refresh the shadows every time i update the application.
However, it is very rare for more than one person to be using the database at the same time. When more than one person is using the database the max number is 3 simultaneous users and more often 2. They are all using the same version of A5V10 Run Time.
5) i am interested in obtaining consultant help but i was hoping to have a more defined problem to present. As a consultant myself i know how difficult it can be to be faced with a problem that is described as 'it doesn't work... fix it!"
Thanks for your guidance!
D
Thanks Ira... you have helped me many times and i really appreciate it.
1) yes i am referring to dbf tables. i'm not sure if a pack is being carried out or if the record is being changed. The delete_record-duplicate_record may in fact be a change_record_to_an_existing_record problem.
in any case when i try to undelete the record, it is not there to undelete.
it is most likely that the problem is occurring during data entry on a form based on a set with 1:many relationships. But it is not a particular form. The problem occurs in the Consultants, Orders, Customers, and Orderpayments tables. There are a number of sets with associated forms for these tables.
2) indexes are being corrupted and this may be part of the problem. The index corruption seems to be happening when i copy the 'application files' from my development version to the production application. However i always perform a reindex and compact immediately after updating the application.
i have noticed that occasionally a form based on a set with 1:many relations will display incorrect associations but a reindex always sets things right.
The fact that this index corruption is happening more often and is at least correlated with the 'delete/change record' problem may be at pointing towards the solution... don't know how to follow this up though!!??
3) "10 for 1, 4 for the other" i meant to say "10 years problem free for one application and 4 years problem free for the other.
4) the applications are running on a network using shadow copies. I refresh the shadows every time i update the application.
However, it is very rare for more than one person to be using the database at the same time. When more than one person is using the database the max number is 3 simultaneous users and more often 2. They are all using the same version of A5V10 Run Time.
5) i am interested in obtaining consultant help but i was hoping to have a more defined problem to present. As a consultant myself i know how difficult it can be to be faced with a problem that is described as 'it doesn't work... fix it!"
Thanks for your guidance!
D
Comment