"Update Failed. Found 0 records"

vvitolo · Post by **vvitolo** » Tue 30 Aug 2005 23:19

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

GEswin · Post by **GEswin** » Wed 31 Aug 2005 08:17

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

vvitolo · Post by **vvitolo** » Wed 31 Aug 2005 22:19

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

Ikar · Post by **Ikar** » Thu 01 Sep 2005 06:10

Please specify if you set SQLUpdate or SQLDelete properties

vvitolo · Post by **vvitolo** » Thu 01 Sep 2005 06:20

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

swierzbicki · Post by **swierzbicki** » Thu 01 Sep 2005 06:24

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

Ikar · Post by **Ikar** » Thu 01 Sep 2005 11:48

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

Ikar · Post by **Ikar** » Fri 02 Sep 2005 11:42

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.

vvitolo · Post by **vvitolo** » Fri 02 Sep 2005 17:41

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

Best Regards