Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Joachim Bieler Newsgroups: comp.lang.clipper.visual-objects Subject: Re: Problem with RecordGroup in bbrowser 4 Date: Mon, 10 Oct 2016 07:30:53 +0200 Lines: 78 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net 8RSmQa4dZgCyFUeClDY5cAjaUebiQClKgAo5INCG66UZdrtfKd Cancel-Lock: sha1:Ebu9V8SfmtRFgdSJzOqyt6w4Z3g= User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Thunderbird/45.1.1 In-Reply-To: Xref: csiph.com comp.lang.clipper.visual-objects:9788 Hi Lu, I am sorry that you have problems with the record groups. Unfortunately, I cannot reproduce the described problems. Because of this I need a test application (AEF file) from you with which I can reproduce the problems. Your problems could have to do with the used data or also with the height of the bBrowser. HTML clipboard Regards, Joachim Bieler Am 06.10.2016 um 15:01 schrieb Lu: > Hi VO-experts > > I have 2 problems with the RecordGroups: > > problem 1: > When the last record has a sub-records the + is not shown. It looks like that the last record belongs to the second last record. I do not see the records of the last group record (its quite complicated to explain I hope you understand it) > > problem 2: > When I click on the minus (-) to hide the sub-groups the last row is shown 2 times. One at the end, and the second at the bottom of the bbrowser. This is only when the 'Grid in empty area' is set to true and there are empty rows in the bbrowser (in other words: the browser ist not completly filled) > > The bbrowser is filled with a stored procedure from a ms sql server > > LOCAL oServ as AdoServer > local cGroupKey as string > local oRecordGroupLevel as bRecordGroupLevel > > oServ := sqlUserKennung{"dbo.spLELReadUserKennung"} > self:oDCbBrowser:RecordGroup:LevelList:Clear() > > cGroupKey := "Substr(Server:Name,1,1)" > oRecordGroupLevel := bRecordGroupLevel{bCodeblock{cGroupKey, oServ},; ,; > nil,; > _or( BRGLO_Auto,BRGLO_LEVELSEPARATOR )} > > oRecordGroupLevel:GroupView := bViewStyle{ , Brush{Color{COLORRED}}} > self:oDCbBrowser:RecordGroup:LevelList:Add(oRecordGroupLevel) > > self:oDCbBrowser:Use(oServ,,{#Name,#Titel,#UserName,#Region}) > > > oColumn := SELF:oDCbBrowser:GetColumn("Name") > IF oColumn<>NULL_OBJECT > oColumn:Alignment := BALIGN_LEFT > oColumn:CAPTION := LoadResString("Name",IDL_NAME,_GPLANGUAGE) > oColumn:Width := 170 > ENDIF > oColumn := SELF:oDCbBrowser:GetColumn("Titel") > IF oColumn<>null_object > oColumn:Alignment := BALIGN_LEFT > oColumn:CAPTION := LoadResString("Titel",IDL_TITEL,_GPLANGUAGE) > oColumn:Width := 48 > ENDIF > oColumn := SELF:oDCbBrowser:GetColumn("UserName") > IF oColumn<>NULL_OBJECT > oColumn:Alignment := BALIGN_LEFT > oColumn:CAPTION := LoadResString("UserName",IDL_USERNAME,_GPLANGUAGE) > oColumn:Width := 120 > ENDIF > oColumn := SELF:oDCbBrowser:GetColumn("Region") > IF oColumn<>NULL_OBJECT > oColumn:Alignment := BALIGN_LEFT > oColumn:CAPTION := LoadResString("Reg.",IDL_REG,_GPLANGUAGE) > oColumn:Width := 40 > ENDIF > > self:oDCbBrowser:Recalculate() > self:oDCbBrowser:Refresh() > > RETURN NIL > > > Thank you for any hints > Lu