2
Good evening... I am using a procedure in msm style for all modules of my software using msm UPDATE structure and all worked, however when I went to do the update of system users this returning me the error : incorrect UPDATE command syntax... will I leave the code down someone please know what is happening? thank you
procedure TModulo.EditarUsuario(idPr: Integer; userPr: string; senhaPr: string);
begin
with reserva do begin
Close;
SQL.Clear;
SQL.Add('UPDATE usuarios SET user = :userPr, senha = :senhaPr ' +
'where id = ' + IntToStr(idPr));
Parameters.ParamByName('userPr').Value := userPr;
Parameters.ParamByName('senhaPr').Value := senhaPr;
ExecSQL;
end;
//resetando para visualização
DMDados.Modulo.reserva.close;
DMDados.Modulo.reserva.sql.Clear;
DMDados.Modulo.reserva.sql.Add('select * from usuarios');
DMDados.Modulo.reserva.open;
//resetando para visualização</>
end;
Put the mistake you’re making together
– Sorack
Error in the SYNTAX of the UPDATE statement only this
– Gabriel Ribeiro
I think I’m missing put the user and password in quotes.
– Wendel Rodrigues