I have join two tables using inner join as

select A.*,B.fld1 from table1 as A inner join Table 2 as B on A.fld=B.fld

the problem is i need to update a fldname on table1, but my app crashes after it updated the fldname

any suggestions.

rgds
cyrus