Hi All

I'm using Arev 3.12 and if I run

LIST SH_STOCK_SUPPLIER ALPHA_KEY NUM_KEY STATUS WITH ALPHA_KEY BETWEEN "P" AND "P" AND WITH NUM_KEY BETWEEN 1 AND 999999 AND WITH STATUS EQ "N"

It Lists 30 Records

However if I change the list to a select,

It finds no rows

Alpha_Key Num_Key and Status are all indexed

Alpha_Key and Num_Key are Symbolic

Alpha Key is Left Justified

Num_Key is Right Justified.

I know the statement is not pretty, but why does list work and select doesn't?

TIA

Claude

Claude ..

What happens if you use parentheses in the select. Like..

SELECT SH_STOCK_SUPPLIER WITH (ALPHA_KEY BETWEEN "P" AND "P") AND (WITH NUM_KEY BETWEEN 1 AND 999999) AND (WITH STATUS EQ "N")? Since R/LIST generates an internal select it shouldn't make any difference, but I've seen it before and can't explain it either.

Don Miller

C3 Inc.

Thanks for the idea Don

I've tried parenthesis in all manner of places yet I still get no rows found.

Regards

Claude

Hi Claude,

(a) Try adding fields that are not indexed (same field/formula as) the indexed fields, then use these unindexed dictionary items in your query (this rules out index corruption or slow index updates or crud in key data as a cause). You can add them to DICT.VOC if necessary. Ignore the speed hit - try it as an experiment.

(b) indexed symbolics…while they can be used successfully these may be the culprit. Sprezz personnel in UK admit they are useful, but there is some antipodean sentiment that says you shouldn't.

© We're going to have to drag you back to the Station Hotel next time you're in Melbourne - you know (quite rightly) this to be only way to find the "real" solution.

Cheers.

The Sprezzatura Group

World Leaders in all things RevSoft

Thanks for the info Steve, sorry Sprezzaturra…

I've had a play and get the following results..

Added a non-indexed file in the select - No Rows found

Removed all the indexes - 30 Rows found

Index Alpha_Key (The Symbolic) - 30 Rows Found

Index Num_Key (Another Symbolic) - 30 Rows found

Index Status (Not Symbolic) - No rows found

Remove Status Index - 30 Rows found

It seems like Symbolics and non symbolics don't like each other…

Any ideas?

Regards

Claude

P.S. Is the train still ploughing through the wall at the Station?

Claude - if you post the formulae and the list syntax it may help to diagnose the fault. It does sound weird, granted.

The trains on the Sandringham line always run 7 days and 15 mins late.

There's still one imbedded in the wall at the "Station".

The Sprezzatura Group

World Leaders in all things RevSoft

Hi S,

I wrote this years ago to get over the sorting problem when Arev deals with Alpha Numerics

ALPHA_KEY key.code={STOCK_CODE} convert '1234567890' to in key.code alpha=trim(key.code) @ans=ALPHA * NUM KEY * key.code={STOCK_CODE} convert {ALPHA_KEY} to in key.code @ANS=trim(key.code) Regards Claude P.S If you are on the Sandringham Line, you're on the wrong train! </QUOTE> —- === At 16 AUG 2001 01:44AM Steve Smith wrote: === <QUOTE>http://people.enternet.com.au/~cbrnbill/maps/melbourn.gif Prahran station is on the Sandringham line ;) Which "Station Hotel" did you mean? I'd advise against using symbolics that reference symbolics. This can cause all sorts of hard-to-trace bugs. If you can replace {} notation with notation it's often faster, too. The Sprezzatura Group World Leaders in all things RevSoft </QUOTE> —- === At 16 AUG 2001 10:55AM The Sprezzatura Group wrote: === <QUOTE>Stupid question, but when you change to SELECT, are you removing the display fields from the list? The Sprezzatura Group World Leaders in all things RevSoft </QUOTE> —- === At 16 AUG 2001 11:40AM C Mansutti wrote: === <QUOTE>Sorry, I thought you lived in Rowville I'll play with it but I'm not going to hold my breath in the hope it works. (Then I might do some coding) Regards Claude P.S If I don't reply for the next week, its only because I'm off to sunny France for a well deserved break. </QUOTE> View this thread on the forum...