1

Topic: Filtering to survey names containing left bracket

When trying to filter the observation hierarchy to show all survey names with a left bracket ( in them I get:

date/time         : 2016-12-15, 16:15:06, 975ms
computer name     : LBP2
user name         : charliebarnes
registered owner  : User
operating system  : Windows 7 Service Pack 1 build 7601
system language   : English
system up time    : 6 hours 29 minutes
program up time   : 50 seconds
processors        : 2x Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz
physical memory   : 1767/3037 MB (free/total)
free disk space   : (C:) 193.39 GB
display mode      : 1920x1080, 32 bit
process id        : $1e18
allocated memory  : 66.23 MB
command line      : RecorderApp.exe /394750
executable        : RecorderApp.exe
exec. date/time   : 2016-09-11 16:10
version           : 6.26.0.0
compiled with     : Delphi 7
madExcept version : 3.0o
callstack crc     : $8d745569, $918dd016, $918dd016
exception number  : 4
exception class   : EOleException
exception message : Incorrect syntax near the keyword 'check'.

Presumably the criterion field isn't being sanitized correctly.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

2

Re: Filtering to survey names containing left bracket

I thought this woud be easy to fix, but it isn't as it is being caused by code which is widely used throughout the application. I have logged it as a problem as it requires more work to identify a fix which doesn't have implications elsewhere.

Mike Weideli

3

Re: Filtering to survey names containing left bracket

Thanks Mike - first time I've come across it, and a rather esoteric edge case.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership