<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> I am writing some master reports that will need to
access all the available qualifiers and I need a clever solution that will let
me read in all of the qualifier names for a given file. This is running in
filePro 5.0.06 on SCO Openserver.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> For example, in the "custmast" customer master
file, and there are qualifiers for each of the several dozen manufacturing
plant locations; IE the qualifiers are detroit, grnbay, omaha, etcetera, and I
need to load each of the qualifier names into a loop of lookup commands using
something like custmast@{qu where qu equals detroit, grnbay, omaha, etc.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> Opendir-nextdir commands work OK, but they are tedious
to write and there isn't a mask for qualifiers, so they tend to require a lot
of disk I/O. (Some of the filePro files I am working with have hundreds of
files in them, mostly selects, like se.ltty230, sel.tty942,se.lpeteb, etcetera
that I have to weed through to find the key files.) I am going to have to do
this for numerous reports, so I need something that is simple to implement and
runs as quickly as possible, because I am feeding this data out to web browsers
in response to sales rep queries, so transaction time will be critical. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> Wishlist: Maybe I will submit something to the
wishlist to request a mask for qualifier names in the opendir command, but I
don't know whether that will speed the opendir command up very much…<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> I can't depend on the file named "qualify" in
each of the filePro subdirs, because the key and data files might have been
copied in from another server, rather than built through the filePro main
menu. IE, the "qualify" file is usually wrong or non-existant.
However, if any of you have a script that can loop through all of the filePro
subdirectories and recreate the "qualify" file in each subdir,
perhaps I could run something like that as a "cron" job. Actually,
I could probably do this from within filePro once a week or once a month using
OpenDir, but I would hate to miss any new locations in the interim. (There
are over 500 filePro files on about a dozen servers, so I would rather not do
this by hand…)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> There are dozens of filePro reports that I am going to
have to modify to become web transactions, so I am interested in any ideas or
scripts that any of you have developed to make this process more efficient.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Mike Schwartz<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>