Devart Forums

Hello,
please, can you tell me, if it is possible to copy whole table from MySQLServer unless delete the structure of the table?
I make a SELECT statment, then I add a column, that´s OK. But how can I update the fields e.g. every minute? If I make SELECT statment, the added column delets from the virtual table, but I want it to be there.

Can you tell me how to do it, or any other solution of this problem?

Thank You,
Jan Mrazek

To prevent structure deletion of VirtualTable you should manually clear data from VirtualTable and copy records from MSTable field by field, record by record in a double cycle.