Thread: Emergent: get table names from SageLine50 by ODBC

Emergent: get table names from SageLine50 by ODBC

From
john@intelligentapps.com (Local Cuber)
Date:
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.

Re: Emergent: get table names from SageLine50 by ODBC

From
Peter Eisentraut
Date:
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.


Re: Emergent: get table names from SageLine50 by ODBC

From
john@intelligentapps.com (Local Cuber)
Date:
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

Re: Emergent: get table names from SageLine50 by ODBC

From
Peter Eisentraut
Date:
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?


Re: Emergent: get table names from SageLine50 by ODBC

From
"Philippe Lang"
Date:
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



Re: Emergent: get table names from SageLine50 by ODBC

From
Mischa Sandberg
Date:
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.