>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

You're right, left causes a syntax error. You can not use it.

CREATE CURSOR PageObj (k_PageObj i, K_page I, cLeft C(10))
CREATE CURSOR c_PageObj (k_PageObj i, K_page I, Left C(10))

update pageobj set cleft = c_pageobj.left ;
from pageobj inner join c_pageobj on c_pageobj.k_pageobj = pageobj.k_pageobj ;
and c_pageobj.k_page = pageobj.k_page