delete with a join will not work

jkuiper · Post by **jkuiper** » 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

Dimon · Post by **Dimon** » 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.

jkuiper · Post by **jkuiper** » 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.

jkuiper · Post by **jkuiper** » Fri 08 Aug 2008 09:42

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

Dimon · Post by **Dimon** » Fri 08 Aug 2008 14:26

I am happy that this problem has been solved.