string sql; int a,b; for(a=0;a<=30;a++) {db_free_area(a);} sql="select a.res_id,b.res_name,a.inp_num from ebs_vr_item a "; sql=sql+" left join res b on b.res_id=a.res_id "; sql=sql+" where a.is_main='N'"; db_select_area(0); db_run(sql); if(db_show_and_select_m_ds("select")) { db_select_area(1); db_select_m_copy_res(); db_show("change the inp_num"); db_select_area(2); db_show_grid_to_db() db_show("last result"); }