Devart Forums

Posted: **Tue 05 Aug 2008 14:52**

I try to delete a record in Delphi D2007.
My query look like this:

SELECT functieaanvraag.*, users.usernaam FROM functieaanvraag
JOIN users ON functieaanvraag.usernr = users.usernr
ORDER by nextnum DESC, datum DESC, tijd DESC

But delphi comes with the errormessage:

Code: Select all

Project [name of project] raises exception class EDatabaseError with message 'Update failed. Found 0 records'.

Without a join table it works fine.
I set my joinfield to false and also the providerflags to false.

Nothing happens and still get an error. Do I forget someting?

My MyDAC version is 5.50.0.34 for Delphi 2007

Posted: **Wed 06 Aug 2008 14:34**

We have fixed this problem in the latest MyDAC build (5.50.0.36). Please, upgrade to this build to solve the problem.

Posted: **Thu 07 Aug 2008 13:26**

It still not work.

Iclosed Delphi 2007 and deleted the old version. Than I installed MyDAC 5.50.x.36. Deleted all .dcu from my project. Recompiled an built it again.
But the result will we the same.

Posted: **Fri 08 Aug 2008 09:42**

Problem solved.
I think it was corruption in the hash_index, but I'm not really sure.

Posted: **Fri 08 Aug 2008 14:26**

I am happy that this problem has been solved.

Devart Forums

delete with a join will not work

delete with a join will not work