Re: [Phplib-users] Test whether db table exists using DB_SQL

[Peter B. <re...@f2...>]

At 05:48 PM 8/16/01 +1000, you wrote:
> >I thought that this SQL was specific to MySQL :-(
>
>You're right... at least it won't work on MSSql/ODBC:
>
>Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]
>Could not find stored procedure 'show'., SQL state 37000 in
>SQLExecDirect in D:\www\test\html\test.php on line 24
>
>Bummer!
>
>I guess you just have to perform the query and see if you encounter
>an error.

I tried that, but I couldn't suppress an error message :-(
Actually I found that changing var $Halt_On_Error in db_mysql.inc to "no" 
cured the problem - however, this variable isn't implemented in the other 
database drivers, and I only have access to MySQL so cannot test it on the 
other databases at the present time :-(

Can you confirm how the other drivers react if there is no table present?

Thanks,
Peter.

--
In the beginning was the word,
and the word was Content-type: text/plain.