I have this raised as a log too but thought I would post here to see if anyone else has had these problems?

This is the problem I get on using the Calendar1.SaveToDataSource method.

If I have the field PointedSelectedStyle set to not allow nulls I get an error saying unable to save null into the field.

I then set it to allow nulls and I get the error Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

To get around this I set Me.GRSDataSet.EnforceConstraints = False before the call to Calendar1.SaveToDataSource.

The record then saves.

I only have the Item table in the database so do not know what the constraint is?

This is the problem I get when using the Calendar1.LoadFromDatasource method.

The database gets copied to the bin folder when running and the data saves there as detailed above, however the LoadFromDatasource clears the Calendar of all entries but does not load the data from the previous save?

Any ideas?

Thnx