Microsoft has no scruples

G

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.
 
G

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.
 
D

Dirk Goldgar

George Hester said:
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.
Click to expand...


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.
 
K

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.
 
Top