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


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

bBrowser 4 Vs bBrowser 1.5 (Illegal reference)

Started byjonhn@iconz.co.nz
First post2014-01-10 23:08 -0800
Last post2014-01-24 21:01 -0800
Articles 6 — 3 participants

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


Contents

  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

#6487 — bBrowser 4 Vs bBrowser 1.5 (Illegal reference)

Fromjonhn@iconz.co.nz
Date2014-01-10 23:08 -0800
SubjectbBrowser 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]


#6495

From"Jamal" <someone@example.com>
Date2014-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]


#6496

Fromjonhn@iconz.co.nz
Date2014-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]


#6503

From"Jamal" <someone@example.com>
Date2014-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]


#6510

From"Gerhard Bunzel" <g.bunzel@domonet.de>
Date2014-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]


#6557

Fromjonhn@iconz.co.nz
Date2014-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