Devart Forums

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

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

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

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

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

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

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.

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

Howdy Maxim!

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

Thanks,

Aggie85

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

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

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.

Howdy Maxim!

So latest version so far has proven to be stable!

I appreciate y'alls support!

All the best,

Aggie85

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.