We are trying to save the records using Dataset in the external Data base. There is a trigger written on the table which generate unique value for primary key, so no need of setting primary key value.

     Whenever passing values to all columns including primary key its saving records perfectly, however without primary key values it’s not saving records and throwing error on commit.

     Our requirement is to save the records in external table without setting primary key value using Dataset.

     We are able to achieve our requirement using RDB-Save method but its not achievable using Dataset Save.

     Please let us know how to achieve this requirement if anyone faced same issue.