Another Issue in TVirtualQuery..
Posted: 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
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