Bug with Latest Version TkbmMemTable

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

Bug with Latest Version TkbmMemTable

Post by Aggie85 » Wed 07 Feb 2018 20:50

Howdy Max!


If you create TkbmMemTable with the following 3 fields:

Amount (Currency),Enabled (Boolean), TypeID (Integer)

Add the following SINGLE record:

Amount = 100.0,Enabled = False,TypeID = 2

And issue the following SQL statement:

SELECT SUM(Amount) AS Amount
FROM TkbmMemTable1
WHERE Enabled = 0 OR TypeID = 2

It will return Amount as 200.0 instead of 100.

If I use a TVirtualTable, it works.

PLEASE FIX QUICKLY .... this type of error could be in several places of my program!

All the best,

Aggie85

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

Re: Bug with Latest Version TkbmMemTable

Post by MaximG » Thu 08 Feb 2018 12:04

Thank you for the information. We have reproduced the problem and fixed the bug. The fix will be included in the next VirtualDAC build.

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

Re: Bug with Latest Version TkbmMemTable

Post by Aggie85 » Fri 09 Feb 2018 22:29

Howdy Maxim!

I responded by e-mail with the latest version TVirtualQuery. It breaks even more as it looks like y'all have a positioning error on the result dataset.

I have sent you an example to illustrate the problem.

Please let me know if you need me to test any fixes.

All the best,

Aggie85

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

Re: Bug with Latest Version TkbmMemTable

Post by MaximG » Tue 13 Feb 2018 10:10

We sent you an e-mail link to download the night build that includes all the necessary fixes

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

Re: Bug with Latest Version TkbmMemTable

Post by Aggie85 » Tue 13 Feb 2018 13:27

Howdy Maxim!

I just installed / started testing and this version breaks other items.

I am going to be in meetings most of the day and I will try and do more research and get you yet another test example demonstrating latest issue.

Can I ask why TkbmMemTable compatibility is so inherently filled with issues?

All the best,

Aggie85

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

Re: Bug with Latest Version TkbmMemTable

Post by Aggie85 » Tue 13 Feb 2018 15:44

Howdy Maxim!

I just emailed you a new updated test project that illustrates the new bug introduced in last night's version.

Please let me know if I can be of any other help.

All the best,

Aggie85

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

Re: Bug with Latest Version TkbmMemTable

Post by MaximG » Wed 14 Feb 2018 09:15

Thank you for the provided information. We investigated the sent sample, reproduced the issue and fixed the mentioned error. The fix will be included in the next VirtualDAC build. As a workaround, we sent you a link to download a night build with all the changes.

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

Re: Bug with Latest Version TkbmMemTable

Post by Aggie85 » Fri 16 Feb 2018 17:13

Howdy Maxim!

I have verified that the latest nightly build fixes all found issues with TkbmMemTable!

I really appreciate y'alls great components / support.

All the best,

Aggie85

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

Re: Bug with Latest Version TkbmMemTable

Post by Aggie85 » Sat 17 Feb 2018 21:22

Howdy Maxim!

I spoke to soon. I just e-mailed you another case that fails with TkbmMemTable.

Thanks,

Aggie85

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

Re: Bug with Latest Version TkbmMemTable

Post by MaximG » Tue 20 Feb 2018 08:07

Thank you for the information, we received your project VirtualQueryBug#20000, investigated it, reproduced it, and then fixed the detected error. The night build with the necessary changes was sent to you by email

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

Re: Bug with Latest Version TkbmMemTable

Post by Aggie85 » Wed 21 Feb 2018 01:12

Howdy Maxim!

I just sent you another case where the WHERE doesn't work... please let me know when you want me to test something else.

All the best,

Aggie85

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

Re: Bug with Latest Version TkbmMemTable

Post by MaximG » Fri 23 Feb 2018 09:10

Thank you very much for the provided information. We fixed the found error and sent you a link to download a night build, which includes all the necessary changes.

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

Re: Bug with Latest Version TkbmMemTable

Post by Aggie85 » Tue 27 Feb 2018 20:18

Howdy Maxim!

So latest version so far has proven to be stable!

I appreciate y'alls support!

All the best,

Aggie85

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

Re: Bug with Latest Version TkbmMemTable

Post by MaximG » Sat 03 Mar 2018 13:35

We are glad that we could get a stable VirtualDAC build, eliminating the issues described by you.
We always work to improve our products and are ready to solve any issues related to their use.

Post Reply