Tim Moores wrote:Is your table really named "Table"? It's better not to use SQL keywords for names; that may well be the problem here.
VERY likely. Also, I don't recommend using upper-case letters in table names, as results can be strange depending on the DBMS being used.
It's possible to name database tables - and other database resources - using reserved words, but then you have to use an "escape" mechanism so as to not confuse the SQL compiler. It's simply better to avoid those words.
The secret of how to be miserable is to constantly expect things are going to happen the way that they are "supposed" to happen.
You can have faith, which carries the understanding that you may be disappointed. Then there's being a willfully-blind idiot, which virtually guarantees it.