Create view and Select in Interbase

From: Date: Thu, 01 Mar 2001 15:37:00 +0000
Subject: Create view and Select in Interbase
Groups: php.db 
Request: Send a blank email to php-db+get-7052@lists.php.net to get a copy of this message
To all good people, I've got troubles with the following code: <?php $dbh = DbGet(); /*fce na ibase_connect*/ $stmt1="create view vserv0 as select distinct product_id from product where podminka;"; $sth = ibase_query ($dbh, $stmt1); $stmt2="select * from vserv0;"; $sth = ibase_query ($dbh, $stmt2); ?> It should create a view vserv0 and make a selection (select * from ...}. For some reason it process always just the first query (create). The second one gives me a message "table vserv0 doesn't exist". When I create view vserv0 manualy (IB console) it works without any problems. please help. Thanks Stephano _____________________________________________________________________________ http://invites.yahoo.com.au - Yahoo! Invites - Organise your Mardi Gras party online!

« previous php.db (#7052) next »