RE: [firebird-support] Firebird 1.5 with Yii - table not found

2016-08-09 Thread jonatan.laurit...@yahoo.dk [firebird-support]
Both databases have dialect 1 and that means that case in table names and quotation is irrelevant. I managed to call generator from 1.5 database but tables are not accessible still from the Active record infrastrcture: $list = Yii::$app->db->createCommand('select gen_id(contract_ino, 1) from

[firebird-support] Firebird 1.5 with Yii - table not found

2016-08-09 Thread jonatan.laurit...@yahoo.dk [firebird-support]
I am trying to use Firebird 1.5 database with Yii with Yii-Firebird extension yii2-firebird | Extension | Yii PHP Framework http://www.yiiframework.com/extension/yii2-firebird/ http://www.yiiframework.com/extension/yii2-firebird/ yii2-firebird | Extension | Yii PHP Framework

RE: [firebird-support] SQL performance SS FB 3.0.1 vs SC FB 2.5.2

2016-08-09 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
> Just found that on a particular case, SS FB 3.0.1 is about 4x slower than SC > FB > 2.5.2. > > Here is the query : > == > select a.id,b.nm from tbl1 a, tbl2 b > where a.id = b.id > and a.id in (select c.id from tbl3 c) > > If the query change to this : >