Hello all. Has anyone encountered the following:

File FOOBAR is B-Tree indexed on a Date field call it DATE_FIELD (properly formatted, etc.). The command:

RLIST LIST FOOBAR WITH DATE_FIELD=04/10/2000" ..fields stops midway through the alphabet of keys (which are all alpha). It just so happens I have a non-indexed variant of the same field.. so

RLIST LIST FOOBAR WITH ALT_DATE_FIELD=04/10/2000" BY @ID processes the entire table but takes a long time. Next, tried:

RLIST SELECT FOOBAR WITH DATE_FIELD=04/10/2000" and got 400 records.

Then..

RLIST FOOBAR WITH DATE_FIELD=04/10/2000" ..fields works just fine.

It's pretty clear that the select forced an update of the Index while the R/LIST LIST didn't. The problem is, of course, that in order to guarantee an index update, it looks like a select needs to be done ahead of the LIST (or OR_VIEW call if you want to use this).

Has anybody else seen this?

Don Miller

C3 Inc.

Don,

Is your environment set up to "Update Before Query"?

[email protected]

SRP Computer Solutions

Yes. In fact the RLIST SELECT variance works just fine. But unless I do this first, the RLIST LIST variance doesn't seem to update indexes.

Therefore, in order to guarantee the results, I have resorted to doing a select ahead of the RLIST LIST sentence and then making sure that the RLIST LIST sentence uses the same select/sort criteria that was used in the RLIST SELECT.

By the way, in a Run Time, how can you determine or set the Update Index before Query environment variable? In OI development, you can get to it in Database Manager but this is not available in a Run Time.

Don Miller

Don,

If you must update the indexes your self then why don't you just use Update_Index or Index.Flush?

I've never looked into this but I believe the Database settings are stored in SYSENV, possibly the ENV_APPNAME record. You can deploy these records in an RDK (or alternative method) quite easily.

[email protected]

SRP Computer Solutions

Don ..

Can you point me to a method to include the environment setting in an RDK upgrade if need be? Frankly, I find the RDK create module a pretty weak tool.

Don Miller

C3 Inc.

Don,

The process would be the same as deploying promoted events or any other component that doesn't have a repository record. If you have never done this then here is a link where I explain the process. This example is for promoted events but the technique is the same. This came from the Works board so let me know if you don't have access and I'll just re-publish the document here.

[email protected]

SRP Computer Solutions

Don ..

Thanks for the link…

Don Miller

C3 Inc.

View this thread on the forum...