Can use Virtualtable for datasource
Can use Virtualtable for datasource
I import some excel file into virtualtable. Can I use the TMSQuery to browsing, updating in virtualtable result?
-
AndreyZ
Re: Can use Virtualtable for datasource
Hello,
Please describe in more details the functionality you want to obtain with the TMSQuery and TVirtualTable components.
Please describe in more details the functionality you want to obtain with the TMSQuery and TVirtualTable components.
Re: Can use Virtualtable for datasource
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?
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?
-
AndreyZ
Re: Can use Virtualtable for datasource
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.