TUniDump exports table instead of view.

[m227]

Hi, I use TUniDump to dump data from MS SQL Server with command like
UniDump.BackupToFile(DumpFileName, mquery);

mquery looks like: SELECT * FROM dbo.View_xyz
so it is a View.

If i run mquery and put results to dataset I get all 5 columns, but in my exported file I got only two columns... like

Code: Select all

TRUNCATE TABLE dbo.BusinessObject_N;
INSERT INTO dbo.BusinessObject_N(idN, nrN) VALUES (102158, '5500095');
...

[Stellar]

TUniDump is not designed for storing and recovering the view data. Because the server forbids changing view if the modification concerns several basic tables.