TMS DB aware and kbmMemTable

Wesseling_Ralph · March 3, 2014, 9:29pm

Hi,

I am using the kbmMemTable as my dataset but they just don't work nice with TMS dbgrid, dblistbox etc.

The moment a filter is placed on the memtable
all data is wiped, and remains that way even if the filter is removed.
Suffice to say this is a major fly in my ointment.

I would be very keen to see these components working correctly together.

I am using Delphi XE5, TMS Component Pack 7.1.3.0 and kbmMemTable v. 7.40.00

I am presuming you will say it not your problem as it is another 3rd party product but I am hoping for a better reponse than that ;)

R

brunofierens · March 4, 2014, 11:33am

Did you try to change the setting for grid.DataSetType ?

Wesseling_Ralph · March 5, 2014, 12:00am

I have tried both sequenced and non-sequenced

I have tried other memtables, FDMemTable (FireDac) and that too fails.

However SQLMemTable does work

All components work fine with normal DBgrid

I will keep digging. I am hoping the author kbmmemtable can help

Wesseling_Ralph · March 5, 2014, 1:05am

Hi

I have made a simple app to demonstrate the problem. The grid is set to DBAdvGrid. If you replace with a DBgrid the two filter and unfilter buttons work. However, as it is the filter doesn't work and unfilter does not reset the dataset.

https://www.dropbox.com/s/1y69sc0bdkeqf8g/FilterTest.zip

To replace dbadvgrid with a dbgrid I simply use alt-f12 and rename the component + replace in unit. (I doubt I need to tell you that).

I am hoping you can tell me why it doesn't work and even better be able to fix it.

regards

Ralph

Wesseling_Ralph · March 6, 2014, 12:06pm

Hi

Have you had a chance to have a look?

Wesseling_Ralph · April 27, 2014, 6:53pm

Hi

Have you had a chance to address this issue? I ran into it again today.

brunofierens · April 28, 2014, 11:45am

Do you have a sample with FDMemTable with which we can reproduce this? We do not have kbmemtable installed here on developer machines.

Wesseling_Ralph · April 28, 2014, 2:17pm

HI did you try the filtertest that I put into dropbox?

https://www.dropbox.com/s/1y69sc0bdkeqf8g/FilterTest.zip

Wesseling_Ralph · April 28, 2014, 2:18pm

From earlier post

"
I have made a simple app to demonstrate the problem. The grid is set to
DBAdvGrid. If you replace with a DBgrid the two filter and unfilter
buttons work. However, as it is the filter doesn't work and unfilter
does not reset the dataset.

https://www.dropbox.com/s/1y69sc0bdkeqf8g/FilterTest.zip

To
replace dbadvgrid with a dbgrid I simply use alt-f12 and rename the
component + replace in unit. (I doubt I need to tell you that).

"