Query Sage Database

  • Thread starter Thread starter Dave Bradshaw
  • Start date Start date
D

Dave Bradshaw

I am trying to construct a query that will return all the part numbers
that don't begin with a "Z" from a Sage Accounts database. I thought
it would be straightforward to just put
Not Like "P*"
in the criteria cell, but when I do I get an error:

ODBC call failed
Syntax Error: Invalid filter in WHERE clause (#0)

I suspect this is due to a problem with the Sage ODBC driver. Can
anyone confirm that this is the case, and can anyone suggest a work
around.

Thank you

Dave Bradshaw
 
Dave said:
I am trying to construct a query that will return all the part numbers
that don't begin with a "Z" from a Sage Accounts database. I thought
it would be straightforward to just put
Not Like "P*"
in the criteria cell, but when I do I get an error:

ODBC call failed
Syntax Error: Invalid filter in WHERE clause (#0)

I suspect this is due to a problem with the Sage ODBC driver. Can
anyone confirm that this is the case, and can anyone suggest a work
around.
Click to expand...

It might be the asterisk (*) wildcard character. Try the percent sign
(%) instead of the asterisk as the wildcard character.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL database record locks 2
Sage ODBC Driver 2
ASP.NET and sage communacation error 0
Sage Pro 1
update query ODBC--call failed 3
ODBC permissions 2
Invalid Argument error... 4
Using "like" from an external link 1

Back
Top