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


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

Re: Problem with RecordGroup in bbrowser 4

From "Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Problem with RecordGroup in bbrowser 4
Date 2016-10-07 11:29 +0200
Organization A noiseless patient Spider
Message-ID <nt7psh$suv$1@dont-email.me> (permalink)
References <ff6ba888-36bb-4316-aad9-b139485c7f0e@googlegroups.com>

Show all headers | View raw


Hi Lu,

I have implemented usage of the record groups in our programs. It is a nice 
feature and much appreciated by the users.

However I had to make many small changes in the original code, that 
everything worked. I had also to insert some mechanisms to refresh all data 
in case of certain situations. Yet I haven't found all cases where something 
can go wrong. Sometimes the browsers should duplicate rows at the end that 
cannot be clicked. Looking into the code I can imagine how much work Joachim 
Bieler must have spent to implement these record groups. So I think that if 
you want to use the record groups in your programs and you have some issues 
then you may have to spend a couple of days on your own to resolve these 
issues.

Arne Ortlinghaus
ACS Data Systems

"Lu" <lu2k@hotmail.com> schrieb im Newsbeitrag 
news:ff6ba888-36bb-4316-aad9-b139485c7f0e@googlegroups.com...
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 

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


Thread

Problem with RecordGroup in bbrowser 4 Lu <lu2k@hotmail.com> - 2016-10-06 06:01 -0700
  Re: Problem with RecordGroup in bbrowser 4 Lu <lu2k@hotmail.com> - 2016-10-06 23:40 -0700
  Re: Problem with RecordGroup in bbrowser 4 "Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it> - 2016-10-07 11:29 +0200
    Re: Problem with RecordGroup in bbrowser 4 Lu <lu2k@hotmail.com> - 2016-10-07 12:54 -0700
      Re: Problem with RecordGroup in bbrowser 4 "Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it> - 2016-10-09 16:59 +0200
  Re: Problem with RecordGroup in bbrowser 4 Joachim Bieler <support@votools.com> - 2016-10-10 07:30 +0200
    Re: Problem with RecordGroup in bbrowser 4 "Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it> - 2016-10-10 10:54 +0200
      Re: Problem with RecordGroup in bbrowser 4 Joachim Bieler <support@votools.com> - 2016-10-11 07:45 +0200
        Re: Problem with RecordGroup in bbrowser 4 Lu <lu2k@hotmail.com> - 2016-10-11 00:19 -0700
        Re: Problem with RecordGroup in bbrowser 4 "Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it> - 2016-10-11 09:31 +0200

csiph-web