TVirtualQuery

[Aggie85]

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

[Aggie85]

Any chance of getting this answered before I retire ?

All the best,

Aggie85

[MaximG]

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

[Aggie85]

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

[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. 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» )

[Aggie85]

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

[MaximG]

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

[Aggie85]

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

[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

[Aggie85]

Come-on Max!

At least throw me a bone (update)!

Thanks,

Aggie85

[MaximG]

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)

[Aggie85]

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

[MaximG]

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

[Aggie85]

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

[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