Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #9781 > unrolled thread
| Started by | Lu <lu2k@hotmail.com> |
|---|---|
| First post | 2016-10-06 06:01 -0700 |
| Last post | 2016-10-11 09:31 +0200 |
| Articles | 10 — 3 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | Lu <lu2k@hotmail.com> |
|---|---|
| Date | 2016-10-06 06:01 -0700 |
| Subject | Problem 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]
| From | Lu <lu2k@hotmail.com> |
|---|---|
| Date | 2016-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]
| From | "Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it> |
|---|---|
| Date | 2016-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]
| From | Lu <lu2k@hotmail.com> |
|---|---|
| Date | 2016-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]
| From | "Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it> |
|---|---|
| Date | 2016-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]
| From | Joachim Bieler <support@votools.com> |
|---|---|
| Date | 2016-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]
| From | "Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it> |
|---|---|
| Date | 2016-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]
| From | Joachim Bieler <support@votools.com> |
|---|---|
| Date | 2016-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]
| From | Lu <lu2k@hotmail.com> |
|---|---|
| Date | 2016-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]
| From | "Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it> |
|---|---|
| Date | 2016-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