> Nup, just confirmed that everything is committed, released, or freed.

> I'll re-engineer my app in the short term to get around this issue, and if

I

> get time, I'll do some trawling through the old Interbase docs.

> Nige

Here's a proof of the issue.

(php 5.0.4, Firebird 1.5.3CS, FreeBSD 6.0)

========================

#!/usr/local/bin/php -e
<?php
ibase_connect("localhost:/raid/db/rsms.fdb","sysdba","masterkey");

$sql = "select * from rdb\$relations";
$rec = ibase_query($sql);
while($row =ibase_fetch_row($rec)){
for($a=0;$a<count($row);$a++){
echo $row[$a].", ";
}
echo "\n";
}

echo "\n\nSecond Connect\n\n";
// Now do the second connect
$conn2 =
ibase_connect("localhost:/raid/db/passport.fdb","sysdba","masterkey");
$trans2 = ibase_trans($conn2);

$sql = "select * from rdb\$relations";
$rec = ibase_query($trans2,$sql);
while($row =ibase_fetch_row($rec)){
for($a=0;$a<count($row);$a++){
echo $row[$a].", ";
}
echo "\n";
}

echo "\n\nClosing Second Connect\n\n";
// Now, close the second connection
ibase_commit($trans2);
ibase_close($conn2);



echo "\n\nThis list should be the same as the first\n\n";

$sql = "select * from rdb\$relations";
$rec = ibase_query($sql);
while($row =ibase_fetch_row($rec)){
for($a=0;$a<count($row);$a++){
echo $row[$a].", ";
}
echo "\n";
}
ibase_commit();
ibase_close();

?>


========================