Bug with Latest Version TkbmMemTable

[Aggie85]

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]

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]

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]

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

[Aggie85]

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]

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]

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]

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]

Howdy Maxim!

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

Thanks,

Aggie85

[MaximG]

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]

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]

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]

Howdy Maxim!

So latest version so far has proven to be stable!

I appreciate y'alls support!

All the best,

Aggie85

[MaximG]

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.