AW: omnis odbc

[Dr. Robert-Andreas Schöning]

Hi Todd,

as F-ROLODEX is the table you try to query - do you need the OMNIS prefix in
your select statement?

Just give it a try with SELECT * from 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 21:01
An: OmnisDev List - English
Betreff: Re: omnis odbc

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
_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com