TSequenceField doesn't work with AppServer?

[wyverex]

Hi,

When using TSequenceField on a local DB all works fine when appending new records.
But when the OracleDataSet resides in a RemoteDataModule on an app server and is connected to a TClientDataSet via a TDataSetProvider, the sequence number is not generated and the corresponding field in the client data set is filled with a null value.

How can I fix this? Or do I have to implement my own sequence number generator?

thx in advance

 

[Marco Kalter]

The SequenceField will only work if TDataSetProvider.ResolveToDataSet is set to True. Otherwise the insert statement is generated by the TDataSetProvider, bypassing the sequence property of the dataset.