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