Hi, All!

Could anybody explain why datetime field value is not refreshed with server
default value, however AutoGenerateValue property is set up to arDefault.
Instead I recieve error messages.

Thanks

AutoGenerateValue only works for BDE datasets, not ADO datasets. To pick up
database defaults in ADOExpress, add the following to the AfterOpen event
for your ADO dataset.

 ADODataSet1.Recordset.Properties['Update Resync'].Value :=
    adResyncAutoIncrement + adResyncUpdates + adResyncInserts;

Delphi normally only uses adResyncAutoIncrement - I've added adResyncUpdates
+ adResyncInserts.

Cheers,
Andy Mackie.

Could you tell where I could read more about RecordSet.Properties?
Thank you.

For Update Resync see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado2...
mdcstceresyncenum.asp

For ADO documentation in general, see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado2...
dasdkadooverview.asp
and for Properties see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado2...
mdobjproperty.asp

Andy Mackie.