the logfile routine on the filePro Addendum CD
John Esak
john at valar.com
Tue Nov 8 19:56:48 PST 2005
JP brought to my attention (weeks ago) that there is an error in one of the
chapters on the first filePro Addendum CD. It is in the 6th movie unde the
Chahpter called "Tracking Field Level Changes.. <in your filePro records>"
I am showing a final modification to the mini-app that will speed up the
procedure a thousand fold. I show how to build a 1 element array over the
current file and the clone file, and say that you need to build this array
for a size of 429 characters, and it should be 409 characters. I mumbled
something about adding in the 20 byte header to the size of the array.
Rompletely ridiculous... do not do this when designing your own version of
this program... or copying it into your systems. The array should be built
for the total size of the file, not the total size plus the 20 byte
invisible header. I have no idea what possessed me to say and do that during
that movie. Chalk it up to old age, being stupid... who knows. Not only did
I say to do this... but it slipped past my rigorous personal testing of the
CD (and that of a couple other helper-people, too... so I don't feel SO bad.
:-)
In any case, the routine is extrememely useful, so give it a try.
We live and die by the results of this mini-app at my place. Fifty users all
saying they didn't make that particular change to the Order File or Customer
File, or any file... and we've got 'em dead to rights. All is disclosed if
you keep precise logfiles of every single change made to any filePro file,
with date, time, user-name, the field they changed and what the field used
to be before and after they changed it. This is just a must-have for any
filePro administrator... and it's a simple few lines to add to any INPUT
table.
Take care, and sorry for the error.
--
John Esak
(570) 384-2444
Author of:
The filePro Survivor Series
Complete Video Training For FilePro On CD
See samples at: www.valar.com/training
More information about the Filepro-list
mailing list