omnis odbc

[Todd Wolford]

Yeah, just tried it- still the same error message. Any other suggestion?


On Wed, Dec 15, 2010 at 9:53 AM, Dr. Robert-Andreas Schöning <
it-consulting at ra-schoening.de> wrote:

> Hi Todd,
>
> have you tried SELECT * from "OMNIS"."F-ROLODEX" ?
>
> Regards,
>
> Robert.
>
> -----Ursprüngliche Nachricht-----
> Von: omnisdev-en-bounces at lists.omnis-dev.com
> [mailto:omnisdev-en-bounces at lists.omnis-dev.com] Im Auftrag von Todd
> Wolford
> Gesendet: Mittwoch, 15. Dezember 2010 17:17
> An: omnisdev-en at lists.omnis-dev.com
> Betreff: omnis odbc
>
> 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
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>



-- 
Todd Wolford
ztoddw at gmail.com