VirtualDataSet + VirtualQuery problem

Discussion of open issues, suggestions and bugs regarding Virtual Data Access Components for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Max Terentiev
Posts: 20
Joined: Sun 05 Jun 2016 17:11

VirtualDataSet + VirtualQuery problem

Post by Max Terentiev » Thu 12 Oct 2017 15:43

Hi,

I use VirualDataSet and VirtualQuery this way:

Code: Select all

ProxyDS=new TVirtualDataSet(NULL);
ProxyDS->FieldDefs->Clear();
ProxyDS->FieldDefs->Add("No",ftInteger,0,false);
ProxyDS->FieldDefs->Add("IP",ftString,64,false);
ProxyDS->OnGetRecordCount=ProxyDSGetRecordCount;
ProxyDS->OnGetFieldValue=ProxyDSGetFieldValue;
ProxyDS->Open();

ProxyQry=new TVirtualQuery(NULL);
ProxyQry->FetchAll=true; // Bug if true !
ProxyQry->Options->QueryRecCount=true;
ProxyQry->SourceDataSets->Add(ProxyDS,"RunTimeProxyList");
ProxyQry->SQL->Add("SELECT * FROM RunTimeProxyList");
ProxyQry->Open();
If ProxyDS have only one record (Count=1 in OnGetRecordCount) AND ProxyQry->FetchAll=true - ProxyQry returns empty result ! If FetchAll=false - returns correct result.

VirtualDAC version 10.2.6, RAD Studio 2007.

Please fix this bug !

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: VirtualDataSet + VirtualQuery problem

Post by MaximG » Fri 13 Oct 2017 13:51

Unfortunately, we could not reproduce this issue according to the provided snippet. For further investigation, please compose and send us a small sample demonstrating the issue via the e-support form ( https://www.devart.com the "Support"\"Request Support" menu)

Post Reply