Well, Quiz vs VB6 App..
I use Access/VBA for development, so far I use Power House tools too.
I have couple of a cosmetic change on old Quiz report..
1. The Quiz report , omit a printing format portion, make some change on QUIZ
to make a Subfiles instead of a report
2. Link the Subfiles in HP3K, use MS Access with ODBC/32 and Schema Editor
3. Now, a user right click on a data sheet form field(base on HP3K Files), make a some sort or filter from MS Access form(DS), or Excel Wizard (development base on old Information Access) to copy a "what if" selection on a HP3K files to an Excel work sheet.
HP3k/IMAGE/Quiz is fast, reliable and fast development
VB or VBA is pretty(GUI), user friendly and compatibility
I use Access VBA, fast turnaround with development package to deploy.
One of saving tip so far I found is, run Access Query wizards create a Query,
turn around to SQL statement and Cut and Paste to VB/VBA SQL statement,
It save most my time.
C "HP3K" to "eHP3K" in all
Peter C.
We use Powerhouse, so as a test I wrote a VB6 app to import data to an
access database, and I wrote the same process in Powerhouse. I had a 15 to
one reduction in code (Quiz vs. VB6). The VB6 app was pretty lean, and did
well on the update. It took 5 hours to write the VB6, and code 20 minutes
to write the Quiz code (using indexed sub files).
What is the saying, Do the Math...
I wonder, has anyone else had similar results or are my VB skills too weak?
Both process take 10 to 15 minutes to process about 180,000 records, but one
is very easy to maintain.
The access file in on a PII, 233; the quiz is on an HP300 987/200...
mc
Mike Church
Technical Support Manager
Information Services
Our Lady of Bellefonte Hospital
Saint Christopher Drive
Ashland, Kentucky 41101
-----------------------------------
Phone : (606)833-3727
Fax : (606)833-3342
-----------------------------------
Alternate e-mail : [log in to unmask]
-----------------------------------
MY URL: http://members.tripod.com/mike_church/
OLBH: http://www.olbh.com
-----------------------------------
Daily Quote: What can be done with fewer ... is done in vain with more. --
William of Ockham
-----Original Message-----
From: Wayne Brown [mailto:[log in to unmask]]
Sent: Friday, March 31, 2000 10:35 AM
To: [log in to unmask]
Subject: Re: HP3000 'old timers league' qualification test:
Unless, of course, you're going in the wrong direction. Then turning around
and
going back is the most sensible thing to do.
(I'm not saying this is the case with the 3000. But there are other areas
in
which HP needs to get back to its roots.)
Wayne
"F. Alfredo Rego" <[log in to unmask]> on 03/30/2000 09:17:39 PM
Please respond to "F. Alfredo Rego" <[log in to unmask]>
To: [log in to unmask]
cc: (bcc: Wayne Brown/Corporate/Altec)
Subject: Re: HP3000 'old timers league' qualification test:
Gavin Scott <[log in to unmask]> wrote:
>The problem with the 3000 world these days is that it's old and stagnant
>enough that virtually *everyone* is an "old timer" to one degree of
another.
>What we need in the 3000 community are more new users who *don't* know the
>answers to trivia questions.
Well written! It is always fun to look at the rear-view mirror, of course.
But that will not get you anywhere. It is vital to turn the headlights on
(if necessary) and to look AHEAD.
_______________
| |
| |
| r | Alfredo [log in to unmask]
| e | http://www.adager.com
| g | F. Alfredo Rego +1 208 726-9100
| a | Manager, R & D Labs Fax +1 208 726-2822
| d | Adager Corporation
| A | Sun Valley, Idaho 83353-3000 U.S.A.
| |
|_______________|
|
