Hi all:

I've found that after running a SELECT in SLIST, I can

 Activate_save_select("")

to activate the list, but

 Delete_save_select("")

does not delete the list.

Any suggestions on how I can delete (not just CLEARSELECT) this list after it has been activated. Does this list have a 'real' name when it comes from SLIST?

TIA,

Mike O.

[notag]The select list is active after running the select.

Do you want to remove it from the SYSLISTS queue? If so, any list that is saved using a Save_Select call is used with a key of SLIST_97*@STATION.

For selects and lists and cursors S/List just uses standard OI select readnext, and cursors. It's only the listing part that's fancy.

The query windows are more like the ARev filters, if you need an analogy. Just a way to save and store off a select statement so you don't have to keep typing it in.

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

[<I>World Leaders in all things RevSoft</I>]

[<img src="http://www.sprezzatura.com/zz.gif">]

[<script language="javascript">function openNewPage () {window.location.href=(document.TOCNavigator.pageToGoTo.options[document.TOCNavigator.pageToGoTo.selectedIndex].value);document.TOCNavigator.pageToGoTo.selectedIndex="0"}end hiding from non-JS browsers –></script>] [<FORM ACTION "" METHOD=GET NAME="TOCNavigator" <SELECT NAME="pageToGoTo" SIZE=1 onChange="openNewPage()"> <OPTION>Pull down this menu to choose whereabouts on the Sprezz site to go <OPTION VALUE="http://www.sprezzatura.com">Home Page <OPTION VALUE="http://www.sprezzatura.com/whatsnew.htm">What's New <OPTION VALUE="http://www.sprezzatura.com/senl.htm">SENL <OPTION VALUE="http://www.sprezzatura.com/patches.htm">Download S/LIST <OPTION VALUE="mailto:support@sprezzatura.com">Send mail to support at Sprezzatura <OPTION VALUE="mailto:sales@sprezzatura.com">Send mail to sales at Sprezzatura </SELECT> </FORM>][/notag] </QUOTE> —- === At 04 NOV 2001 09:14AM Mike O'Neal wrote: === <QUOTE>Thanks for getting back to me on this. ]The select list is active after running the select. Agreed, found that to be true. ]Do you want to remove it from the SYSLISTS queue What we're doing is: 1) Running a SELECT via SLIST 2) Opening a form that has a button that says 'retrieve select' 3) When this button is clicked, it does this: activate_save_select("") active=@LIST_ACTIVE if active=3 then * feeds keys into the form as a QBF list - this works end else * call a popup for SYSLISTS, let user choose a list, feed in keys * this works if a SLIST SELECT statement has not been previously run end What is happening is that when a user SELECTS records using SLIST, brings them into the form, then clears the form (with another button calling QBFCLOSE), then clicks the 'retrieve select' button again, those same records from the SELECT are read into the form again. If a user clears a form, we also want to clear the keys that were generated via the SELECT command. I thought delete_save_select was the way to go… Thanks much, Mike O. </QUOTE> —- === At 05 NOV 2001 02:31PM Don Miller - C3 Inc. wrote: === <QUOTE>Mike.. It's easier to just delete the list from SYSLISTS: OPEN 'SYSLISTS' TO SYSLISTS THEN DELETE SYSLISTS,'SLIST_97*':@STATION ELSE NULL END RETURN Don </QUOTE> View this thread on the Works forum...