CRBatchMove and Identity Columns

[tinof]

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

[AndreyZ]

Hello,

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

[tinof]

That's the solution, thank you very much.

Now it works!

Tino

[AndreyZ]

If any other questions come up, please contact us.