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

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.

Hi,

SList does respect an active select lists…

The Sprezzatura Group

World leaders in all things RevSoft

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 e.g.

LIST CUST BY SURNAME WITH SURNAME=SMITH'

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

The Sprezzatura Group

World Leaders in all things RevSoft

Sprezzatura -

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

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

The Sprezzatura Group

World Leaders in all things RevSoft

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

The Sprezzatura Group

World Leaders in all things RevSoft

View this thread on the forum...