The Browse Next & Previous don't work with MS SQL : Need to hit Refresh Browser

[britech]

Hi Folks,

I Have a Browse on a SQL table that is sorted on a unique key. For some reason, the Next, Last Previous, First buttons don't refresh the Browse. If I press Next , and then   hit F5 (refresh), I'm asked if I want to resend the request. When I do, then I get the Next page.

Is this problem familiar to anyone else and do you know of a cause/solution?
The browse works fine if I switch it to TPS.

This is happening on all my MS SQL browses.

Netalk 5 PR 25

6.3 9055

Brian

[kevin plummer]

Do your have MARS set on your connection?

If using FM3 drop this into the driver sting field on the global template.

/BUSYHANDLING=2 /MULTIPLEACTIVERESULTSETS=TRUE

I'm using MSSQL2005 and can't think what else would cause the prob except if a & is anywhere in a browse the buttons stop working although I think it would be the same for TPS. PR26 fixes this prob.

Let us know how you get on

Kev

[britech]

Thanks Kevin,

I'll download PR26 and try it.
This dict works fine with the other WIN32 apps on it and we have all the driver strings setup to deal with MS SQL.
Perhaps there was a problem in PR25.
I'll check that first .
Brian

[Alberto]

May be the problem is in a XHTML code in some column.
Hope this helps
Alberto

[britech]

OK I found the problem. One of my columns has values that may contain a  &   in the string.

If I replace the '&' character in all my data in the Company Name fields with a '+ ', the browses work fine.

This cannot possibly be the correct solution to this. I can't tell my clients not to use the '&' character.

Is there another work around to this ?


Brian

[zdpl0a]

Hi,

Bruce says this will be fixed in PR 26.  Your '&' should be accessed and displayed fine after that.  (It used to work)

Dave

[Bruce]

PR 26 is up.

[zdpl0a]

Both dowload sites?
The one I just downloaded was the same size as the one I downloaded on 7/7/2010

Dave

[Bruce]

sorry - didn't update the mirror site - is up there now as well.

cheers
Bruce