When inserting rows into a popup, currently I use BTREE.EXTRACT to match records against an indexed field, followed by V119 to sort. In future, I am looking to sort most popups in descending date order.

I'm thinking I will have to user Select…by or Reduce or Rlist or a combo of them. Does anyone have any ideas which is the more efficient, and in what circumstances?

Regards,

Mike.

I assume you are creating your popups on-the-fly. I always create my popup using the UI Builder. If the popup is normally going to sort a column, I specify that in the column selection tab ("BY-DSND TRANS_DATE" for eg.) If I need to select specific rows for the popup, I do that using an RLIST SELECT just prior to calling the popup. In practice this gives me a good balance between efficiency (or speed) and coding. You may get faster results with BTREE.EXTRACT & V119 as you suggest, but for me that is way too much code. It also requires an index.

Nick,

I'm with you .. we allow the users to create selection records (defining selection criteria etc) and then use rlist to build/maintain and select these items.

We use btree.extract for relational processes (from file1 see how many records in file2 are assigned to file1 etc) but mainly simple old rlist.

[email protected] onmouseover=window.status=imagine … ;return(true)"

David Tod Sigafoos ~ SigSolutions

voice: 503-639-8080

Thanks Guys

Thanks for the tips. I'll try rlist and reduce and compare!

Regards,

Mike.

Personally, I prefer the Reduce/Select method and believe it to be faster. Andrew prefers the RList() method and also believes it to be faster. I'm thinking we should have a shootout on the train from DC to NY next week and settle this once and for all. I, however, have an article in a SENL explaining my reasons for my believes. Andrew's probably relying on faith or something.

[email protected]

Sprezzatura, Inc.

Andrew's probably relying on faith or something.

You unbeliever.

View this thread on the forum...