Can use Virtualtable for datasource

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
tcflam
Posts: 58
Joined: Tue 01 Jan 2013 10:48

Can use Virtualtable for datasource

Post by tcflam » Tue 08 Jan 2013 07:06

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

Post by AndreyZ » Wed 09 Jan 2013 12:02

Hello,

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

tcflam
Posts: 58
Joined: Tue 01 Jan 2013 10:48

Re: Can use Virtualtable for datasource

Post by tcflam » Thu 10 Jan 2013 00:44

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?

AndreyZ

Re: Can use Virtualtable for datasource

Post by AndreyZ » Fri 11 Jan 2013 16:35

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.

Post Reply