Hi.... I'm using a IBQuery, and I would like to use a IBQuery.Edit, so, I have to use the UpdateSql, so, a link the query to updatesql, and then generate the Sql code to update on updatesql component.

So... I'm using this code to select and start the edit mode:

   with ibqCliente do
   begin
     SQL.Strings[1]:='where codigo = :codigo';
     ParamByName('codigo').asInteger:=strtoint(edtCodigo.Text);
     Open;
     Edit;
   end;


and when the user edit the informations and want to save, I'm using this code:

  ibuCliente.Query[ukModify].Prepare;
  ibuCliente.ExecSQL(ukModify);
  ibqCliente.Post;

but, it shows me an error message, "Update Failed", so, I don't know how I can solve this problem?
So... please, if possible, show me how I can solve that, an example using the update sql, with the options checked and the source code to exec the sql

Thanks, Alexandre Junior