Jim Lawrence
accessd at shaw.ca
Sat Jan 26 13:57:27 CST 2013
Hi John: Right on; definitely the royal-jelly of tech work. My specialty is POS design and this database is one hundred percent mine, over twenty years of work, so I can blame no one else if everything does not work a hundred percent, every time. :-) Jim -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of John Bartow Sent: Saturday, January 26, 2013 11:33 AM To: 'Discussion of Hardware and Software issues' Subject: Re: [dba-Tech] database This is the stuff I love to do! But I will not fog the waters for you. -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Saturday, January 26, 2013 12:45 PM To: 'Discussion of Hardware and Software issues' Subject: Re: [dba-Tech] database Those were my initial thoughts but then there would be issues with inventory and the related accounting. Then there is the issues with whether a client ever had an unpaid invoice, a bankruptcy or even association issues that will a have to be rolled forward and records will still have to be flagged and situations noted. There is also the thresholds that may establish a client, supplier or even staff as "rated highly", "to watch" or "do not do business with" as incidents before the five year cut-off must be carried forward. Some inventory has been active for twenty years while other items not... Then there is the accounting, security and transaction files. Then there are the issues of how much should be carried forward, in summary files... The clients still wants to be able to chart activity even though it may have been rolled up to five years...setting averages, viewing trends, inventory/equipment quality, and so on. Then there has been a lot of bad practices, especially in the accounting where a series of book-keepers were suppose to manage things...now the company has a real Chartered Accountant...a breathe of fresh air. As you are an expert at business practices any thoughts and cautions would be appreciated? Jim -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Saturday, January 26, 2013 10:18 AM To: 'Discussion of Hardware and Software issues' Subject: Re: [dba-Tech] database Modifying the relationships to cascade delete? Rocky -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Saturday, January 26, 2013 10:02 AM To: 'Discussion of Hardware and Software issues' Subject: [dba-Tech] database Today and tomorrow I will be working on a huge database. It has records going back to the late eighties and the client wants the whole system cleared except for the last five years. Clearing data is not difficult but leaving no orphaned records is. There are over a hundred inter-related tables and I have been planning this with the client for a couple of months and today is the day (the company's year-end). Has any one else had similar experiences and any insights, recommendations and so on? Jim _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com