Hello. I�ve been tinkering with many versions of Alpha4/5 over the years and have created and used several fairly basic databases at work and home. I�m somewhat familiar with tables, sets, field rules, forms, reports, and a few other aspects of A5. I have very limited knowledge/usage of A5 application, scripting, or programming functions, in general.
I�m currently using A5v7 and recently purchased a WAS license. I�d like to start getting a little more serious with A5 and learn what I need to develop a database application that will allow the analyzing of eleven years (and counting) worth of weather data. Currently, I�ve imported this data (about a half-million records) into both yearly tables and a �all-records� table.
Not being familiar enough with the application and programming side of A5 I�m having a difficult time deciding on a good approach for table/database design and what functions, scripting, etc. to start learning and experimenting with.
Generally, what I will want to do is define routines that will identify extremes, averages, trends, and etc. for all-time, yearly, monthly, daily, and miscellaneous periods. Having experimented with calculating some all-time and monthly high and low temperatures on a form, and seeing how long many of these calculations will take, I�m guessing I�ll probably want various tables that will store these calculations and then can be easily compared and updated over time.
Any ideas out there what design direction might be a good one and what A5 functions, commands, and etc. that I�ll want to start with?
Thanks in advance!!!
I�m currently using A5v7 and recently purchased a WAS license. I�d like to start getting a little more serious with A5 and learn what I need to develop a database application that will allow the analyzing of eleven years (and counting) worth of weather data. Currently, I�ve imported this data (about a half-million records) into both yearly tables and a �all-records� table.
Not being familiar enough with the application and programming side of A5 I�m having a difficult time deciding on a good approach for table/database design and what functions, scripting, etc. to start learning and experimenting with.
Generally, what I will want to do is define routines that will identify extremes, averages, trends, and etc. for all-time, yearly, monthly, daily, and miscellaneous periods. Having experimented with calculating some all-time and monthly high and low temperatures on a form, and seeing how long many of these calculations will take, I�m guessing I�ll probably want various tables that will store these calculations and then can be easily compared and updated over time.
Any ideas out there what design direction might be a good one and what A5 functions, commands, and etc. that I�ll want to start with?
Thanks in advance!!!
Comment