TUniDump exports table instead of view.
Posted: Wed 07 Feb 2018 13:52
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
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');
...