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


Groups > comp.lang.clipper.visual-objects > #9781 > unrolled thread

Problem with RecordGroup in bbrowser 4

Started byLu <lu2k@hotmail.com>
First post2016-10-06 06:01 -0700
Last post2016-10-11 09:31 +0200
Articles 10 — 3 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

#9781 — Problem with RecordGroup in bbrowser 4

FromLu <lu2k@hotmail.com>
Date2016-10-06 06:01 -0700
SubjectProblem with RecordGroup in bbrowser 4
Message-ID<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

[toc] | [next] | [standalone]


#9782

FromLu <lu2k@hotmail.com>
Date2016-10-06 23:40 -0700
Message-ID<19896452-578d-4ab4-85c7-233c23d4e68c@googlegroups.com>
In reply to#9781
Another thing I noticed is that, when I click on the vertical scroll bar and pull on the top to see the first row, the scroll bar moves down that the first visible row is the second row. With the vertical sroll bar I do not see the first row, I have to use the mouse wheel or the up triangle button.

Can somebody share this experience or do you know a solution.
I know it is not a big problem but I do not know why, because in the bbrowser samples it does not occur.

Lu 

[toc] | [prev] | [next] | [standalone]


#9783

From"Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it>
Date2016-10-07 11:29 +0200
Message-ID<nt7psh$suv$1@dont-email.me>
In reply to#9781
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 

[toc] | [prev] | [next] | [standalone]


#9784

FromLu <lu2k@hotmail.com>
Date2016-10-07 12:54 -0700
Message-ID<465faf33-17ee-414b-9870-9f741484d842@googlegroups.com>
In reply to#9783
Hi Arne

Thank you for your answer. The record groups are a great feature of the bbrowser and I like them. I have already spent some days to check it out, but now, I do not know what I can try to fix the problem 1.
Problem 2 I can fix with the option 'grid in empty area' = false. The users do not like this option but it would solve the problem.
Would it be possible that you show me your changes Arne?

Lu

[toc] | [prev] | [next] | [standalone]


#9787

From"Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it>
Date2016-10-09 16:59 +0200
Message-ID<ntdlvq$o2p$1@dont-email.me>
In reply to#9784
Hi Lu,

it would not help, if I searched for all the little changes I have made. It 
is too much work for me, I have made too many changes to the browsers, in 
the windows and in new additional classes for maintaining the settings of 
the fields. Also what you describe is different from that what happens in 
our programs. I am sure that all these details are related to the type of 
record groups and the server objects one is using. We are using some own 
written sql objects that have been developped from the sqlselect. Also the 
windows and the refreshing mechanisms influence much of the effects.

It is already much time that Joachim Bieler has participated in these 
forums. Perhaps you have to try to reach him under the email addresses  that 
are listed below http://www.votools.de/english/contact.htm

Arne

"Lu" <lu2k@hotmail.com> schrieb im Newsbeitrag 
news:465faf33-17ee-414b-9870-9f741484d842@googlegroups.com...
> Hi Arne
>
> Thank you for your answer. The record groups are a great feature of the 
> bbrowser and I like them. I have already spent some days to check it out, 
> but now, I do not know what I can try to fix the problem 1.
> Problem 2 I can fix with the option 'grid in empty area' = false. The 
> users do not like this option but it would solve the problem.
> Would it be possible that you show me your changes Arne?
>
> Lu
>
> 

[toc] | [prev] | [next] | [standalone]


#9788

FromJoachim Bieler <support@votools.com>
Date2016-10-10 07:30 +0200
Message-ID<e60ncdF7lliU1@mid.individual.net>
In reply to#9781
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

[toc] | [prev] | [next] | [standalone]


#9789

From"Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it>
Date2016-10-10 10:54 +0200
Message-ID<ntfl0h$h1l$1@dont-email.me>
In reply to#9788
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" <support@votools.com> 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
> 

[toc] | [prev] | [next] | [standalone]


#9791

FromJoachim Bieler <support@votools.com>
Date2016-10-11 07:45 +0200
Message-ID<e63cjaFr8mmU1@mid.individual.net>
In reply to#9789
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" <support@votools.com> 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
>>
>

[toc] | [prev] | [next] | [standalone]


#9793

FromLu <lu2k@hotmail.com>
Date2016-10-11 00:19 -0700
Message-ID<83bdd049-b443-426c-b926-ce3c1c880c16@googlegroups.com>
In reply to#9791
Thank you for your replys. The application is to big and would not work without SQL-Server so it is not possible for me to send you an AEF file. I try to get the problems in the sample, but there the problems does not exit. Mybe the problems occur because the data comes from a procedure. There is no bArrayServer.

I realized, when I add an empty row at the end of the data, problem 1 does not occur and the sub records in the last row are correct shown.
The used data are int and varchar from the sql server. The group key is a varchar. The owner alignment ob the bbrowser is set to Auto. 
Maybe you have some hints, because of the vertical scroll bar.

Lu

[toc] | [prev] | [next] | [standalone]


#9795

From"Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it>
Date2016-10-11 09:31 +0200
Message-ID<nti4gb$cd6$1@dont-email.me>
In reply to#9791
Hi Joachim,
yes, this has got really well!

Arne

"Joachim Bieler" <support@votools.com> schrieb im Newsbeitrag 
news:e63cjaFr8mmU1@mid.individual.net...
> 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" <support@votools.com> 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
>>>
>>
> 

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web