Jump to content
RockWare Support Forum
Molly

Incorrect Syntax Near ".." error in queries, when names have "#"

Recommended Posts

If you are working with RockWorks16, Level 5, and a SQL Server database, you may see this error if you are using one of the Borehole Manager query tools (View | Filter Boreholes or View | Select Boreholes), applying a Polygon Region query, AND your borehole names contain a "#" character (such as DH #1).

The next public upload of the program will contain a fix for this. It has to do with the different characters that Access and SQL use to mark date fields, and we were filtering out the "#" characters which in turn mucks up the borehole names.

In the meantime you'll need to perform the query with a rectilinear or circular region (which function differently), or remove the "#" characters from your borehole names.

Molly Mayfield

RockWare Inc.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×