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 :)

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.

The Sprezzatura Group

World leaders in all things RevSoft

Nah, that's far too obvious!

(D'oh!)

Thanks for your help

Ross

====

View this thread on the forum...