On Fri, Aug 27, 2010 at 1:56 PM, MB Software Solutions, LLC
<[email protected]> wrote:
> Richard Kaye wrote:
>> That's cause you still write Foxbase+ code... <vbg> We also have a STEP 
>> parameter if you want to increment by some value other than 1.
>
> Steve checked out of VFP dev back at version 5 or 6.  <gd&r>
---------------

6 to the start of 7 make that 6.5  ;->

Or I left a job that was in 6, and worked with FPDos again for 2-3
years in a keep it running mode while doing SQL Server Data Warehouse
work.

On hiring day I was told to NOT fix it.  That was the right thing to
say because the system was poorly designed and data was flat filed at
best.  Sure it took 5 years and up to 30 coders to replace it.  But
that replacement system has won numerous awards at Medical software
shows for Clinical Trials.

I had a table for blood tests and it had a column for just about each
one of these listed here.
<http://www.bloodtestresultsexplained.com/blood-test-abbreviations>

Replaced with a normalized system that only had rows for what the
Trial was interested with/in.  Usually 2, 4, or maybe 6 at most of the
values.  Having to give the data in my fox system to the
Biostatisticians took a lot of writing up rules for what they were to
expect for this trial vs that trial.  If it were normalized data they
would have seen 4 Types of values and a null was now real instead of a
0.

I learned a lot working next to the replacement team.  Why collections
of collections were a good thing and how to snapshot in time and be
able to store that so comparisons could be made across other patients
at similar points in treatment.


-- 
Stephen Russell

Sr. Production Systems Programmer
CIMSgts

901.246-0159 cell

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to