I apologize if this question is not supposed to be in this forum, but since I am using Foxpro to do it, I thought I would ask...
I am trying to create a program in which I can log many system and user events, such as if the user deletes a Customer or how many customers have logged into the program in the last hour, etc.
How does one go about designing a database for this? I am sure there are many links and sites on this, but I thought I would ask here if someone has already done it and could give me a clue.
And are triggers easy to work with in Foxpro 8.0? I was thinking about just using a global class that could be used to log events anytime during the program.
Any thoughts would be greatly appreciated! Thanks!
I am trying to create a program in which I can log many system and user events, such as if the user deletes a Customer or how many customers have logged into the program in the last hour, etc.
How does one go about designing a database for this? I am sure there are many links and sites on this, but I thought I would ask here if someone has already done it and could give me a clue.
And are triggers easy to work with in Foxpro 8.0? I was thinking about just using a global class that could be used to log events anytime during the program.
Any thoughts would be greatly appreciated! Thanks!