Can filepro do drill downs like acess?
John Esak
john at valar.com
Thu Mar 25 21:28:22 PST 2004
>
> On Thursday 25 March 2004 14:13, Tony Freehauf wrote:
> > can filepro do things that look like acces drill downs?
> > can we compete with this kind of programing?
> > thanks
> > old tony
>
>
> You can do DrillDown with straight filePro. The trick is to do a PUSHKEY
> "ENTR" just before the browse lookup then use WAITKEY to trap the
> keystrokes
> after the browse lookup exits. I kept track of which keys had
> been pressed
> in a dummy variable then looped back to the browse lookup with my dummy
> variable as the key. The biggest problem I had was some idiot
> pressing BREAK
> which WAITKEY doesn't handle. I asked fP to fix that several times and
> finally gave up and wrote a 'C' program (my first one) to simulate it.
Jerry is absolutely right. You certainly can do "drilldowns" in filePro.
However, his saying "The trick is..." is not quite right. There is no
"trick"... at least no specific one that I know of, to do a drilldown. I
have written hundreds of drilldown functions (and that is not an
exaggeration) of every flavor, type, need. etc. There is no particular way
of writing them. Mostly, any kind of drill down situation can be
accomplished with browse lookups quite easily. Sometimes you want to
remember (store) the keys from where you came so you can drill back up to
where you were, other times you don't want that functionality. Jerry must be
talking about some kind of special situation that he feels he needed WAITKEY
to implement. I'm not sure exactly what, but it is nothing special to do
with a drilldown situation that I know about.
And as for accounting in general, as Bill Vermillion said, it just matters
that you write your system in such a way that transactions can not be
changed, but rather modified with other transactions. Drilldowns have zero
to do with a well written application's functionality. So, to suggest as
some others in this thread did, that accounting should only be done with a
transactional committ/rollback database or whatever... well, sorry that is
simply preposterous. FilePro is MORE than adequate to the task of allowing
you to implement _really_ good accounting systems that fully and completely
follow GAP standards. Ours has been working for just about 18 years now with
full CPA certified audits many, many times. The only thing that has ever
been said by the auiditors is "Your accounting system is spectacular!". "We
have never seen an accounting system with so much detail and reports in so
many variations..." "How did you get this to print out this way?" and "Could
I buy this system somewhere?" etc., etc. So aside from doing something as
trivial as drilldowns, filePro is as I said, MORE than capable of letting
you implement any type of drilldown, and any type of accounting program you
can imagine.
You might check some old copies of The Guru, the fPDJ, Nancy's web site,
Stuart's book, and the FP Room for examples and guidance.
John Esak
Visit The FP Room www.tinyurl.com/yuag7 24/7
More information about the Filepro-list
mailing list