Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #6487 > unrolled thread
| Started by | jonhn@iconz.co.nz |
|---|---|
| First post | 2014-01-10 23:08 -0800 |
| Last post | 2014-01-24 21:01 -0800 |
| Articles | 6 — 3 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
bBrowser 4 Vs bBrowser 1.5 (Illegal reference) jonhn@iconz.co.nz - 2014-01-10 23:08 -0800
Re: bBrowser 4 Vs bBrowser 1.5 (Illegal reference) "Jamal" <someone@example.com> - 2014-01-14 18:28 -0500
Re: bBrowser 4 Vs bBrowser 1.5 (Illegal reference) jonhn@iconz.co.nz - 2014-01-14 23:19 -0800
Re: bBrowser 4 Vs bBrowser 1.5 (Illegal reference) "Jamal" <someone@example.com> - 2014-01-15 14:08 -0500
Re: bBrowser 4 Vs bBrowser 1.5 (Illegal reference) "Gerhard Bunzel" <g.bunzel@domonet.de> - 2014-01-16 10:39 +0100
Re: bBrowser 4 Vs bBrowser 1.5 (Illegal reference) jonhn@iconz.co.nz - 2014-01-24 21:01 -0800
| From | jonhn@iconz.co.nz |
|---|---|
| Date | 2014-01-10 23:08 -0800 |
| Subject | bBrowser 4 Vs bBrowser 1.5 (Illegal reference) |
| Message-ID | <2c4ac06b-b9e0-418f-bdaa-0f4928080443@googlegroups.com> |
Having some trouble migrating my app to VO2.8 SP4b - been stuck on this one for 14 days now.
I have a couple of "lookup" windows where the user can filter their view of a database by typing a few characters into an SLE until they see the item in the list the want to select. For example a customer list.
This is one of the statements I use (all pretty standard stuff) SELF:SubServer:filter:= {|| xNAME $ Upper(Reference)}
Now, here's the thing - This has worked perfectly for about 10 years through VO 2.5, 2.6, 2.7b using bBrowser 1.4 and 1.5 I have just bought VO2.8 SP4b and bBrowser 4 and I am now getting the Illegal Reference error whenever the filtered list is clicked on. No error if no filter is set.
I have read the posts and warnings about using a codeblock to set a filter but have been unable to get a string filter to work properly, and with the following evidence, I wonder if it is a mistake I have made elsewhere, or something I have inadvertently skipped in moving from 2.7b to 2.8b4 Alternatively, how should that code block be expressed as a string? I have tried every iteration and combination I can think of to no avail so I can't be sure it is my block going out of scope causing my error.
How should this filter be expressed as a string, if that is the only way to fix this?
I have tried every combination I can think of but I can't set the filter as a string no matter what I try.
I use exactly the same method in 2 places for different lists- one of them works fine, the other not.
If the list is filtered to the point that one or two (max 2) records are visible, you can click on them without the error.
With filtered list showing 3+ records if you press Cancel a number of times the clicked record eventually shows selected, and then you can double-click to select THAT record without further errors.
If you click another item in the filtered list you then have to click "cancel" however many times until the new record is shown selected.
(The number of times you have to press Cancel is closely related to the number of records visible - this makes me think there is something being called in the bBrowser that I can perhaps avoid.
The filter works fine - it is just during the process of the browser moving to the selected record the error is thrown up.
Some of the relevant code is below, but AFAIK it is all standard bBrowser setup syntax.
The filter is set with this:
xNAME:=Upper(AllTrim(self:oDCSLEReference:TextValue))
self:oDCbBHireListing:Server:filter:= {|| xNAME $ Upper(REFerence)}
The bBrowser is set up with this:
SELF:oDCbBHireListing:use( DBIndex,{#INvno , #Acctname, #firstname, #INvdate, #Retdate, #Ordnumber, #Showname, #TOtal, #Deposit, #Delivery, #LONGterm, #Filetype, #SalesName, #REFERENCE } )
aoColumn := SELF:oDCbBHireListing:ColumnList
iSize := ALen(aoColumn)
iPos:=1
DO WHILE iPos< iSize+1
DO CASE
CASE iPos == 1
aoColumn[iPos]:Caption := "Hire No"
aoColumn[iPos]:Width := 45
aoColumn[iPos]:CaptionView:= oStyleNormal
CASE iPos == 2
aoColumn[iPos]:Caption := "Acct Name"
aoColumn[iPos]:Width := 120
aoColumn[iPos]:CaptionView:= oStyleSort
CASE iPos == 3
aoColumn[iPos]:Caption := "Ctc Name"
aoColumn[iPos]:Width := 60
aoColumn[iPos]:CaptionView:= oStyleNormal
CASE iPos == 4
<snipped due to repetition>
CASE iPos == 14
aoColumn[iPos]:Caption := "REF"
aoColumn[iPos]:Width := 60
aoColumn[iPos]:CaptionView:= oStyleNormal
ENDCASE
iPos++
ENDDO
SELF:oDCbBHireListing:Editable := FALSE
SELF:oDCbBHireListing:CurrentMode := #Line
SELF:oDCbBHireListing:EnableSelector(FALSE)
SELF:oDCbBHireListing:AutoEdit := FALSE
SELF:oDCbBHireListing:EnableCaptionClick(TRUE)
SELF:oDCbBHireListing:ViewLogicAs := #Check
SELF:oDCbBHireListing:SelectionMode := #Multiple
oColorCondition := bColorCondition{ "Server:retdate<today()",;
DBIndex,;
Color{255,6,13}}
SELF:oDCbBHireListing:ColorCondition:Add(oColorCondition)
Thanks for any suggestions in advance!
Kind regards,
Jonathan
[toc] | [next] | [standalone]
| From | "Jamal" <someone@example.com> |
|---|---|
| Date | 2014-01-14 18:28 -0500 |
| Message-ID | <lb4h7h$1ai$1@speranza.aioe.org> |
| In reply to | #6487 |
Are you still stuck on this issue?
What reference? Is a field name? If so, try prefixing it with _FIELD->
i.e. _FIELD->REFERENCE
Could you possibly use a sub index with a condition which would be a lot
faster? I just do not recommend using filters.
Jamal
wrote in message
news:2c4ac06b-b9e0-418f-bdaa-0f4928080443@googlegroups.com...
Having some trouble migrating my app to VO2.8 SP4b - been stuck on this one
for 14 days now.
I have a couple of "lookup" windows where the user can filter their view of
a database by typing a few characters into an SLE until they see the item
in the list the want to select. For example a customer list.
This is one of the statements I use (all pretty standard stuff)
SELF:SubServer:filter:= {|| xNAME $ Upper(Reference)}
Now, here's the thing - This has worked perfectly for about 10 years through
VO 2.5, 2.6, 2.7b using bBrowser 1.4 and 1.5 I have just bought VO2.8 SP4b
and bBrowser 4 and I am now getting the Illegal Reference error whenever the
filtered list is clicked on. No error if no filter is set.
I have read the posts and warnings about using a codeblock to set a filter
but have been unable to get a string filter to work properly, and with the
following evidence, I wonder if it is a mistake I have made elsewhere, or
something I have inadvertently skipped in moving from 2.7b to 2.8b4
Alternatively, how should that code block be expressed as a string? I have
tried every iteration and combination I can think of to no avail so I can't
be sure it is my block going out of scope causing my error.
How should this filter be expressed as a string, if that is the only way to
fix this?
I have tried every combination I can think of but I can't set the filter as
a string no matter what I try.
I use exactly the same method in 2 places for different lists- one of them
works fine, the other not.
If the list is filtered to the point that one or two (max 2) records are
visible, you can click on them without the error.
With filtered list showing 3+ records if you press Cancel a number of times
the clicked record eventually shows selected, and then you can double-click
to select THAT record without further errors.
If you click another item in the filtered list you then have to click
"cancel" however many times until the new record is shown selected.
(The number of times you have to press Cancel is closely related to the
number of records visible - this makes me think there is something being
called in the bBrowser that I can perhaps avoid.
The filter works fine - it is just during the process of the browser moving
to the selected record the error is thrown up.
Some of the relevant code is below, but AFAIK it is all standard bBrowser
setup syntax.
The filter is set with this:
xNAME:=Upper(AllTrim(self:oDCSLEReference:TextValue))
self:oDCbBHireListing:Server:filter:= {|| xNAME $ Upper(REFerence)}
The bBrowser is set up with this:
SELF:oDCbBHireListing:use( DBIndex,{#INvno , #Acctname, #firstname,
#INvdate, #Retdate, #Ordnumber, #Showname, #TOtal, #Deposit, #Delivery,
#LONGterm, #Filetype, #SalesName, #REFERENCE } )
aoColumn := SELF:oDCbBHireListing:ColumnList
iSize := ALen(aoColumn)
iPos:=1
DO WHILE iPos< iSize+1
DO CASE
CASE iPos == 1
aoColumn[iPos]:Caption := "Hire No"
aoColumn[iPos]:Width := 45
aoColumn[iPos]:CaptionView:= oStyleNormal
CASE iPos == 2
aoColumn[iPos]:Caption := "Acct Name"
aoColumn[iPos]:Width := 120
aoColumn[iPos]:CaptionView:= oStyleSort
CASE iPos == 3
aoColumn[iPos]:Caption := "Ctc Name"
aoColumn[iPos]:Width := 60
aoColumn[iPos]:CaptionView:= oStyleNormal
CASE iPos == 4
<snipped due to repetition>
CASE iPos == 14
aoColumn[iPos]:Caption := "REF"
aoColumn[iPos]:Width := 60
aoColumn[iPos]:CaptionView:= oStyleNormal
ENDCASE
iPos++
ENDDO
SELF:oDCbBHireListing:Editable := FALSE
SELF:oDCbBHireListing:CurrentMode := #Line
SELF:oDCbBHireListing:EnableSelector(FALSE)
SELF:oDCbBHireListing:AutoEdit := FALSE
SELF:oDCbBHireListing:EnableCaptionClick(TRUE)
SELF:oDCbBHireListing:ViewLogicAs := #Check
SELF:oDCbBHireListing:SelectionMode := #Multiple
oColorCondition := bColorCondition{ "Server:retdate<today()",;
DBIndex,;
Color{255,6,13}}
SELF:oDCbBHireListing:ColorCondition:Add(oColorCondition)
Thanks for any suggestions in advance!
Kind regards,
Jonathan
[toc] | [prev] | [next] | [standalone]
| From | jonhn@iconz.co.nz |
|---|---|
| Date | 2014-01-14 23:19 -0800 |
| Message-ID | <70fcc1dc-807f-4705-a558-fa64d10dd7ce@googlegroups.com> |
| In reply to | #6495 |
Yes, still stuck.
_FIELD-> doesn't help, thanks.
The filtered list is really quick, I can mouseover the filtered records and some tooltip code I have displays extra content of the record ok - it seems to work perfectly (and has for 8 years!)
My problem seems to be only when the database is filtered and one of the filtered records is selected (by clicking or by using the arrow keys), the illegal reference error occurs while the bBrowser is moving to the intended record, and then the record is selected and can be double-clicked.
The beautiful thing about the filter is I can wildcard what the user types in the SLE against the field contents for a very powerful search and locate function.
Can I do something similar with a sub index with conditions do you think?
Thanks!
On Wednesday, January 15, 2014 12:28:47 PM UTC+13, Jamal wrote:
> Are you still stuck on this issue?
>
>
>
> What reference? Is a field name? If so, try prefixing it with _FIELD->
>
> i.e. _FIELD->REFERENCE
>
>
>
> Could you possibly use a sub index with a condition which would be a lot
>
> faster? I just do not recommend using filters.
>
>
>
> Jamal
>
>
>
> wrote in message
>
> news:2c4ac06b-b9e0-418f-bdaa-0f4928080443@googlegroups.com...
>
>
>
> Having some trouble migrating my app to VO2.8 SP4b - been stuck on this one
>
> for 14 days now.
>
>
>
> I have a couple of "lookup" windows where the user can filter their view of
>
> a database by typing a few characters into an SLE until they see the item
>
> in the list the want to select. For example a customer list.
>
>
>
> This is one of the statements I use (all pretty standard stuff)
>
> SELF:SubServer:filter:= {|| xNAME $ Upper(Reference)}
>
>
>
>
>
> Now, here's the thing - This has worked perfectly for about 10 years through
>
> VO 2.5, 2.6, 2.7b using bBrowser 1.4 and 1.5 I have just bought VO2.8 SP4b
>
> and bBrowser 4 and I am now getting the Illegal Reference error whenever the
>
> filtered list is clicked on. No error if no filter is set.
>
>
>
>
>
> I have read the posts and warnings about using a codeblock to set a filter
>
> but have been unable to get a string filter to work properly, and with the
>
> following evidence, I wonder if it is a mistake I have made elsewhere, or
>
> something I have inadvertently skipped in moving from 2.7b to 2.8b4
>
> Alternatively, how should that code block be expressed as a string? I have
>
> tried every iteration and combination I can think of to no avail so I can't
>
> be sure it is my block going out of scope causing my error.
>
>
>
>
>
> How should this filter be expressed as a string, if that is the only way to
>
> fix this?
>
> I have tried every combination I can think of but I can't set the filter as
>
> a string no matter what I try.
>
>
>
>
>
> I use exactly the same method in 2 places for different lists- one of them
>
> works fine, the other not.
>
>
>
> If the list is filtered to the point that one or two (max 2) records are
>
> visible, you can click on them without the error.
>
>
>
> With filtered list showing 3+ records if you press Cancel a number of times
>
> the clicked record eventually shows selected, and then you can double-click
>
> to select THAT record without further errors.
>
> If you click another item in the filtered list you then have to click
>
> "cancel" however many times until the new record is shown selected.
>
> (The number of times you have to press Cancel is closely related to the
>
> number of records visible - this makes me think there is something being
>
> called in the bBrowser that I can perhaps avoid.
>
>
>
> The filter works fine - it is just during the process of the browser moving
>
> to the selected record the error is thrown up.
>
>
>
> Some of the relevant code is below, but AFAIK it is all standard bBrowser
>
> setup syntax.
>
>
>
>
>
> The filter is set with this:
>
> xNAME:=Upper(AllTrim(self:oDCSLEReference:TextValue))
>
> self:oDCbBHireListing:Server:filter:= {|| xNAME $ Upper(REFerence)}
>
>
>
>
>
>
>
> The bBrowser is set up with this:
>
>
>
> SELF:oDCbBHireListing:use( DBIndex,{#INvno , #Acctname, #firstname,
>
> #INvdate, #Retdate, #Ordnumber, #Showname, #TOtal, #Deposit, #Delivery,
>
> #LONGterm, #Filetype, #SalesName, #REFERENCE } )
>
>
>
>
>
> aoColumn := SELF:oDCbBHireListing:ColumnList
>
> iSize := ALen(aoColumn)
>
> iPos:=1
>
> DO WHILE iPos< iSize+1
>
> DO CASE
>
> CASE iPos == 1
>
> aoColumn[iPos]:Caption := "Hire No"
>
> aoColumn[iPos]:Width := 45
>
> aoColumn[iPos]:CaptionView:= oStyleNormal
>
> CASE iPos == 2
>
> aoColumn[iPos]:Caption := "Acct Name"
>
> aoColumn[iPos]:Width := 120
>
> aoColumn[iPos]:CaptionView:= oStyleSort
>
> CASE iPos == 3
>
> aoColumn[iPos]:Caption := "Ctc Name"
>
> aoColumn[iPos]:Width := 60
>
> aoColumn[iPos]:CaptionView:= oStyleNormal
>
> CASE iPos == 4
>
>
>
> <snipped due to repetition>
>
>
>
> CASE iPos == 14
>
> aoColumn[iPos]:Caption := "REF"
>
> aoColumn[iPos]:Width := 60
>
> aoColumn[iPos]:CaptionView:= oStyleNormal
>
>
>
>
>
> ENDCASE
>
> iPos++
>
> ENDDO
>
>
>
> SELF:oDCbBHireListing:Editable := FALSE
>
> SELF:oDCbBHireListing:CurrentMode := #Line
>
> SELF:oDCbBHireListing:EnableSelector(FALSE)
>
> SELF:oDCbBHireListing:AutoEdit := FALSE
>
> SELF:oDCbBHireListing:EnableCaptionClick(TRUE)
>
> SELF:oDCbBHireListing:ViewLogicAs := #Check
>
> SELF:oDCbBHireListing:SelectionMode := #Multiple
>
>
>
>
>
>
>
> oColorCondition := bColorCondition{ "Server:retdate<today()",;
>
> DBIndex,;
>
> Color{255,6,13}}
>
> SELF:oDCbBHireListing:ColorCondition:Add(oColorCondition)
>
>
>
>
>
> Thanks for any suggestions in advance!
>
>
>
> Kind regards,
>
> Jonathan
[toc] | [prev] | [next] | [standalone]
| From | "Jamal" <someone@example.com> |
|---|---|
| Date | 2014-01-15 14:08 -0500 |
| Message-ID | <lb6mbf$2nn$1@speranza.aioe.org> |
| In reply to | #6496 |
What is the exact error message? Is it generated in the VOERROR.LOG? Please
list here.
Can you provide a small sample to duplicate the issue? You can email me at
vodotnet (at) gmail.com.
Jamal
wrote in message
news:70fcc1dc-807f-4705-a558-fa64d10dd7ce@googlegroups.com...
Yes, still stuck.
_FIELD-> doesn't help, thanks.
The filtered list is really quick, I can mouseover the filtered records and
some tooltip code I have displays extra content of the record ok - it seems
to work perfectly (and has for 8 years!)
My problem seems to be only when the database is filtered and one of the
filtered records is selected (by clicking or by using the arrow keys), the
illegal reference error occurs while the bBrowser is moving to the intended
record, and then the record is selected and can be double-clicked.
The beautiful thing about the filter is I can wildcard what the user types
in the SLE against the field contents for a very powerful search and locate
function.
Can I do something similar with a sub index with conditions do you think?
Thanks!
On Wednesday, January 15, 2014 12:28:47 PM UTC+13, Jamal wrote:
> Are you still stuck on this issue?
>
>
>
> What reference? Is a field name? If so, try prefixing it with _FIELD->
>
> i.e. _FIELD->REFERENCE
>
>
>
> Could you possibly use a sub index with a condition which would be a lot
>
> faster? I just do not recommend using filters.
>
>
>
> Jamal
>
>
>
> wrote in message
>
> news:2c4ac06b-b9e0-418f-bdaa-0f4928080443@googlegroups.com...
>
>
>
> Having some trouble migrating my app to VO2.8 SP4b - been stuck on this
> one
>
> for 14 days now.
>
>
>
> I have a couple of "lookup" windows where the user can filter their view
> of
>
> a database by typing a few characters into an SLE until they see the item
>
> in the list the want to select. For example a customer list.
>
>
>
> This is one of the statements I use (all pretty standard stuff)
>
> SELF:SubServer:filter:= {|| xNAME $ Upper(Reference)}
>
>
>
>
>
> Now, here's the thing - This has worked perfectly for about 10 years
> through
>
> VO 2.5, 2.6, 2.7b using bBrowser 1.4 and 1.5 I have just bought VO2.8 SP4b
>
> and bBrowser 4 and I am now getting the Illegal Reference error whenever
> the
>
> filtered list is clicked on. No error if no filter is set.
>
>
>
>
>
> I have read the posts and warnings about using a codeblock to set a filter
>
> but have been unable to get a string filter to work properly, and with the
>
> following evidence, I wonder if it is a mistake I have made elsewhere, or
>
> something I have inadvertently skipped in moving from 2.7b to 2.8b4
>
> Alternatively, how should that code block be expressed as a string? I have
>
> tried every iteration and combination I can think of to no avail so I
> can't
>
> be sure it is my block going out of scope causing my error.
>
>
>
>
>
> How should this filter be expressed as a string, if that is the only way
> to
>
> fix this?
>
> I have tried every combination I can think of but I can't set the filter
> as
>
> a string no matter what I try.
>
>
>
>
>
> I use exactly the same method in 2 places for different lists- one of them
>
> works fine, the other not.
>
>
>
> If the list is filtered to the point that one or two (max 2) records are
>
> visible, you can click on them without the error.
>
>
>
> With filtered list showing 3+ records if you press Cancel a number of
> times
>
> the clicked record eventually shows selected, and then you can
> double-click
>
> to select THAT record without further errors.
>
> If you click another item in the filtered list you then have to click
>
> "cancel" however many times until the new record is shown selected.
>
> (The number of times you have to press Cancel is closely related to the
>
> number of records visible - this makes me think there is something being
>
> called in the bBrowser that I can perhaps avoid.
>
>
>
> The filter works fine - it is just during the process of the browser
> moving
>
> to the selected record the error is thrown up.
>
>
>
> Some of the relevant code is below, but AFAIK it is all standard bBrowser
>
> setup syntax.
>
>
>
>
>
> The filter is set with this:
>
> xNAME:=Upper(AllTrim(self:oDCSLEReference:TextValue))
>
> self:oDCbBHireListing:Server:filter:= {|| xNAME $ Upper(REFerence)}
>
>
>
>
>
>
>
> The bBrowser is set up with this:
>
>
>
> SELF:oDCbBHireListing:use( DBIndex,{#INvno , #Acctname, #firstname,
>
> #INvdate, #Retdate, #Ordnumber, #Showname, #TOtal, #Deposit, #Delivery,
>
> #LONGterm, #Filetype, #SalesName, #REFERENCE } )
>
>
>
>
>
> aoColumn := SELF:oDCbBHireListing:ColumnList
>
> iSize := ALen(aoColumn)
>
> iPos:=1
>
> DO WHILE iPos< iSize+1
>
> DO CASE
>
> CASE iPos == 1
>
> aoColumn[iPos]:Caption := "Hire No"
>
> aoColumn[iPos]:Width := 45
>
> aoColumn[iPos]:CaptionView:= oStyleNormal
>
> CASE iPos == 2
>
> aoColumn[iPos]:Caption := "Acct Name"
>
> aoColumn[iPos]:Width := 120
>
> aoColumn[iPos]:CaptionView:= oStyleSort
>
> CASE iPos == 3
>
> aoColumn[iPos]:Caption := "Ctc Name"
>
> aoColumn[iPos]:Width := 60
>
> aoColumn[iPos]:CaptionView:= oStyleNormal
>
> CASE iPos == 4
>
>
>
> <snipped due to repetition>
>
>
>
> CASE iPos == 14
>
> aoColumn[iPos]:Caption := "REF"
>
> aoColumn[iPos]:Width := 60
>
> aoColumn[iPos]:CaptionView:= oStyleNormal
>
>
>
>
>
> ENDCASE
>
> iPos++
>
> ENDDO
>
>
>
> SELF:oDCbBHireListing:Editable := FALSE
>
> SELF:oDCbBHireListing:CurrentMode := #Line
>
> SELF:oDCbBHireListing:EnableSelector(FALSE)
>
> SELF:oDCbBHireListing:AutoEdit := FALSE
>
> SELF:oDCbBHireListing:EnableCaptionClick(TRUE)
>
> SELF:oDCbBHireListing:ViewLogicAs := #Check
>
> SELF:oDCbBHireListing:SelectionMode := #Multiple
>
>
>
>
>
>
>
> oColorCondition := bColorCondition{ "Server:retdate<today()",;
>
> DBIndex,;
>
> Color{255,6,13}}
>
> SELF:oDCbBHireListing:ColorCondition:Add(oColorCondition)
>
>
>
>
>
> Thanks for any suggestions in advance!
>
>
>
> Kind regards,
>
> Jonathan
[toc] | [prev] | [next] | [standalone]
| From | "Gerhard Bunzel" <g.bunzel@domonet.de> |
|---|---|
| Date | 2014-01-16 10:39 +0100 |
| Message-ID | <lb89af$op4$1@news.m-online.net> |
| In reply to | #6487 |
Jonathan,
is xNAME for your filter a LOCAL?
>self:oDCbBHireListing:Server:filter:= {|| xNAME $ Upper(REFerence)}
Try to set your filter as a string:
cFilter := '"' + xNAME + '" $ UPPER(REFERENCE)'
self:oDCbBHireListing:Server:filter:= cFilter
HTH
Gerhard Bunzel
<jonhn@iconz.co.nz> schrieb im Newsbeitrag
news:2c4ac06b-b9e0-418f-bdaa-0f4928080443@googlegroups.com...
Having some trouble migrating my app to VO2.8 SP4b - been stuck on this one
for 14 days now.
I have a couple of "lookup" windows where the user can filter their view of
a database by typing a few characters into an SLE until they see the item
in the list the want to select. For example a customer list.
This is one of the statements I use (all pretty standard stuff)
SELF:SubServer:filter:= {|| xNAME $ Upper(Reference)}
Now, here's the thing - This has worked perfectly for about 10 years through
VO 2.5, 2.6, 2.7b using bBrowser 1.4 and 1.5 I have just bought VO2.8 SP4b
and bBrowser 4 and I am now getting the Illegal Reference error whenever the
filtered list is clicked on. No error if no filter is set.
I have read the posts and warnings about using a codeblock to set a filter
but have been unable to get a string filter to work properly, and with the
following evidence, I wonder if it is a mistake I have made elsewhere, or
something I have inadvertently skipped in moving from 2.7b to 2.8b4
Alternatively, how should that code block be expressed as a string? I have
tried every iteration and combination I can think of to no avail so I can't
be sure it is my block going out of scope causing my error.
How should this filter be expressed as a string, if that is the only way to
fix this?
I have tried every combination I can think of but I can't set the filter as
a string no matter what I try.
I use exactly the same method in 2 places for different lists- one of them
works fine, the other not.
If the list is filtered to the point that one or two (max 2) records are
visible, you can click on them without the error.
With filtered list showing 3+ records if you press Cancel a number of times
the clicked record eventually shows selected, and then you can double-click
to select THAT record without further errors.
If you click another item in the filtered list you then have to click
"cancel" however many times until the new record is shown selected.
(The number of times you have to press Cancel is closely related to the
number of records visible - this makes me think there is something being
called in the bBrowser that I can perhaps avoid.
The filter works fine - it is just during the process of the browser moving
to the selected record the error is thrown up.
Some of the relevant code is below, but AFAIK it is all standard bBrowser
setup syntax.
The filter is set with this:
xNAME:=Upper(AllTrim(self:oDCSLEReference:TextValue))
self:oDCbBHireListing:Server:filter:= {|| xNAME $ Upper(REFerence)}
The bBrowser is set up with this:
SELF:oDCbBHireListing:use( DBIndex,{#INvno , #Acctname, #firstname,
#INvdate, #Retdate, #Ordnumber, #Showname, #TOtal, #Deposit, #Delivery,
#LONGterm, #Filetype, #SalesName, #REFERENCE } )
aoColumn := SELF:oDCbBHireListing:ColumnList
iSize := ALen(aoColumn)
iPos:=1
DO WHILE iPos< iSize+1
DO CASE
CASE iPos == 1
aoColumn[iPos]:Caption := "Hire No"
aoColumn[iPos]:Width := 45
aoColumn[iPos]:CaptionView:= oStyleNormal
CASE iPos == 2
aoColumn[iPos]:Caption := "Acct Name"
aoColumn[iPos]:Width := 120
aoColumn[iPos]:CaptionView:= oStyleSort
CASE iPos == 3
aoColumn[iPos]:Caption := "Ctc Name"
aoColumn[iPos]:Width := 60
aoColumn[iPos]:CaptionView:= oStyleNormal
CASE iPos == 4
<snipped due to repetition>
CASE iPos == 14
aoColumn[iPos]:Caption := "REF"
aoColumn[iPos]:Width := 60
aoColumn[iPos]:CaptionView:= oStyleNormal
ENDCASE
iPos++
ENDDO
SELF:oDCbBHireListing:Editable := FALSE
SELF:oDCbBHireListing:CurrentMode := #Line
SELF:oDCbBHireListing:EnableSelector(FALSE)
SELF:oDCbBHireListing:AutoEdit := FALSE
SELF:oDCbBHireListing:EnableCaptionClick(TRUE)
SELF:oDCbBHireListing:ViewLogicAs := #Check
SELF:oDCbBHireListing:SelectionMode := #Multiple
oColorCondition := bColorCondition{ "Server:retdate<today()",;
DBIndex,;
Color{255,6,13}}
SELF:oDCbBHireListing:ColorCondition:Add(oColorCondition)
Thanks for any suggestions in advance!
Kind regards,
Jonathan
[toc] | [prev] | [next] | [standalone]
| From | jonhn@iconz.co.nz |
|---|---|
| Date | 2014-01-24 21:01 -0800 |
| Message-ID | <cdda0897-e79b-4da5-bdb8-73d0a8b552a3@googlegroups.com> |
| In reply to | #6510 |
Thank you Gerhard and Jamal,
Gerhard's suggestion works perfectly - I need to rewrite all the filters now, but at least I have a solution and the correct syntax.
I really appreciate the thought and time you gave this for me - I will have a beer for each of you tonight to say "THANKS!"
Best regards,
Jonathan
On Thursday, January 16, 2014 10:39:10 PM UTC+13, Gerhard Bunzel wrote:
> Jonathan,
>
>
>
> is xNAME for your filter a LOCAL?
> >self:oDCbBHireListing:Server:filter:= {|| xNAME $ Upper(REFerence)}
>
> Try to set your filter as a string:
>
> cFilter := '"' + xNAME + '" $ UPPER(REFERENCE)'
>
> self:oDCbBHireListing:Server:filter:= cFilter
>
> HTH
> Gerhard Bunzel
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.clipper.visual-objects
csiph-web