Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!us.feeder.erje.net!newsfeed.fsmpi.rwth-aachen.de!newsfeed.straub-nv.de!news-1.dfn.de!news.dfn.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Urs Eggmann" Newsgroups: comp.lang.clipper.visual-objects Subject: Re: bBRowser recordgroups Date: Fri, 20 Feb 2015 23:10:23 +0100 Lines: 56 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Trace: individual.net a5so+TmPT2K1kWQQzqL2IQqjiDRkWTVy05c+D+s7qxgVTyd1Tc Cancel-Lock: sha1:jEKj5MlJ9J8+p0KL4yvfqR3pGeY= X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.5931 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157 X-EsetId: 37303A2992966F60607260 X-EsetScannerBuild: 22573 Xref: csiph.com comp.lang.clipper.visual-objects:7761 Hi Paul, Just a idea, not jet proved... Only a piece of pseudocode. Add a additional field "LengthGroup" to your database. Method AnalyseGroup() class .... // Do it for each record, loop, codeblock .... Do case case Between(dbServer:Fieldget(#Distance , 0 , 100 ) dbServer:Fieldput(#LengthGroup , 1 ) case Between(dbServer:Fieldget(#Distance , 100 , 500 ) dbServer:Fieldput(#LengthGroup , 2 ) .... and so on otherwise Return False endcase return true Run this Method once and afterwards for each new record when entering it. Then use this field for grouping. Exclude the group field from showing in the browser. regards Urs "Paul D B" schrieb im Newsbeitrag news:mbd48o$nfd$1@dont-email.me... > Hi all, > > Can anyone tell me if this is possible? > > I have a numeric field in my DBF with distances (lengths). The value can > vary anywhere between 0 and 999999 metres. > I would like to make recordgroups like: > from 0 to 100 m > from 101 to 500 m > from 501 to 1000 m > form 1001 to 10000 m > and so on. > I have not yet determined the exact boundaries of the groups (not so > important; whatever is possible in bBrowser). > I would already like to know if I can do it. > > The recordgroupkey in bBrowser can be a function like > cGroupKey := "SubStr(DToS(Server:BIRTHDAY), 1, 3)" > > Been struggling to build a function that results in what I want, no > success. > > TIA > > > Paul