Subject | Procedure and TIB_DSQL |
---|---|
Author | Alexandre |
Post date | 2013-06-19T16:34:50Z |
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]
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]