Microsoft has no scruples

[George Hester]

http://support.microsoft.com/kb/237377

The script in this example does not work. It will work with just one country
but that is it. The countries seperated by a ; does nothing. It will find
the first country in the semi-colon delimited list but the rest of the
script is worthless.

We can do a filter in the Access interface and look at the SQL to see how it
is really done.

 

[George Hester]

Well just a little fix here. In the statement in the script setServerFilter
in this part:

strFilter = Right(strFilter, Len(strFilter) - InStr(strFilter, _
";") - 1)

change it to:

strFilter = Right(strFilter, Len(strFilter) - InStr(strFilter, _
";") )

That will fix it.

 

[Dirk Goldgar]

Well just a little fix here. In the statement in the script
setServerFilter
in this part:

strFilter = Right(strFilter, Len(strFilter) - InStr(strFilter, _
";") - 1)

change it to:

strFilter = Right(strFilter, Len(strFilter) - InStr(strFilter, _
";") )

That will fix it.

It's kind of a jump from a bug in the code to Microsoft having no scruples,
isn't it? Sure, they should have tested it before posting it -- I'd say
it's fair to call them sloppy upon occasion.

 

[George Hester]

True. I am ashamed.

 

[Ken Snell \(MVP\)]

The error in the script example has been reported to MS. I expect that the
article will be corrected within the next few weeks or so.

 

[George Hester]

I think the same slight error in the script also appears here:

http://support.microsoft.com/kb/285162/en-us

Seems this script is used often at Microsoft to exhibit the use of
ServerFilter.

 

[Ken Snell \(MVP\)]

Reported. MS has already fixed the error in KB 237377.