Table is read only error

[cpmasesa]

Hi
I am attempting to execute this sql but I get a table is read only error BDE error code 10763
select movie.*
from movie m, personmovieroles pmr, zpersons p
where m.movieid = pmr.pmmovieid
and pmr.pmpersonid = p.personid
and pmr.pmpersonid = 626

what I'm trying to do is get a list of movie titles in which a particular person has featured
I have 3 tables, Movies, persons, and person movie roles

could someone please tell me why I get the "Table is read only" error

TIA

cpmasesa

 

[DanENW]

Just guessing here, but I suspect that it might be the use of the table name in the select clause when an alias had been provided for the movie table in the from clause, and used in the where clause.