Devart Forums

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

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

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.

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

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

Latest nightly build fixes this problem.

Best Regards,

Aggie85

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