I am running on Windows and have FM Pro 10 Advanced.
I have 2 databases... Database A & Database B.
In Database A, I am acquiring data and storing it in Database B through scripts and Copy & Paste Commands. This is working well. My problem is, that I need to find out how many records occur during a certain time frame (lets say the last hour and the hour before that), and bring the total for each hour back into Database A for display purpose. This also needs to be updating every hour.
Any suggestions, would be greatly appreciated.