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_pageYou'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