Why "Operation must use an updatable query"?

[asiamisia]

I want to update sth abouth 10000 records (change number of the module to its name - name comes from anotheta table) I have used this query

UPDATE problemy SET problemy.modul = (SELECT s_modul.modul FROM s_modul WHERE problemy.modul = s_modul.ID)

in RunSQL macro but I am getting "Operation must use an updatable query" error how to make a proper query that would update field modul in table problemy getting its name from s_modul table

Joanna

 

[ecniv]

UPDATE problemy left join s_modul on problemy.modul=s_modul.modul
SET problemy.modul = nz(s_modul.modul,-1)

You could try something like this.. but no guarentees. I think its because it thinks you are referring to the table which you are updating which may change the link and thus go into infinity or something so it disallows it.


Vince