How can we implement wildcards in query mode. There was a % option in AREV. Most of our tenders are requesting this function. Any ideas please?

Well, RList uses the and characters for "Ending with" and "Starting with", respectively.

For instance:

SELECT table WITH field "A]" (Starting with "A")

(this is equivalent to 'field ] "A"')

SELECT table WITH field "ABC" (Containing "ABC")

SELECT table WITH field ".00" (Ending with ".00")

(equivalent to 'field ".00"')

Note the lack of any operator between the field and the comparison value in the first and third SELECT statements… It's important.

Thanks Alex for quick response. We use the square brackets OK but we have a lot of codes (cost centres, Org Units, Pay Groups) made up of series of codes - Have you seen the oracle financial general ledger codes?

we need to search for codes like ABCD123456

or AB**5432123456 etc.

containing is not safe as the sequence could appear in two places, not just in the position we are searching for.

We greatly miss the BY clause too but have put a button on the querytools to resort the browse list.

Most of all the range feature in AREV using the three dots was a great favourite of our users, especially for dates - ah well - progress I think they call it.

Thanks again

You don't mean

LIST FILE WITH ?SOMEFIELD?

, do you?

If so, you'll have to code it yourself. It's not implemented, that I'm aware of.

apk@sprezzatura.com

Sprezzatura Ltd

View this thread on the forum...