Thread: Emergent: get table names from SageLine50 by ODBC

HI,

Anybody knows how to get table names from SageLine50 by ODBC.

select * from system_schema.tables is not working for this.

anybody has ever come across this?

thank you
john.

Local Cuber wrote:
> Anybody knows how to get table names from SageLine50 by ODBC.
>
> select * from system_schema.tables is not working for this.

The correct table name is information_schema.tables.

The information_schema.tables is not working.

but the strangest thing is that I can use excel or sql server to find
their names. are there some special agreement between sage and ms.

thank you

Local Cuber wrote:
> The information_schema.tables is not working.

If you want to get further help on this you should provide us with some
more precise information.  How is it not working?  Is there an error
message?  Is it not showing the information you expected?

Have you tried maybe to create a stored procedure that performs your query, and to call that stored procedure from your
software? 

-----Message d'origine-----
De : pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] De la part de Local Cuber
Envoyé : vendredi, 9. juillet 2004 15:34
À : pgsql-odbc@postgresql.org
Objet : Re: [ODBC] Emergent: get table names from SageLine50 by ODBC

The information_schema.tables is not working.

but the strangest thing is that I can use excel or sql server to find their names. are there some special agreement
betweensage and ms. 

thank you

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Any ODBC driver should support the SQLTables() call,
at very least to the extent of listing all the table names!

Local Cuber wrote:

> HI,
>
> Anybody knows how to get table names from SageLine50 by ODBC.
>
> select * from system_schema.tables is not working for this.
>
> anybody has ever come across this?
>
> thank you
> john.