Another Issue in TVirtualQuery..

Discussion of open issues, suggestions and bugs regarding Virtual Data Access Components for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Aggie85
Posts: 95
Joined: Wed 11 Nov 2015 17:03

Another Issue in TVirtualQuery..

Post by Aggie85 » Tue 06 Jun 2017 23:03

Howdy (again)!

The following SIMPLE SELECT query returns an error of:

Error: constraint failed

SELECT RecordID AS CustomerID,Address FROM Customers WHERE RecordID IN (12,15,55,62,69,70,91,100,103,128,129,274,336,413,418,441,442,447,542,878,2048,2071,3269,3466,3991,4432,4641,4679,4703,4821,4926,5001,5002,5003,5004,5005,5071,5072,5075,5081,5083,5085,5090,5112,5165,5247,5248,5400,5411,5521,5561,5563,6028,6099,6134,6308,6459,6476,6482,6604,6636,6721,6991,7079,7084,7133,7144,7189,7192,7204,7245,7252,7265,7269,7278,7281,7283,7284,7317,7337,7339,7391,7419,7421,7434,7439,7489,7523,7653,7675,7820,7822,7850,7947,7992,8006,8010,8033,8074,8099,8119,8136,8177,8246,8339,8343,8344,8345,8356,8357,8363,8365,8379,8406,8407,8542,8598,8599,8601,8623,8651,8759,8760,9015,9050,9312)

The above has NO issues with TxQuery, TkbmMemSQL, or TSQLTable.

Is anyone else using TVirtualQuery?

Thanks,

Aggie85

Aggie85
Posts: 95
Joined: Wed 11 Nov 2015 17:03

Re: Another Issue in TVirtualQuery..

Post by Aggie85 » Thu 08 Jun 2017 04:06

I copied my simple TkbmMemTable to a TVirtualTable and this reported problem went away.

Y'all should work with Kim Madsen on making sure TkbmMemTable is fully compatible with TVirtualQuery. I think you may get a lot of sales.

All the best,

Aggie85

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

Re: Another Issue in TVirtualQuery..

Post by MaximG » Thu 08 Jun 2017 07:16

We are glad that you could find the right solution. In turn we tried to reproduce the described problem, however in our test environment we did not manage to get an error: «Error: constraint failed ». Please specify what component in this case is a data source for VirtualQuery.

Aggie85
Posts: 95
Joined: Wed 11 Nov 2015 17:03

Re: Another Issue in TVirtualQuery..

Post by Aggie85 » Thu 08 Jun 2017 15:00

I have been using TkbmMemTable for almost 15+ years!

The errors I am reporting are using below:

http://news.components4developers.com/p ... Table.html

Thanks,

Aggie85

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

Re: Another Issue in TVirtualQuery..

Post by MaximG » Fri 09 Jun 2017 11:37

Please specify, you get the "Source dataset is not active." error message when performing the described actions.

Aggie85
Posts: 95
Joined: Wed 11 Nov 2015 17:03

Re: Another Issue in TVirtualQuery..

Post by Aggie85 » Fri 09 Jun 2017 23:21

Latest nightly build fixes this problem.

Best Regards,

Aggie85

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

Re: Another Issue in TVirtualQuery..

Post by MaximG » Mon 12 Jun 2017 10:16

We were glad to help you. Please don't hesitate to contact us with questions concerning VirtualDAC usage.

Post Reply