Devart Forums

I import some excel file into virtualtable. Can I use the TMSQuery to browsing, updating in virtualtable result?

Hello,

Please describe in more details the functionality you want to obtain with the TMSQuery and TVirtualTable components.

Hi, I will describe it more detail in my requirement.

I need to import the data from excel file. Then I need to doing the checking and data updating after import the data into virtualtable. But those data may be a "Batch Number". I don't want to use "while" function that go though the whole table record by record. I want to doing the bulk update. Then performance will be better.

If bulk update, can I use TMSQuery to update virtualtable records?

You cannot use any kind of statements (SQL or other) to perform batch update of data in TVirtualTable. If you have data in TVirtualTable, the only way to batch update it is to go through the table record by record. To perform batch updates, data must be in a table on the server. In this case, TMSQuery can be used to batch update it.