Locator Type Starts-With returns blank browse

[Ubaidullah]

Hi Bruce,

In a NetWebBrowse, I set the Locator Type of a column to "Starts-With" in the Sort tab of the column.

The browse shows correctly when the locator is blank. But as soon as I type anything, the browse goes blank.

The SQL code being sent has this WHERE clause when I type 'A' in the locator:

WHERE D.NAME >= 'A' AND D.NAME <= 'A'

Which obviously returns no results. This should be:

WHERE D.NAME like 'A%'


What am I doing wrong and how can I fix it?

ps. Is there an example for SQL that I can use to showcase SQL related issues?

Regards,
Ubaidullah Nubar.

[urayoan]

Hi:
  Try this in your code at template level and check this solves the problem.
  First, check in the sort tab if you have set the default locator field (check screenshot). Select the field that does apply in your case.

Then, int he locate tab, set the locator type to your needs (check screenshot).

[Ubaidullah]

Hi,

Thanks for the suggestion.
I did as suggested. No difference.

Regards,
Ubaidullah Nubar.

[Bruce]

Hi Ubaidullah,

>> WHERE D.NAME >= 'A' AND D.NAME <= 'A'

actually what it creates is

>> WHERE D.NAME >= 'A' AND D.NAME <= 'A<254>'

the code is "database neutral" so doesn't translate to the SQL LIKE command. (at least not yet).

the code is in netweb.clw in the MakeFilter method. You might experiment with replacing <254> with a hyphen ( - ) as this is char<126> and so would survive any translation to utf-8.
Let us know if that works.

Cheers
Bruce