Two ways to modify field value:
with MySQLTable1 do begin // This is the safe way to change 'CustNo' field FindField('CustNo').AsString := '1234'; // This is *not* the safe way to change 'CustNo' field Fields[0].AsString := '1234'; end;