Devart Forums

Howdy All!

I am trying to replace TxQuery with TVirtualQuery.

I primarily use TkbmMemTable in my application framework.

I have tried the following:

1) Added a TkbmMemTable to my form called TestDataTable.
2) Added a TVirtualQuery to my form called VQuery.
3) Added TestDataTable to VQuery's SourceDataSets collection and I called the TableName TestData.

At run-time, I populate the TestData with 10000 records with a primary integer key field.
I add the following statement to the SQL property of VQuery:

DELETE FROM TestData WHERE RecordID >= 5000;

It should delete 5000 records but it only deletes 1.

Am I using TVirtualQuery wrong or is it incompatible with TkbmMemTable (memory table)?

Thanks,

Shane

Any chance of getting this answered before I retire ?

All the best,

Aggie85

Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

Thanks!

I really hope y'all get this working so I can replace TxQuery. Unfortunately, replacing TkbmMemTable isn't going to happen anytime soon!

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. Currently, we can send you a night build of VirtualDAC with the fix. For this, please specify your license number and the exact version of Delphi you are using. Please send this data using the e-support form ( https://www.devart.com - menu «Support»\«Request Support» )

Howdy Max!

A follow up with TVirtualQuery and TkbmMemTable.

If I have a table with 10,000 records with a RecordID value of 0 to 9999 and I issue the following:

1) DELETE FROM TEST WHERE RecordID < 10

10 records are deleted.

2) DELETE FROM Test WHERE RecordID IN (0,1,2,3,4,5,6,7,8,9)

only deletes 1 record.

Again, this is with TkbmMemTable with I cannot stop using. A TVirtualTable it works fine.

Let me know if you need any help with this.

All the best,

Aggie85

Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

Howdy Max!

Thanks for the update.

As soon as I get a version with fixes, I will continue my program upgrade. The next round of conversions on my part will be the REAL test as the problems I found so far have just been SELECT statements used in my reporting backend!

All the best,

Aggie85

Howdy Maxim!

I know it has only been a few days.

Do y'all have an approximate ETA for the next release?

I need to determine if I wait or move on to my next major thing and come back to my current task.

Thanks again!

Aggie85

Come-on Max!

At least throw me a bone (update)!

Thanks,

Aggie85

We carefully investigated the problem according to your description. We fixed VirtualDAC behavior. The fix will be included in the next VirtualDAC build. Currently, we can send you a night build that includes this fix. For this, provide your license number and the version of Delphi you are interested in using the e-support form (https://www.devart.com the "Support" \ "Request Support" menu)

Howdy Maxim!

I sent the email with my license info again for latest update.

Does this fix also fix the slow data retrieval on joined statements?

Thanks for the great support.

Aggie85

You are absolutely right, this fix includes our changes aimed at increasing VirtualQuery performance when using the JOIN statement in a query

Howdy Maxim!

Thanks for the great NEWS and SUPPORT!

As soon as I get the latest nightly build, I am going to repeat my regression testing and then continue replacing TxQuery in non-readonly areas of my application.

As soon as I get it all working, I will see if I can help you sell a few copies of TVirtualDAC as many of us have been looking for such a component for a LONG time.

Have a great weekend,

Aggie85

Hey Maxim!

I have emailed y'all since Thursday looking for the "nightly" build!

Any chance of getting it sooner than later?

Thanks,

Aggie85