Interesting lookup processing
John Esak
john at valar.com
Wed May 6 23:36:50 PDT 2009
Sorry, the book is "Dealers In Lightning" not "Dealers In Lighting" :-) If
you get the latter, you'd probably learn how Home Depot was started... :-)
John
> -----Original Message-----
> From: filepro-list-bounces+john=valar.com at lists.celestial.com
> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
m] On Behalf Of John Esak
> Sent: Thursday, May 07, 2009 2:19 AM
> To: mschw at athenet.net
> Cc: filepro-list at lists.celestial.com
> Subject: RE: Interesting lookup processing
>
> Mike,
> I have been doing this code since the first day I ever programmed in
> filePro... Don't you do this....
>
> Lookup npio=npio ... ...
> Not npio
> Lookup npio=npioarchive ... ...
> ...
> ...
>
> Why would you think this wouldn't work. The first lookup
> fails, it is not
> active, period. So the next lookup is done.... Etc.
>
> Incidentally, I'm not kidding about using this since the
> first time lookup
> was ever release with the r=free option. Like this...
>
> Lookup there=file k=25 i=N -nx
> Not there
> Lookup there=file r=free
> There(2)=this and that... Etc.
>
> If a rcord isn't there already... Make one and keep the
> processing after
> that the same. In other words if the record exists, update
> it, if it isn't,
> create it first and then hpdate it as if it was there... :-)
> With the
> incedibly complex code you've worked on in your career 'm
> really surprised
> you never saw this ubiquitous construction.
>
> John
>
> P.S. By the way, I'm not saying I thought this construction
> up... It was
> just always there... I's probably a Ken or a Dave or even a Howie....
> Rmember, I had the luxury, honor, luck to be working at the
> company where we
> were thinking up this filePro program day by day from scratch. Nancy
> Palmquist, myself and a couple others joined when Ken, Dave,
> Howie, and
> Barry Wiseman were making do when lookup could not actually change the
> fields in a looked up file. In fact when Dave Roeger wrote
> that code ... So
> that lookup could actually "post" to aa looked up file... He
> decided to call
> it "dreport" in stead of "report"... Then all the "d" tools
> happened in
> pretty quick cuccession. This was a time, when one could
> literally walk
> into the programmers room (at say 2pm) where Ken, Dave and
> another one or
> two guys would just put something you needed into the code on
> the spot.
> "Hey, I need it to do this..." They would think for a second
> and then say,
> oh, good idea, but how about if it worked this way... You
> would usually end
> up saying.. "Oh, that's even better!" The 4pm version of the
> program would
> have it in there. Two days later, it would have 5 options and
> be documented.
> 1984 ws not only an amazing book only titled only 30 years
> too early... It
> was an absolutely amazing time to be working in the personal computer
> industry at its dawn... When Macintosh wasn't even a gleam...
> When IBM was
> the only way to go.. And they were making mistakes like
> buying operating
> system licenses from Microsoft instead of just buying the
> company outright.
> Within the next decade, Microsoft actually became *bigger*
> than IBM... And
> on and on....
>
>
> Of course, it was all started at AT&T and even more so at
> Xeroc PARC. Like
> I have said over and over again here. It's a little earlier
> by 10 years, but
> get a hold of the book "Dealers In Lighting"... You will not
> be able to put
> it down, and you will be flabberghasted as to how the things
> you use ever
> minute of your life were invented.
>
> John
>
>
> > -----Original Message-----
> > From: filepro-list-bounces+john=valar.com at lists.celestial.com
> > [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
> m] On Behalf Of Mike Schwartz
> > Sent: Wednesday, May 06, 2009 10:49 PM
> > To: 'filePro Mailing List'
> > Subject: Interesting lookup processing
> >
> > I was looking at some programs written by another
> > programmer over 10
> > years ago, and ran into this code that I didn't think would
> > work reliably,
> > but it has for over 10 years now:
> >
> > -----
> > :
> > lookup INVEN K=2 (blah, blah)
> > -----
> > Not INVEN
> > Lookup INVEN = ARCINVEN k=2 (blah, blah)
> > -----
> > :
> > 3=INVEN(4)
> > -----
> >
> >
> > I would have bet, internally, that filePro would get
> > confused by the
> > "dual" use of the word INVEN, especially if one part was
> > found in the active
> > inventory file and the next part was found in the archive
> > inventory file.
> >
> > Is this something that potentially could be causing
> > problems, or is
> > this perfectly legitimate code?
> >
> > Thanks,
> >
> > Mike Schwartz
> >
> >
> >
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> >
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
More information about the Filepro-list
mailing list