Transect Data Query Syntax Error

NCPN / invasives_rpts

invasive species reporting

0 stars 2 forks source link

Transect Data Query Syntax Error #55

Closed blcampbell-NCPN closed 7 years ago

blcampbell-NCPN commented 7 years ago

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

blcampbell-NCPN 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.