Subject | execute stored procedure |
---|---|
Author | Daniel Bertin |
Post date | 2001-12-27T01:42:18Z |
Hi all,
I know this will sound stupid but, how should I execute a stored procedure.
using the sql of a IBOquery? seems to me I don't need a component I should
be able to do it in code?
all I want to do is clean up some records as part of a weekly procedure.
I created a stored procedure CLEAN_UP
DELETE FROM READINGS
WHERE RDATE < CURRENT_DATE - 30
so now How should I execute this CLEAN_UP procedure? I'm using Delphi 5,
IBO, and Firebird RC2.
Best wishes to all for the New Year
Daniel
I know this will sound stupid but, how should I execute a stored procedure.
using the sql of a IBOquery? seems to me I don't need a component I should
be able to do it in code?
all I want to do is clean up some records as part of a weekly procedure.
I created a stored procedure CLEAN_UP
DELETE FROM READINGS
WHERE RDATE < CURRENT_DATE - 30
so now How should I execute this CLEAN_UP procedure? I'm using Delphi 5,
IBO, and Firebird RC2.
Best wishes to all for the New Year
Daniel