Popup function (type 'T') - any way to restrict results to a sample size? (OpenInsight 32-bit 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]]


==== Popup function (type 'T') - any way to restrict results to a sample size?  (OpenInsight 32-bit Specific) ====
=== At 25 SEP 2008 06:17:47AM Ross LW Brooker wrote: ===
 
{{tag>"OpenInsight 32-bit Specific"}}
 
<QUOTE>
I've got a friendly simple window to run queries from, and it outputs its' results via Popup.  



I'd like to be able to optionally restrict the results set to a sample, say the first 20 hits, to prevent a long wait when querying large tables.



Is there any way to do it?   I've done it in Rlist, but can't find out how to do it within the Popup function



Here's my code...



	ary="

	ary=fileName

	ary=selectionCriteria

	for cPos=1 to colsCnt

		dictName=selectedCols

		read dictAry from hDictFile, dictName then

			colWidth=dictAry

			dictHdr=dictAry

			convert @tm:@vm:@svm to "   " in dictHdr

			dictHdr=trim(dictHdr)

			ary=dictName :@svm: colWidth :@svm: dictAry :@svm: "C" :@svm: dictAry :@svm: dictHdr

		end

	next cPOs

	ary=T"

	ary=0"

	ary=List ":fileName

	ary=1

	ary=1









any help much appreciated :)
</QUOTE>
----

=== At 25 SEP 2008 01:56PM  [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>Ross,



Execute your RList statement first limiting the number of rows found (e.g. "SELECT 20 CUSTOMERS WITH like whatever ..." ) and then get the popup to work from the resulting active select list instead.



[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 29 SEP 2008 09:25AM Ross LW Brooker wrote:  ===

<QUOTE>Nah, that's far too obvious!



(D'oh!)





Thanks for your help



Ross

====

</QUOTE>


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