Another Issue in TVirtualQuery..

Another Issue in TVirtualQuery..

Postby 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: 66
Joined: Wed 11 Nov 2015 17:03

Re: Another Issue in TVirtualQuery..

Postby 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
Aggie85
 
Posts: 66
Joined: Wed 11 Nov 2015 17:03

Re: Another Issue in TVirtualQuery..

Postby 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.
MaximG
Devart Team
 
Posts: 668
Joined: Mon 06 Jul 2015 11:34

Re: Another Issue in TVirtualQuery..

Postby 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/products_kbmMemTable.html

Thanks,

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

Re: Another Issue in TVirtualQuery..

Postby MaximG » Fri 09 Jun 2017 11:37

Please specify, you get the "Source dataset is not active." error message when performing the described actions.
MaximG
Devart Team
 
Posts: 668
Joined: Mon 06 Jul 2015 11:34

Re: Another Issue in TVirtualQuery..

Postby Aggie85 » Fri 09 Jun 2017 23:21

Latest nightly build fixes this problem.

Best Regards,

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

Re: Another Issue in TVirtualQuery..

Postby 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.
MaximG
Devart Team
 
Posts: 668
Joined: Mon 06 Jul 2015 11:34


Return to VirtualDAC