Extracting data from a PHD
John Backus
john@beechglen.com
Wed, 7 Nov 2001 09:36:45 -0500
This is a multi-part message in MIME format.
------=_NextPart_000_0119_01C1676F.B7132300
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Extracting data from a PHDHi,
Perhaps either of the two tools mentioned below could be=20
used or adapted for your use...
At BEECHGLEN.COM under 'Freeware', can be found=20
some Powerhouse development tools.
QZEZPRT, just one Quiz module, creates Query like=20
listings of any files available to Quiz's ACCESS statement.=20
Another single module, QZREPORT, outputs flat files that have
Quiz or Qtp code to give you a headstart on report or subfile
creation as well as creating code that can be used to generate
delimited ASCII files.
In each set there is a 5.06, 7.09 and a 7.29 version.=20
Note: the newer versions do have some added functionality. I=20
think that the 7.29 version works under Quiz 8.?? too. If you=20
find that it does not, you could easily adapt the code quite=20
easily. Each step is documented and the whole thing is driven=20
by the primary input which is the output of a "show items"=20
statement in QUIZ.
I do not claim the code to be the most elegant or readable, but
hey, it is free, safe and it works. Be sure to read the comments
that are made in the beginning section of each program.
To get these tools, just copy and paste into your favorite=20
editor. Note though that Editor.pub.sys will have problems with=20
the '&' (continuation) character. If Editor is all you have,=20
perhaps copy & paste into Word, change the '&' to a placeholder
like a '%%' (percent) character as an intermediate step. When=20
you have the file on the HP, change '%' to '&'.
Courtesy of Beechglen Development, Inc.,
John Backus
beechglen.com
(513) 922-0509
------=_NextPart_000_0119_01C1676F.B7132300
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Extracting data from a PHD</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4616.200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hi,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Perhaps either of the two tools mentioned below =
could be=20
<BR>used or adapted for your use...</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>At BEECHGLEN.COM under 'Freeware', can be found =
<BR>some=20
Powerhouse development tools.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>QZEZPRT, just one Quiz module, creates Query like =
<BR>listings=20
of any files available to Quiz's ACCESS statement. <BR>Another single =
module,=20
QZREPORT, outputs flat files that have<BR>Quiz or Qtp code to give you a =
headstart on report or subfile<BR>creation as well as creating code that =
can be=20
used to generate<BR>delimited ASCII files.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>In each set there is a 5.06, 7.09 and a 7.29 =
version.=20
</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Note: the newer versions do have some added=20
functionality. I <BR>think that the 7.29 version works under Quiz =
8.??=20
too. If you <BR>find that it does not, you could easily adapt the =
code=20
quite <BR>easily. Each step is documented and the whole thing is =
driven=20
<BR>by the primary input which is the output of a "show items" =
<BR>statement in=20
QUIZ.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>I do not claim the code to be the most elegant or =
readable,=20
but<BR>hey, it is free, safe and it works. Be sure to read the=20
comments<BR>that are made in the beginning section of each =
program.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>To get these tools, just copy and paste into your =
favorite=20
<BR>editor. Note though that Editor.pub.sys will have problems =
with=20
<BR>the '&' (continuation) character. If Editor is all you =
have,=20
<BR>perhaps copy & paste into Word, change the '&' to a=20
placeholder<BR>like a '%%' (percent) character as an intermediate =
step. =20
When <BR>you have the file on the HP, change '%' to =
'&'.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Courtesy of Beechglen Development, =
Inc.,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>John Backus<BR>beechglen.com<BR>(513)=20
922-0509</FONT></DIV></BODY></HTML>
------=_NextPart_000_0119_01C1676F.B7132300--