omnis odbc

Todd Wolford ztoddw at gmail.com
Wed Dec 15 11:17:19 EST 2010


Hi, I hope someone can help. I'm trying to use the OMNIS ODBC driver to
select from a table and it keeps saying Syntax error in SQL statement.  This
is my sql -

SELECT * from OMNIS.F-ROLODEX

I think it must be because there is a dash in the table name.  How can I get
past this error?  I just need to get the data out of that table.

I linked to this table successfully from Access 2007, and I can see the
table structure, but not any of the data.
I tried the following, and I get the same error in all cases.

SELECT * from [OMNIS.F-ROLODEX]
SELECT * from 'OMNIS.F-ROLODEX'
SELECT * from "OMNIS.F-ROLODEX"
SELECT * from `OMNIS.F-ROLODEX`

-- 
Todd Wolford
ztoddw at gmail.com



More information about the omnisdev-en mailing list