sorry I used a translator and he translated the SQL sentence

qryCliente.SQL.Add ('SELECT NAME, ID_PROSIS, ID_CLIENTE FROM ESCRITORIO');

--- In IBObjects@yahoogroups.com, "Valdemir - Yahoo" <valdemirjs@...> wrote:
>
> 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]
>