Search results for query: *

Hey folks, at the moment I really don't think this is possible but decided to throw it on here to see if there were any ideas. Essentially, I would like a way to grab any 1) arbitrary table (that I have permissions to) in DBMS that I have an ODBC connection too; 2) A column in that table and...

Alas, quoting everything seems to work fine for Oracle and PostgresSQL but does NOT function on MySQL....

I feel like an idiot lol. You can simply quote everything, even if it's not quoted. It wasn't working before because I was saying SELECT "Special Table.Special Column" FROM "Special Table" which kept not working on me....then I woke up and realized that the separator needs to be on the outside...

Hey, Thanks for replying! Yes, that is what I am considering doing, but it isn't fool proof. Flagging a table name for special characters will only work as long as special characters are used in a quoted name. The quoted name "TEST" will not work, but also won't get flagged since there are no...

In most DBMS's I've used, you can create Tables and Columns with names enclosed in quotes which can include special characters and is case sensitive. Using SQL (both natively and from ODBC), you usually have to include the quotes in the call (i.e. SELECT "I,D 1" FROM "I,AM A Special Table" This...