Searching & Selecting (AREV Specific) [Revelation On-Line Wiki]

AREV Specific

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 03 OCT 2002 04:58:59PM Rick Todd wrote:

I have a client that is using AREV 3.12 on a Windows 2000 Network with the service pack. Intermittently when searching (Cross Reference Indexing) the application will find 20 matches, but then only display 5. This also occurs in EasyWriter or whenever the LIST command is used. The strange thing is that when a second attempt is trying it usually displays the correct number of records. Does any one have any suggestions?

Thanks

Rick

At 03 OCT 2002 05:32PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:

Try performing a clearlist / clearselect ahead of your query - does it then behave consistently?

The Sprezzatura Group

World Leaders in all things RevSoft

At 09 OCT 2002 03:45PM Rick Todd wrote:

I added a "PERFORM CLEARLIST" prior to the SELECTs, GETLISTs, MAKELISTs, LIST etc. and it did not make any difference.

At 09 OCT 2002 05:08PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:

Try adding a symbolic to the file that's just
FLUSH;GARBAGECOLLECT
@ANS='
and adding it to the select statement.

The Sprezzatura Group

World Leaders in all Things RevSoft

At 10 OCT 2002 08:05AM Don Miller - C3 Inc. wrote:

In fact, I've used such a global variable for years (AREV .. DICT.VOC, called CLRIT and is SYSDICT in OI). This way, you don't have to put it in every file. Works for me.

Don M.

At 10 OCT 2002 08:39AM Hippo wrote:

Wow, good idea, thanks!

At 15 OCT 2002 09:24AM Dick Trimble wrote:

How would I use that in ARev code?

Something like:

PERFORM "SELECT VOC CLRIT"?

At 15 OCT 2002 10:02AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:

Yup, that's exactly how you do it.

DICT.VOC is a global dictionary. If the system cannot find a dictionary item in the nominated file it will attempt to use DICT.VOC before returning a dictionary item does not exist error.

By setting the length to 0, you ensure it does not show up or affect any list statments.

The Sprezzatura Group

World Leaders in all Things RevSoft

At 16 OCT 2002 08:12AM Hippo wrote:

As I understand it,

the file neednot be VOC

PERFORM "SELECT whatever CLRIT"

At 16 OCT 2002 08:40AM Don Miller - C3 Inc. wrote:

Correct ..

If the DICT.VOC has an entry CLRIT, you can use it in any file. Other common things in my DICT.VOC are

ONE .. Symbolic .. @ANS=1, right justified, length 10

LIST WITH clause, TOTAL ONE DET-SUPP

TALLY .. G type, "'V'" TOTAL ONE ..

USED WITH BREAK-ON TO TABULATE A FIELD. THIS COUNTS THE UNIQUE VALUES. FOR EXAMPLE, LIST DICT VOC BY TYPE BREAK-ON TYPE TALLY.

Dict VOC is global to all tables in the account

HTH

Don M.

At 17 OCT 2002 03:22AM Hippo wrote:

Don

Thanks once again for sharing your knowledge.

View this thread on the forum...