Sorting in Btree.extract (AREV Specific)
At 23 JUN 2005 04:43:10PM Mark Watford wrote:
Using Arev 1.16, trying to sort a list called by Btree.Extract, can the list be sorted within Btree.Extract. The manual I have the syntax for BTREE.EXTRACT is BTREE.EXTRACT(srch_strng,file,dictvar,keys,option,flag) I don't see a sort option.
Any help would be greatly appreciated.
Thanks
At 24 JUN 2005 06:01AM Curt Putnam wrote:
Not sure that I understand the question. The nature of a Btree is that a result list is sorted. Are your results not sorted? Or do you wish some order other than what is returned? In this last case, you may want to feed the results to V119
At 24 JUN 2005 08:25AM Mark Watford wrote:
Yes the results are sorted, they are sorted by ID, I need to have them sorted by a different field such as Description or Manufacturer.Number. We are using Arev 1.16, in the reference books I have I do not see any mention to V119, I am searching this forum for more info, can V119 be used in Arev 1.16 and could you give me an example of the code.
Thanks
=== At 24 JUN 2005 09:52AM support@sprezzatura.com wrote: ===
http://www.sprezzatura.com/revmedia/v1i7a2.htm
support@sprezzatura.com
The Sprezzatura Group Web Site
World Leaders in all things RevSoft
At 24 JUN 2005 10:43AM Hippo wrote:
I've read the description of V119 … there will be problem with 64kkB limit isn't it.
Mark, I don't understand your question … you have two fields (filter field and sort field), you want to select by the filter field and sort by the sort field?
This cannot be achived fast enough. If the filter returns most of the table, better use is to use sorted list and remove from it records not corresponding to the filter. In time proportioal to table size.
BTREE on the sort field.
If the filter returns small part of the table with different values of the filter field … apply it and sort the result by "external sort".
BTREE on the filter field.
If the filter returns only records with equal filter field, it's better to create third field (symbolic) as concatenation of the filter and sort fields and BTREE index on created field.
It will return the keys in correct order fast.
BTREE returns keys with the same maintained field in the order of their IDs.
=== At 24 JUN 2005 11:18AM support@sprezzatura.com wrote: ===
There is a second article detailing how to sort ] 64K.
support@sprezzatura.com
The Sprezzatura Group Web Site
World Leaders in all things RevSoft
At 24 JUN 2005 11:23AM Warren Auyong wrote:
See also the KB articleof Technical Bulletin #38
At 24 JUN 2005 11:25AM Mark Watford wrote:
Thanks for the reply it has set me in the right direction.