Ao usar o c�digo acima aparece a mensagem de erro: Argument out range.C�digo:[code]FDConnection1 := TConexao.GetConexao; FDConnection1.Open(); FDConnection1.ExecSQL(insert into CLIFORN (CLIFO...

F�rum mySQL e FireDAC #529200

19/08/2015

Ao usar o c�digo acima aparece a mensagem de erro: Argument out range.

C�digo:

FDConnection1 := TConexao.GetConexao;
  FDConnection1.Open();
  FDConnection1.ExecSQL('insert into CLIFORN (CLIFORN_ID, CLIFORN_NOME, CLIFORN_RAZAO) values(:Par1,:Par2,:Par3,:Par4,Par5)',
    [2,'PH','0865432'],
    [ftInteger,ftString,ftString,ftString,ftString]);

O TConexao.Get vem do:

  FDConnection := TFDConnection.Create(nil);
  FDConnection.Params.DriverID := 'MySQL';
  FDConnection.Params.Database := 'academia';
  FDConnection.Params.Add('Server=127.0.0.1');
  FDConnection.Params.UserName := 'root';
  FDConnection.Params.Password := 'minhasenha';
  FDConnection.Connected := True;
  Result := FDConnection;

Paulo Andrade

Curtir t�pico

+ 0

Responder

Posts

19/08/2015

Paulo Andrade

Ao usar o c�digo acima aparece a mensagem de erro: Argument out range.

C�digo:

FDConnection1 := TConexao.GetConexao;
  FDConnection1.Open();
  FDConnection1.ExecSQL('insert into CLIFORN (CLIFORN_ID, CLIFORN_NOME, CLIFORN_RAZAO) values(:Par1,:Par2,:Par3,:Par4,Par5)',
    [2,'PH','0865432'],
    [ftInteger,ftString,ftString,ftString,ftString]);

O TConexao.Get vem do:

  FDConnection := TFDConnection.Create(nil);
  FDConnection.Params.DriverID := 'MySQL';
  FDConnection.Params.Database := 'academia';
  FDConnection.Params.Add('Server=127.0.0.1');
  FDConnection.Params.UserName := 'root';
  FDConnection.Params.Password := 'minhasenha';
  FDConnection.Connected := True;
  Result := FDConnection;

Descobri e corrigi essa Linha:

FDConnection1.ExecSQL('insert into CLIFORN (CLIFORN_ID, CLIFORN_NOME, CLIFORN_RAZAO) values(:Par1,:Par2,:Par3)',
    [2,'PH','0865432'],
    [ftInteger,ftString,ftString]);

S� que agora aparece a seguinte mensagem: Oject factory for class {324-23422-234214} is missing. to register it, you can drop component [TFDGUIxWaitCursos] into your project.

Responder

Gostei + 0