If you are returning a single record always and only, using TIB_DSQL is
preferable.

Jason
www.ibobjects.com


-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Alexandre
Sent: Friday, June 21, 2013 9:11 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Procedure and TIB_DSQL

Thanks Jason,
In this case what is the best option to use, TIB_Cursor or TIB_DSQL ?

Alexandre


From: IBO Support List
Sent: Friday, June 21, 2013 11:25 AM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Procedure and TIB_DSQL


Result := IB_DSQL1.Fields[0].AsInteger;

Jason
www.ibobjects.com

-----Original Message-----
From: mailto:IBObjects%40yahoogroups.com
[mailto:mailto:IBObjects%40yahoogroups.com] On Behalf
Of Alexandre
Sent: Wednesday, June 19, 2013 10:35 AM
To: mailto:IBObjects%40yahoogroups.com
Subject: [IBO] Procedure and TIB_DSQL

Hi Guys,
I need to know how works TIB_DSQL.
For example if I have a SP like this:
begin
select count(projetos_id) from tb_projetos where projetos_status>=0
into :total;
suspend;
end

I did this in my code:

IB_DSQL1.SQL.Clear;
IB_DSQL1.SQL.Add('EXECUTE PROCEDURE PRO_PROJETOSCOUNT');
IB_DSQL1.Prepare;
IB_DSQL1.Execute;

But now, how to get the output parameter ?

Thanks
Alexandre

[Non-text portions of this message have been removed]

------------------------------------

__________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
__________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links




Nenhum vírus encontrado nessa mensagem.
Verificado por AVG - www.avgbrasil.com.br
Versão: 2013.0.2904 / Banco de dados de vírus: 3199/6427 - Data de
Lançamento: 06/20/13


[Non-text portions of this message have been removed]



------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links