Transect Data Query Syntax Error

envisionnw / invasives_rpts

invasive species reporting

0 stars 0 forks source link

Transect Data Query Syntax Error #55

Closed envisionnw closed 7 years ago

envisionnw commented 7 years ago

Issue by NCPN Tuesday Jun 20, 2017 at 03:02 GMT _Originally opened as https://github.com/NCPN/invasives_rpts/issues/55_

The transect data query does not seem to run. Each combination of park and year I have tried generates a syntax error (error #3075). See attached file for screen captures. TransectDataQuerySyntaxError.docx

envisionnw commented 7 years ago

Issue related to filter (WHERE clause) saved with Transect_Data. Once removed query runs w/o error.

Fix includes WHERE clause removal and button click improvements which check for similar issues and remove any existing "WHERE..." while building the appropriately filtered query.