NetTalk Central

Author Topic: NetWebBrowse Questions  (Read 3592 times)

rupertvz

  • Sr. Member
  • ****
  • Posts: 323
    • View Profile
    • Email
NetWebBrowse Questions
« on: February 08, 2017, 05:01:27 AM »
Hi Guys,

I have a NetWebBrowse reading from a SQL table,

The data set is quite large, but I am limiting records on year, gender and province, which reduces the number of displayed records significantly.
The filter for the year, province, and gender is working well, however, as soon as I add the ID number to the filter I get "no records" displayed
(see filter string in screen grab .. this is the actual value of the filter string)
The column type in SQL is a CString

Also, when clicking on the NWB column headers, it is taking extremely long to open the "search" box.  Is there a way to speed this up?
For example:  Filtered on date, gender and province, one would like to click on the column header and refine search for a specific individual by surname ...

Any ideas will be appreciated ...



Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11244
    • View Profile
Re: NetWebBrowse Questions
« Reply #1 on: February 08, 2017, 07:04:41 AM »
Hi Rupert,

Firstly, using a MESSAGE statement for debugging will definitly break things. The browse has a template switch so the filter can be sent to Debugview. Use that instead, and check the contents of the filter there. (Which may be different to here.)

The most likely reason for this filter to not return any records, is because none of the records in the database match these criteria.

cheers
Bruce


rupertvz

  • Sr. Member
  • ****
  • Posts: 323
    • View Profile
    • Email
Re: NetWebBrowse Questions
« Reply #2 on: February 09, 2017, 06:16:55 AM »
Hi Bruce,

Thank you!  I checked in the Debug view and the filter is exactly the same .. correct.

Although the record IS present in the database, it keeps refusing to display upon filter.
I've tried another record by ID number and that one displays correctly.

I went to the SQL SMS.  I ran a query on the problematic ID ... Management Studio is also not picking up the record.

I then searched by Name instead, and compared the ID of the problematic record to the successful one.

It seems that the ID number have been "right" justified in the NVARCHAR field.

Is there a way to use the NetWebBrowse filter that it picks up the problematic ID number?

Strangely in the NetWebBrowse this record displays correctly as per screen-grab.