TVirtualQuery with FB3 and UniTable

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
FredS
Posts: 272
Joined: Mon 10 Nov 2014 17:52

TVirtualQuery with FB3 and UniTable

Post by FredS » 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.

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

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: TVirtualQuery with FB3 and UniTable

Post by ViktorV » Mon 14 Nov 2016 13:46

Thank you for the information. We have reproduced the issue and investigation is in progress. We will inform you when we have any results.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: TVirtualQuery with FB3 and UniTable

Post by ViktorV » Fri 18 Nov 2016 10:23

We have already fixed the issue. This fix will be included into the next VirtualDAC build, which we are going to release soon.

Post Reply