![]() ![]() ![]() So, what does it mean to delete a record in a robust database system? Let’s use this simple FileMaker Invoice table with line-item records as an example.Īs you can see, there’s nothing exceptional about this interface and it should be fairly familiar. In order to prevent such mistakes in the first place, it’s important to understand what it means to delete a record and to establish good business-rules as a foundation to your system. Unfortunately, some of the biggest database administrative headaches we’ve seen are a result of careless DELETE actions, and the removal of important data from a system. We've seen a lot of cases where developers put most thought into how records are added and retained, how data is modeled, and how data will link in a dynamic way - but not much thought is put into the removal of data from the system, and the consequences that might follow. All of our users are savvy, and all of their actions are intentional. When we envision data management solutions, we tend to think of perfect-use scenarios, where no one ever creates a duplicate record, no one accidentally hits the New Record button, no project is ever canceled, and certainly no errant script accidentally miscopies data. JEdited on SeptemUnderstanding the larger issues surrounding the Delete Button
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |