Devart Forums

Hi,
"Update Failed. Found 0 records", raise when Post or Delete records, using TMyTable, CheckRowVersion := True, StrictUpdate True or False (is the same in both cases), and in the table thereis one datefield without value.
Any idea about?

Best regards,
Victor

Best is to add a primary key (Autoinc) to the table.

Sorry,
I forget to give more data:
"Update Failed. Found 0 records", raise when Post or Delete records, using TMyTable, CheckRowVersion := True, StrictUpdate True or False (is the same in both cases), with PK included and in the table there is one date field without value. If there is a valid value in the Date Field, at the first post (Append, Post and then Commit), there is no error.
Any idea about?

Best regards,
Victor

Please specify if you set SQLUpdate or SQLDelete properties

We don´t set SQLUpdate or SQLDelete properties, we use delete over TMyTable object.

could you provide the SQL DDL of this table ?
Why not sending Corelab a demo project with all of this ?

We couldn't reproduce the problem.
Please send us (mydac*crlab*com) a complete small sample to demonstrate it and include create table script.

Thank you for your sample. It did help us very much.

The reason of the problem is using '0000-00-00 00:00:00' as datetime value since Delphi cannot accept it. Use any acceptablle value or add TIMESTAMP field to field list. The later is more correct.

Thank you for your help. I'll try to solve our problem adding a valid datetime value in all new created records.

Best Regards