Filter on Browse

[kong]

Hi,

I could not get the Browse filter to work correctly in my application.
I am using NT6.27 and my backend is MSSQL 2008
I have gone thru example Web33 and seems that I am missing something.
 
I created a Browse and an Update form.
The browse will filter and display all 'Active = 1' transactions.
When calling the Update form to set the record to 'Active=0' and upon returning to the Browse, the Browse will display "No records found" message.
I need to refresh the Browse or exit and return to the Browse before I could see the records again.
However, if I called the update form via popup or changed the Browse to FileLoad instead of PageLoad, everything works perfectly.
 
I have also created various Browses with different Tables and this behaviour is consistent.
 
I would appreciate any assistance on this matter.

Thanks !

[Bruce]

Hi Kong,

First a question;
What have you set your browse filter to in the template? ie what is the exact code of the filter?

Second;
On the browse template is a new switch, on the general tab, "Send Filter, Order to Debugview". Tick that on, then run Debugview (www.sysinternals.com) and you'll be able to see the Filter expression as it is seen by the VIEW engine.

Paste that here as well, both the instance where it works, and the one where it fails. (tip: You can Ctrl-C a line out of Debugview)

Cheers
Bruce

[kong]

Hi Bruce,

>>First a question;
>>What have you set your browse filter to in the template? ie what is the exact code of the filter?

The exact code for the filter in the template is : ' ICOU:ACTIVE = 1 '
ICOU:ACTIVE is a byte field

>>Second;
>>On the browse template is a new switch, on the general tab, "Send Filter, Order to Debugview". Tick that on, then run Debugview (www.sysinternals.com) >>and you'll be able to see the Filter expression as it is seen by the VIEW engine.

When the browse first opens:
[2816] [netTrace][thread=3] Filter:  ICOU:ACTIVE = 1

After updating and returning to the browse:
[2816] [netTrace][thread=3] Filter:  ICOU:ACTIVE = 1
Although there are about 200 records, the browse displays a "no record found' message.
I need to click on the 'Clear' locator button before the browse re-display the records again.

As mentioned earlier, if I called the update form via popup or set the browse to Page loading with the same filter, it works perfectly.

Thanks !

[Bruce]

nothing obvious springs to mind - can you make an example for me?

cheers
Bruce

[kong]

Hi Bruce,

As requested, attached please find test2.zip for your investigation and testing.
I have also included a sql script for creating the table in the zip file.

Thanks !



[attachment deleted by admin]