Is there a way to select records using field number (AREV Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

[[https://www.revelation.com/|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]]


==== Is there a way to select records using field number (AREV Specific) ====
=== At 10 DEC 2002 09:42:13AM Pat Curley wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
Is there a way to select records using field number rather than the name of the field from the dictionary?
</QUOTE>
----

=== At 10 DEC 2002 10:05AM Richard Wilson wrote:  ===

<QUOTE>your voc probably already has some generic ones defined as F1,F2,F3,etc

 

and you can create more if you wish

</QUOTE>

----

=== At 11 DEC 2002 01:52PM Matt Sorrell wrote:  ===

<QUOTE>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

[url=http://www.greyhound.com]Greyhound Lines, Inc.[/url]

</QUOTE>

----

=== At 13 DEC 2002 08:37PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>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.



[url=http://www.sprezzatura.com]The Sprezzatura Group[/url]

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=19D60D0FCF5EF60485256C8B0050C517|View this thread on the  forum...]]