{{tag>category:"General" author:"dsig@sigafoos.org" author:" [url=http://www.sprezzatura.com]The Sprezzatura Group[/url]" author:"John Bouley"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== AREV and SYSTABLES Selection (General) ====
=== At 23 APR 2003 01:06:26PM dsig@sigafoos.org wrote: ===
 
 
<QUOTE>
I find this odd .. a developer came to me with this .. maybe someone here can explain this



they wanted to select all the tables with a specific volume which didnt have a secific MFS on it.  so they did ..



select systables with volume=myvol' and filesystem # containing "x_mfs"



It returned back all tables.  yes .. even those with the mfs.



so since filesystem was mv we tried exploding .. that worked BUT we still couldn't select/in or out those tables with the mfs.



we tried a lot of little things .. but nothing worked.



They have fallen back on writing a routine to do it BUT



Why would this be?



dsig@sigafoos.org onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

Phone: 971-570-2005

OS: Win2k sp2 (5.00.2195)

OI: 4.1.2
</QUOTE>
----

=== At 28 APR 2003 10:37AM  [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>How's about something like 


<code>
LIST FILES FILING.SYSTEM WITH EACH FILING.SYSTEM # 'QUICKDEX.MFS' AND WITH VOLUME.NAME 'SAMPLE_VOL'
</code>


from an ARev 2.1 system....







[url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url]

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

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





</QUOTE>

----

=== At 28 APR 2003 02:07PM John Bouley wrote:  ===

<QUOTE>The reason for this I think is because filesystem is multivalued. Remember if you were to select on a multivalued field any value equal would include the record. Well if you say any value not equal then the other value would always be not equal thus including the row. I think the containing just complicates matters more. At least that is how my theory goes....



HTH,

John Bouley

</QUOTE>


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