Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #7761

Re: bBRowser recordgroups

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" <Urs.Eggmann@shinternet.ch>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: bBRowser recordgroups
Date Fri, 20 Feb 2015 23:10:23 +0100
Lines 56
Message-ID <ckppnfF7cqpU1@mid.individual.net> (permalink)
References <mbd48o$nfd$1@dont-email.me>
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

Show key headers only | View raw


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" <pdb@NOMORESPAMhnt.be> 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 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

bBRowser recordgroups "Paul D B" <pdb@NOMORESPAMhnt.be> - 2015-02-10 15:23 +0100
  Re: bBRowser recordgroups "Urs Eggmann" <Urs.Eggmann@shinternet.ch> - 2015-02-20 23:10 +0100
    Re: bBRowser recordgroups "Paul D B" <pdb@NOMORESPAMhnt.be> - 2015-03-04 16:40 +0100

csiph-web