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: Tue, 11 Oct 2016 07:45:15 +0200 Lines: 96 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net glcSlJQEXyjecuzw8yMHrAssGaiQhRCerIlLNNzhkPEjqC4bjN Cancel-Lock: sha1:uliOX0bOINvUkxj8Z2wfr9Fdm6A= 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:9791 Hi Arne, I wanted to create a possibility as simple as possible to support record groups in bBrowser. However, the implementation got rather complex through this. But I think that it has got quite well. Joachim Am 10.10.2016 um 10:54 schrieb Arne Ortlinghaus: > Hi Joachim, > > nice to hear you again in the forum. I am still astonished about all the code that you have added > to make the record groups available in the browser. > > Arne > > "Joachim Bieler" schrieb im Newsbeitrag > news:e60ncdF7lliU1@mid.individual.net... >> 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 >> >