Devart Forums

Hello,

i want to update an program written with SDAC 3.xxx to actual SDAC version.
In this program i use CRBatchMove for copying table data.
Some of the tables have an identity - column.
So i execute an "set identity_insert [tablename] on" bevore executing crbatchmove.
In the old version it works.
In the new version (6.2. it fails because the crbatchmove automaticly does not include the identity column in the insert - code.

How can i tell crbatchmove, that i want ALL columns, even the identity column too?

Within the mappings - property i do assign the identity column to a source column.
But if i look the final code with SQL profiler i see, the identity column is missed.
So the server can't insert the data.

SQL Server 2008 R2 / Delphi XE2

Thanks for Help
Tino

Hello,

To solve the problem, you should set the SetFieldsReadOnly option of the destination dataset to False.

That's the solution, thank you very much.

Now it works!

Tino

If any other questions come up, please contact us.