<div dir="auto">Hi Mike,<div dir="auto"><br></div><div dir="auto">Thanks for the detailed explanation. That really clears it up. </div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Jan 11, 2020, 7:34 AM Mike Schwartz (PC Support & Servies) via Filepro-list <<a href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Mike, thanks for the script!<br>
<br>
When you say we have to rebuild the demand indexes manually, what do you mean? And why only manually?<br>
<br>
Ross<br>
----- ----- ------------------------------------<br>
<br>
Demand indexes often use selection sets to select only part of the records. If you have only a few demand indexes, you may want to rebuild them through the filePro menu index maintenance screen. <br>
<br>
You could write a script to rebuild your demand indexes, but it would be a script where all the parameters to rebuild each index, including the selection set used, would have to be included on the command line. For example, this screen build a demand index on my invoicing database:<br>
<br>
dxmaint mjsinvoice -RF 14,4,a:20,14,a:1,20,a:2,20,a:11,10,a -oM -E -m ""<br>
<br>
I see that Mark just sent you a list of option for the dxmaint lines. <br>
<br>
You need one of these lines for each demand index on your system, *AND* you have to keep this script updated whenever you create or change any of your demand indexes.<br>
<br>
Mike<br>
<br>
<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com" target="_blank" rel="noreferrer">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer noreferrer" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote></div>