The Date field is not the problem - I've testet with simple UPDATE <Table Name> SET <Field Name>='2003-06-01' and all records was updatet.
It seems as if I use more than one tablename after UPDATE(seperatet by , ) it dosn't work, and if I don't I get an error in my criterias.
When I was porting Access to MySQL I got a lot of problems specially with UPDATE. I have been reading a lot of threads but I can't find the answer.
Why do I get an error when using:
UPDATE Hjemmeside , Medlem SET Hjemmeside.SidsteLogin='2003-06-01' WHERE Medlem.MedlemsID=Hjemmeside.MedlemsID...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.