Subject | IBO and Delphi 2010 to XE |
---|---|
Author | Valdemir - Yahoo |
Post date | 2011-07-26T20:10:03Z |
good afternoon
I have a project in Delphi 2010 and Firebird 2.1 and I'm migrating to Delphi XE, at first I installed ibobjects IBO4_9_14_Installer version and installed it on delphi
Just pick up an application that was working to compile and run it started to have some mistakes, at first I think I found one but not the other
1) error in a cursor parameter not found
The SQL cursor
EXECUTE BLOCK (PAR_EVENTO VARCHAR (64) =: PAR_EVENTO)
AS
BEGIN
POST_EVENT: PAR_EVENTO;
END
in delphi
curEventos.Close;
curEventos.ParamByName ('PAR_EVENTO'). AsString: = NomeEventoAbrindo;
curEventos.ExecSQL;
to solve the problem the method used to prepare the cursor before executing
curEventos.Close;
curEventos.Prepare;
curEventos.ParamByName ('PAR_EVENTO'). AsString: = NomeEventoAbrindo;
curEventos.ExecSQL;
this is the same in all cursors have to use the Prepare method from Delphi XE??
2) Error in KeyLinks created a query at runtime
qryCliente: TIBOQuery.Create = (Application);
qryCliente.IB_Connection: = DMPrincipal.ib_Conexao;
qryCliente.Close;
qryCliente.SQL.Clear;
qryCliente.SQL.Add ('SELECT NAME, ID_PROSIS, ID_CLIENTE FROM OFFICE');
qryCliente.Open;
is giving error "Invalid entry KeyLinks: ESCRITORIO.ID" open the lines of the query
Delphi in 2010 did not have to put the PK in the office table query from what I've read you need to put?
[Non-text portions of this message have been removed]
I have a project in Delphi 2010 and Firebird 2.1 and I'm migrating to Delphi XE, at first I installed ibobjects IBO4_9_14_Installer version and installed it on delphi
Just pick up an application that was working to compile and run it started to have some mistakes, at first I think I found one but not the other
1) error in a cursor parameter not found
The SQL cursor
EXECUTE BLOCK (PAR_EVENTO VARCHAR (64) =: PAR_EVENTO)
AS
BEGIN
POST_EVENT: PAR_EVENTO;
END
in delphi
curEventos.Close;
curEventos.ParamByName ('PAR_EVENTO'). AsString: = NomeEventoAbrindo;
curEventos.ExecSQL;
to solve the problem the method used to prepare the cursor before executing
curEventos.Close;
curEventos.Prepare;
curEventos.ParamByName ('PAR_EVENTO'). AsString: = NomeEventoAbrindo;
curEventos.ExecSQL;
this is the same in all cursors have to use the Prepare method from Delphi XE??
2) Error in KeyLinks created a query at runtime
qryCliente: TIBOQuery.Create = (Application);
qryCliente.IB_Connection: = DMPrincipal.ib_Conexao;
qryCliente.Close;
qryCliente.SQL.Clear;
qryCliente.SQL.Add ('SELECT NAME, ID_PROSIS, ID_CLIENTE FROM OFFICE');
qryCliente.Open;
is giving error "Invalid entry KeyLinks: ESCRITORIO.ID" open the lines of the query
Delphi in 2010 did not have to put the PK in the office table query from what I've read you need to put?
[Non-text portions of this message have been removed]