Update Index within script

[Tom Patten]

I have a script which requires that I update an individual index after a variable has been set.

This works:

idx = inputf.update_production_index()

but is there a more efficient way so that just one index is updated and not all indexes.

Thanks

Tom

[Tom Cone Jr]

RE: Update Index within script

Tom,

I'm curious why you're using variables with production indexes. Folks often recommend that variables NOT be used in index filters. Off hand I can't imagine any other uses. How are you using variables with your index?

-- tom

[Tom Patten]

RE: Update Index within script

Hi Tom,

I have a button on a form that eventually does an update on charges. But first and variable set from an array to identify the PAYOR, then the SERVICES for this Payor are shown in the next array for selection. This permits CHARGES to be updated for Specific PAYORS for specific SERVICES.

So after the variable for the payor is set, vPayor, then I have a filter in SERVICES.dbf to filter on vPayor to show services paid by this payor.

Guess I could use a query, but I am more familiar with indexes. ANyway, the filtered index in SERVICES needs to be refreshed or updated between the PAYOR array and SERVICES array.

I'm open to suggestions and alternative approaches.

Tom

[Tom Cone Jr]

RE: Update Index within script

Tom,

Is the filter in your index for SERVICES using the variable somehow?

-- tom

[Tom Patten]

RE: Update Index within script

Yes - it sure is.

But apparently when you use the index_primary_put() method it does not Update the index. And the index needs updating to see the just set variable filter.

Is there a more efficient way to update the index just prior to using it?

Tom

[Tom Cone Jr]

RE: Update Index within script

Tom,

I have no experience doing what you are describing. Others (with more experience than I) have indicated that this is dangerous and problematic. In the best case you will have to rebuild the index every time the value of the variable changes, in the worst case the variable value will change and you'll miss the rebuild, causing the index to become corrupted.

If it were me I'd look at other alternatives.

Tell us what you're shooting for, and perhaps we can suggest some.

-- tom

[Tom Patten]

RE: Update Index within script

Hi Again,

Like I say this will work:

idx = inputf.update_production_index()

And I don't mind having to rebuild the indexes each time I use it, because the variable is set within the same script. BUT I think the above code updates all the indexes and I'd prefer to just update the one index I'm using.

Apparently, the indx.get() and Put() methods do not rebuild the indexes.

Thanks again,

Tom

[Tom Cone Jr]

RE: Update Index within script


Tom, I checked the Xbasic Ref. Manual and the discussion does not extend to updating only a single indextag. You may be thinking of Alpha Four, where indexes were maintained in separate files, each ending in an NDX extension. Updating (rebuilding) a single index was possible there. As you know Alpha Five keeps all the indexes for a single table in a compound index file, which is a single file bearing a CDX extension. I don't know of a way to update just one indextag.

-- tom

[Tom Patten]

RE: Update Index within script

Thanks for looking into this Tom.

Like I say, I have it working - but..

Again, Thanks

Tom