I am encountering an odd problem and could sure use some insight.
I'm rewriting one of our older web applications in order to add more functionality. I have a form to add, edit and delete sales orders. Adding and deleting orders work great but I have an odd problem when editing.
- Users can edit the header information with no errors.
- Adding a new line item? No problem.
- Change the stock item, quantity or description for a line item - piece of cake.
But if a user deletes a line item the process can take several minutes to complete. And of course if the user tries to resubmit the change they receive a Btrieve error 84 because the record is locked. It is obviously working but I don't understand the lag when deleting a line item from a sales order. I'm almost certain this behavior is the source of some other odd problems we had with the original app I'm currently revamping.
Also note that our company file size is very large, ridiculous actually, so I'm sure that's probably amplifying my troubles.
Thank you.
