<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri",sans-serif;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:324749451;
mso-list-type:hybrid;
mso-list-template-ids:1723350510 1037622158 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-start-at:12;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Calibri",sans-serif;
mso-fareast-font-family:Calibri;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l1
{mso-list-id:837236325;
mso-list-type:hybrid;
mso-list-template-ids:307369846 1296098406 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l1:level1
{mso-level-start-at:12;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.25in;
font-family:"Calibri",sans-serif;
mso-fareast-font-family:Calibri;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.25in;
text-indent:-.25in;
font-family:"Courier New";}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.75in;
text-indent:-.25in;
font-family:Wingdings;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.25in;
text-indent:-.25in;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.75in;
text-indent:-.25in;
font-family:"Courier New";}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:3.25in;
text-indent:-.25in;
font-family:Wingdings;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:3.75in;
text-indent:-.25in;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:4.25in;
text-indent:-.25in;
font-family:"Courier New";}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:4.75in;
text-indent:-.25in;
font-family:Wingdings;}
@list l2
{mso-list-id:1117796774;
mso-list-type:hybrid;
mso-list-template-ids:-1714098970 -1493939710 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l2:level1
{mso-level-start-at:12;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.25in;
text-indent:-.25in;
font-family:"Calibri",sans-serif;
mso-fareast-font-family:Calibri;}
@list l2:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.25in;
font-family:"Courier New";}
@list l2:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.25in;
text-indent:-.25in;
font-family:Wingdings;}
@list l2:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.75in;
text-indent:-.25in;
font-family:Symbol;}
@list l2:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.25in;
text-indent:-.25in;
font-family:"Courier New";}
@list l2:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.75in;
text-indent:-.25in;
font-family:Wingdings;}
@list l2:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:3.25in;
text-indent:-.25in;
font-family:Symbol;}
@list l2:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:3.75in;
text-indent:-.25in;
font-family:"Courier New";}
@list l2:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:4.25in;
text-indent:-.25in;
font-family:Wingdings;}
@list l3
{mso-list-id:1731727575;
mso-list-type:hybrid;
mso-list-template-ids:-658749484 -1966941596 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l3:level1
{mso-level-start-at:12;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Calibri",sans-serif;
mso-fareast-font-family:Calibri;}
@list l3:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l3:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l3:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l3:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l3:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l3:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l3:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l3:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi Ken,<o:p></o:p></p>
<p class="MsoNormal">>> While you seem to be currently storing the tags in a field in your GL code table, which is fine, they could also be parsed out and stored in a GL_tags table with a key of the GL_code and a tag in each record.<o:p></o:p></p>
<p class="MsoNormal">Agreed, but the length if the tag in the GL_tags table can be 16, while the length is 256 in the GL table. No human ever edits the GL_tags table.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Since the GL table once setup and defined is rarely visited or edited by the user, then the slowness in maintaining both tables should be easy and fast. I would delete all records within the GL_tags table where its key matches the key
of the edited GL’s key. Then recreate all them when saving.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I need to create function code that will traverse the entire length of the tag field’s value, creating a new GL_tag record for each parsed value. The record count can be very high because get every possible occurrence for every 3-16 places.
Let me explain.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Previously defined date:<o:p></o:p></p>
<p class="MsoPlainText">b. 4567-1127, LODGING, motel- hotel- extended stay- Super8- Marriot- Days Inn- Motel 6- business- and more...<o:p></o:p></p>
<p class="MsoPlainText">The tag field’s date is: motel- hotel- extended stay- Super8- Marriot- Days Inn- Motel 6- business-<o:p></o:p></p>
<p class="MsoNormal">A function would need to create new records like this starting with a minimum of 3 chars and a max of 16 chars.<o:p></o:p></p>
<p class="MsoNormal">The 3 char list<o:p></o:p></p>
<p class="MsoPlainText">mot<o:p></o:p></p>
<p class="MsoPlainText">ote<o:p></o:p></p>
<p class="MsoPlainText">tel<o:p></o:p></p>
<p class="MsoPlainText">el-<o:p></o:p></p>
<p class="MsoPlainText">l- <o:p></o:p></p>
<p class="MsoPlainText">hot<o:p></o:p></p>
<p class="MsoPlainText">ote<o:p></o:p></p>
<p class="MsoPlainText">tel<o:p></o:p></p>
<p class="MsoPlainText">el-<o:p></o:p></p>
<p class="MsoPlainText">l- <o:p></o:p></p>
<p class="MsoPlainText">ext<o:p></o:p></p>
<p class="MsoPlainText">xte<o:p></o:p></p>
<p class="MsoPlainText">ten<o:p></o:p></p>
<p class="MsoPlainText">end<o:p></o:p></p>
<p class="MsoPlainText">nde<o:p></o:p></p>
<p class="MsoPlainText">ded<o:p></o:p></p>
<p class="MsoPlainText">ed <o:p></o:p></p>
<p class="MsoPlainText">d s<o:p></o:p></p>
<p class="MsoPlainText">tay<o:p></o:p></p>
<p class="MsoPlainText">ay-<o:p></o:p></p>
<p class="MsoPlainText">y- <o:p></o:p></p>
<p class="MsoPlainText">- S<o:p></o:p></p>
<p class="MsoPlainText">And on and on until the end of field occurs, then we do it again as a 4 characters version, and then a 5 character version and on and on until we get to the max of 16 character version. We should probably parse out the human delimiter
“- “ (dash + space) as that would shorten the list, as well as ending the length as soon as 3 spaces are encountered.<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">The 4<sup> </sup>char version looks like:<o:p></o:p></p>
<p class="MsoPlainText">mote<o:p></o:p></p>
<p class="MsoPlainText">otel<o:p></o:p></p>
<p class="MsoPlainText">tel-<o:p></o:p></p>
<p class="MsoPlainText">el- <o:p></o:p></p>
<p class="MsoPlainText">l- h<o:p></o:p></p>
<p class="MsoPlainText">- ho<o:p></o:p></p>
<p class="MsoPlainText">Hot<o:p></o:p></p>
<p class="MsoPlainText">Hote<o:p></o:p></p>
<p class="MsoPlainText">Otel<o:p></o:p></p>
<p class="MsoPlainText">tel-<o:p></o:p></p>
<p class="MsoPlainText">el- <o:p></o:p></p>
<p class="MsoPlainText">l- e<o:p></o:p></p>
<p class="MsoPlainText">- ex<o:p></o:p></p>
<p class="MsoPlainText">Exte<o:p></o:p></p>
<p class="MsoPlainText">Xten<o:p></o:p></p>
<p class="MsoPlainText">Tend<o:p></o:p></p>
<p class="MsoPlainText">And on and on until 3 spaces are encountered.<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">And, the 11<sup> </sup>char version would look like:<o:p></o:p></p>
<p class="MsoPlainText">motel- hote<o:p></o:p></p>
<p class="MsoPlainText">otel- hotel<o:p></o:p></p>
<p class="MsoPlainText">tel- hotel-<o:p></o:p></p>
<p class="MsoPlainText">el- hotel- <o:p></o:p></p>
<p class="MsoPlainText">l- hotel- e<o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoPlainText" style="margin-left:-.25in;mso-list:l2 level1 lfo4">hotel- ex<o:p></o:p></li></ul>
<p class="MsoPlainText">hotel exten<o:p></o:p></p>
<p class="MsoPlainText">otel- extend<o:p></o:p></p>
<p class="MsoPlainText">tel- extende<o:p></o:p></p>
<p class="MsoPlainText">el- extended<o:p></o:p></p>
<p class="MsoPlainText">l- extended <o:p></o:p></p>
<p class="MsoPlainText">- extended s<o:p></o:p></p>
<p class="MsoPlainText">And on and on until end of field or 3 spaced are encountered.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Ken, what are your thoughts so far?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal">Stanley<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><b>From:</b> Ken Cole <ken.m.cole@gmail.com> <br>
<b>Sent:</b> Monday, October 21, 2019 6:19 AM<br>
<b>To:</b> Stan-Lyn, Stanley Barnett <stanley@stanlyn.com><br>
<b>Subject:</b> Re: Retrievive index definations<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Hi Stanley,<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Just kicking the tag thing around in my head and I think I have a solution.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">While you seem to be currently storing the tags in a field in your GL code table, which is fine, they could also be parsed out and stored in a GL_tags table with a key of the GL_code and a tag in each record.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">You would need an index on the GL_code and tag as well as an index just on the tag field.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">The popup from the data entry field then looks up on the tag index and shows the applicable GL_code.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">You c would need a function to create the new table from the existing data as well as code to keep the new tag table up to date as users make changes/add tags.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Not that big a job either.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Your thoughts?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Regards<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Ken<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Fri, 18 Oct 2019 at 18:31, Stan-Lyn, Stanley Barnett <<a href="mailto:stanley@stanlyn.com">stanley@stanlyn.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<p class="MsoNormal">Hi Ken,<br>
<br>
I was hoping for a filepro function that outputs the indexes definition that can then be used in a script file to create or recreate the index. Since it appears that no filepro function exists, your template index idea may be the best idea yet.<br>
<br>
As for work, night would be good and the machines are available on the internet.<br>
<br>
I'm trying to come up with an easy way to do a GL code lookup by a tag name. The idea here is the GL table has a long field named "tags" where tag names will be added in any order.
<br>
<br>
Then when the user triggers a lookup via a hot key within the accounts payable form, it presents the user with an input popup that receives a value from the user to search for. That value will then be used to do a "contains" search against the "tags" field.
<br>
<br>
The system then presents the user with a selectable combo box with all the records that matches/contains the value searched for. The user selects one and presses enter and the GL # will be inserted within the AP.<br>
<br>
Any ideas on how to pull this off? The forms are full with no scrolling fields. Upgrading is probably not an option, however if there enough compelling stuff, then they may be interested.<br>
<br>
There is also another unrelated complex piece that needs built.<br>
<br>
Let me know your rates and your payment procedures... <br>
<br>
Thanks,<br>
Stanley<br>
<br>
<br>
<br>
<br>
<br>
-----Original Message-----<br>
From: Ken Cole <<a href="mailto:ken.m.cole@gmail.com" target="_blank">ken.m.cole@gmail.com</a>>
<br>
Sent: Wednesday, October 16, 2019 1:59 AM<br>
To: Stan-Lyn, Stanley Barnett <<a href="mailto:stanley@stanlyn.com" target="_blank">stanley@stanlyn.com</a>><br>
Subject: Re: Retrievive index definations<br>
<br>
Hi Stanley,<br>
<br>
You are right that it isn't ASCII and human readable but with the requisite knowledge you can extract the index header data from an existing index using dd and awk and some shell script.<br>
<br>
ABE=ASCII does not work with indexes.<br>
<br>
What we do is regularly run a script through all our tables that create what we call "template indexes", just the header info. So we end up with a file in each table named index.TA as the template for index A. If index A gets deleted we just copy index.TA
to index.A and rebuild it.<br>
<br>
Nancy does have some great ideas with using IXSORT and also having a "Rebuild Index Menu" that you add indexes to each time you create one with the correct dxmaint command line.<br>
<br>
With IXSORT you could create a table for all the indexes for all your tables and correspondingly the sort info. You could then have a function that cretaes a dxmaint command from that sort info to rebuild the index.<br>
<br>
What we do currently is just a legacy thing dating back nearly 20 years so it works and we haven't changed it. Also I think from memory it only works on automatic indexes and not demand indexes.<br>
<br>
As for doing work for you, I am in Australia, not the US, so that may or may not work for you. Financially with a week AUD currently compared to the USD it would be cheap for you to use me no doubt.<br>
Also, I could be working in your night so not impacting daily production usage. I have been working on Sco systems for 30+ years so that doesn't worry me.<br>
<br>
Are these systems accessible from the internet?<br>
<br>
Let me know if I can be of asssitance.<br>
<br>
Regards<br>
<br>
Ken<br>
<br>
On Wed, 16 Oct 2019 at 04:00, Stan-Lyn, Stanley Barnett <<a href="mailto:stanley@stanlyn.com" target="_blank">stanley@stanlyn.com</a>> wrote:<br>
><br>
> Thanks Ken,<br>
><br>
><br>
><br>
> Just looked and what I see (by more’ing the index.A file) is not of <br>
> any use. Here is a copy/paste of it…<br>
><br>
> # m index.A<br>
><br>
> "index.A" may be a binary file. See it anyway?<br>
><br>
> index.A<br>
><br>
> ESC[G<br>
><br>
> 9<C1>^C^@^@^@>^@^@^D^@^@C^@^@^@<D0><83>^@^@^L^@^D^@^A^@^@^@^L^@^@Y^@^@<br>
> ^@^@^@^@^@<br>
><br>
> ^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@<br>
> ^@^@^@^@^@<br>
><br>
> ^<br>
><br>
><br>
><br>
> I have ??dcabe?? set to ascii. Is there such a thing for dxmaint? Any suggestions?<br>
><br>
><br>
><br>
> Also, do you do any outside work, as I need an extra pair of hands on <br>
> adding a few features to an filepro 5.0.14d4 app on sco os5. If <br>
> interested, call me at 859-402-8165…<br>
><br>
><br>
><br>
> Thanks, Stanley Barnett<br>
><br>
><br>
><br>
><br>
><br>
><br>
><br>
> From: Ken Cole <<a href="mailto:ken.m.cole@gmail.com" target="_blank">ken.m.cole@gmail.com</a>><br>
> Sent: Monday, October 14, 2019 6:12 PM<br>
> To: Stan-Lyn, Stanley Barnett <<a href="mailto:stanley@stanlyn.com" target="_blank">stanley@stanlyn.com</a>><br>
> Cc: <a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a><br>
> Subject: Re: Retrievive index definations<br>
><br>
><br>
><br>
> Stanley,<br>
><br>
><br>
><br>
> The definition is in the header of the index.<br>
><br>
><br>
><br>
> Under Unix we use standard file manipulation tools to extract and store that detail fir the exact reason you suggest.<br>
><br>
><br>
><br>
> Under Windows you could probably use GNU tools or maybe PowerShell to do the same.<br>
><br>
><br>
><br>
> The header is different depending on how the indexes were created/which version of FP used to create them.<br>
><br>
><br>
><br>
> The index header info used to be on the FPTech web site.<br>
><br>
><br>
><br>
> Ken<br>
><br>
><br>
><br>
> On Tue, 15 Oct 2019 at 07:07, Stan-Lyn, Stanley Barnett via Filepro-list <<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a>> wrote:<br>
><br>
> Hi,<br>
><br>
><br>
> Is there a way to retrieve the index definitions of a data file where its indexes were built via the gui? So instead of ./dxmaint table -bs -ra -e -h "Rebuilding All Indexes" that rebuilds all the indexes without knowing anything about the indexes, I need
to build them individually with the dxmaint command. Sometimes an index gets deleted and without this info, I have to spend a lot of time tracking down the process that uses the deleted index and then try and figure out how it was constructed. If this info
can be gathered near creation time, I would have a library of the index definitions. I'm using SCO Unix here. So is there a filepro function or a storage location where the definition can be retrieved?<br>
><br>
><br>
> Thanks,<br>
><br>
> Stanley<br>
><br>
><br>
> -------------- next part -------------- An HTML attachment was <br>
> scrubbed...<br>
> URL: <br>
> <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20191" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20191</a><br>
> 014/1c785552/attachment.html> <br>
> _______________________________________________<br>
> Filepro-list mailing list<br>
> <a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>
> Subscribe/Unsubscribe/Subscription Changes <br>
> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">
http://mailman.celestial.com/mailman/listinfo/filepro-list</a><o:p></o:p></p>
</blockquote>
</div>
</div>
</div>
</body>
</html>