SLIST using a select and list (OpenInsight 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]]


==== SLIST using a select and list (OpenInsight Specific) ====
=== At 01 MAY 2001 04:42:43PM a becker wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
Help - we are testing using SLIST_97 with a select followed by a list.



The coding is below.



What happens is that when it is ran, the system beeps on the select, goes ahead and selects the 55 records we have, but, the list that is produced is not in the proper order. (The result is vendor_number, etc., within each key, not all vendor number 1, then all vendor number 2, etc.)  When I type in the command using the SLIST_97 the same fields come out with all vendor_number in order as well as the other sort keys.  Also if I only use the vendor_number, the result is the vendor numbers within the record's key which is not what we want.



Any ideas what I can do to programmatically get the desired results.



Just a little note:  This is a test of the select.  If we can get this working, we will be putting in logic that will read through the selected records and looking for duplicates.  The duplicates will be those fields that are being used by the BY statement in the SELECT.



One more thing - what are the "5","","","" in the select statement mean?  I copied the coding out of the old RLIST we had in an AREV program and this is the only way I can get the complier to accept the select statement. 



Any help is greatly appreciated.



Thanks



Andy



DECLARE FUNCTION GET_PROPERTY, SET_PROPERTY, SLIST_97

DECLARE SUBROUTINE SLIST_97,UTILITY



DEBUG





call slist("select ats_pb_detail by vendor_number by vendor_invoice by vendor_date by code by amt","5","","","")



call slist("list ats_pb_detail vendor_number vendor_invoice vendor_date code amt cleared id-supp box")



RETURN 1
</QUOTE>
----

=== At 02 MAY 2001 09:32AM Don Miller - C3 Inc. wrote:  ===

<QUOTE>Andy ..

Your SLIST select statement is using the RLIST syntax rather than the SLIST syntax (I think...).  Personally, unless I need to check to see whether the Select actually produces valid records for a report, I just put the select clause in with the SLIST sentence and get on with my life.  I think SLIST is aware of an active select list, so you can do an RLIST Select and then call SLIST with the active select list.



I'm sure Sprezz can enlighten..

Don Miller

C3 Inc.

</QUOTE>

----

=== At 03 MAY 2001 05:42AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>Hi,



SList does respect an active select lists...



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

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

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

</QUOTE>

----

=== At 03 MAY 2001 08:43AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>Just to clarify - the first SELECT is via RLIST not SLIST yes? (The 5, "", "", "" is required by RLIST as it is a polymorphic function - it does more than just select. For more details type RLIST in a blank system editor document and press F1).



As has previously been stated, you can just add the select to the end of the SLIST statement [i]e.g.[/i]



LIST CUST BY SURNAME WITH SURNAME=SMITH'



Would we be correct in assuming that you are selecting by a multi-valued field?



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

----

=== At 03 MAY 2001 10:15AM a becker wrote:  ===

<QUOTE>Sprezzatura -



Yes the fields I'm sorting/selecting by are multivalued.

</QUOTE>

----

=== At 03 MAY 2001 10:27AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>Weird - we are actually checking for an exploding sort. What happens if you combine this into ONE S/List statement?



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

----

=== At 03 MAY 2001 10:29AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>Weird - we are actually checking for an exploding sort. What happens if you combine this into ONE S/List statement?



[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=559E42A1D132EE5485256A3F0071C686|View this thread on the  forum...]]