Topic: Rucksack generator error
Hi
Whilst creating a rucksack from a list of common names using the rucksack generator add-in I managed to cause an error so the generator failed. This appears to have been due to the species Parrot's-feather which initially could not be found (I was missing the hyphen) but then the rucksack creator failed completely when using the name written as above (copied directly from the R6 taxon dictionary). When I remove the apostrophe it works ok again, but obviously is then missing this species from the resultant rucksack.
The error was:
exception class : EOleException
exception message : Line 1: Incorrect syntax near 's'.
Is this an issue with the apostrophe and SQL syntax? Is there a way to overcome this as apostrophes are part of numerous species names and its not ideal to have to remove them and then add the species manually!
Thanks
Purgle
Wiltshire & Swindon Biological Records Centre