Re: [Virtuoso-users] Check if a table exists / retrieve list of tables

2007-10-07 Thread Sören Auer
On 10/7/07, Virtuoso Maintainer wrote: > I am currently in contact with the pdo_odbc module owner. I will discuss > with him the current implementation of pdo_odbc and see if we can put > some more calls into this implementation. I will also see if we can > introduce a setting for the php odbc mod

Re: [Virtuoso-users] Check if a table exists / retrieve list of tables

2007-10-07 Thread Virtuoso Maintainer
Hi Sören, I spend some time today trying to figure out how I can check if there exists a table with a certain name. For the PHP ODBC module there exists the function odbc_tables(), which works. However, due to the problem of the PHP ODBC module with TOP queries I'm now using the pdo_odbc module,

Re: [Virtuoso-users] Check if a table exists / retrieve list of tables

2007-10-06 Thread Sören Auer
On 10/6/07, Yrjänä Rankka wrote: > Here's one way I've used before. To query for a specific table DB.DBA.FUBAR: > select 1 from sys_keys where key_table = 'DB.DBA.FUBAR'; Thanks that helped! Sören

Re: [Virtuoso-users] Check if a table exists / retrieve list of tables

2007-10-06 Thread Yrjänä Rankka
Sören, Here's one way I've used before. To query for a specific table DB.DBA.FUBAR: select 1 from sys_keys where key_table = 'DB.DBA.FUBAR'; Have fun! Yrjänä Rajeev J Sebastian wrote: > There is a "tables;" isql command for it ... perhaps thats what you want ? > > Regards > Rajeev J Sebastian

Re: [Virtuoso-users] Check if a table exists / retrieve list of tables

2007-10-05 Thread Rajeev J Sebastian
There is a "tables;" isql command for it ... perhaps thats what you want ? Regards Rajeev J Sebastian On 10/6/07, Sören Auer wrote: > Hi all, > > I spend some time today trying to figure out how I can check if there > exists a table with a certain name. For the PHP ODBC module there > exists the

[Virtuoso-users] Check if a table exists / retrieve list of tables

2007-10-05 Thread Sören Auer
Hi all, I spend some time today trying to figure out how I can check if there exists a table with a certain name. For the PHP ODBC module there exists the function odbc_tables(), which works. However, due to the problem of the PHP ODBC module with TOP queries I'm now using the pdo_odbc module, whi