Is there a way to select records using field number (AREV Specific)
At 10 DEC 2002 09:42:13AM Pat Curley wrote:
Is there a way to select records using field number rather than the name of the field from the dictionary?
At 10 DEC 2002 10:05AM Richard Wilson wrote:
your voc probably already has some generic ones defined as F1,F2,F3,etc
and you can create more if you wish
At 11 DEC 2002 01:52PM Matt Sorrell wrote:
Another option, besides using DICT.VOC, would be to use inline formulas. You could do something like this:
SELECT WITH {@RECORD}=MY_VAL'
msorrel@greyhound.com
At 13 DEC 2002 08:37PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
The other ideas presented here are all good.
Non-technical users might get what they want by using the "containing" syntax
WITH DATA 'literal'
or
WITH DATA CONTAINING 'literal'
While this normally provides more hits than required, and ignores ICONV/OCONV, for text data or coarse searches or large numeric values it can be useful in certain cases.
Otherwise, use F1..F99 in DICT of VOC - a common approach.
World Leaders in all things RevSoft
