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?');