TVirtualQuery with FB3 and UniTable
Posted: Sun 13 Nov 2016 08:48
This blows up, the Transaction is set to inactive right after a VQ has opened.
Any Dataset using the same connection fails with inactive transaction or something like that. All works flawless with MSSQL.
Any Dataset using the same connection fails with inactive transaction or something like that. All works flawless with MSSQL.
Code: Select all
vq := TVirtualQuery.Create(nil);
link := vq.SourceDataSets.Add;
link.DataSet := UniTable;
link.TableName := ATablename;
vq.SQL.Text := ASQL;
vq.Open;
Assert(UniTable.Transaction.Active, 'Huh?');