Error 3001 Invalid Argument

[Kirk P.]

I'm running a very simple query against an ODBC Oracle database.

SELECT DISTINCT GLKCO
FROM PRODDTA_F0911;

The query returns records, but when I try and save the query I get Error #
3001 Invalid Argument. What gives?

 

[Allen Browne]

Could the problem be Name AutoCorrect?

Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation:
http://allenbrowne.com/bug-03.html

Then compact the database:
Tools | Database Utilities | Compact

Then recreate the query from scratch.

If that does not solve the problem, and there are no other permission or
corruption issues, it's hard to imagine what could cause the error.