Compile or run this and you get a syntax error. It appears the field name left is not allowed. However, I was able to select it with SQL. This statement has 42 fields in my program and it took a while to narrow it down to this one field. Remove it and it runs, leave it in and CRASH! Anyone got any comments?
update pageobj ;
set left = c_pageobj.left ;
from c_pageobj ;
where c_pageobj.k_pageobj = pageobj.k_pageobj ;
and c_pageobj.k_page = pageobj.k_page
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn