aw, i like that. i've been using firebird/ib for so long i didn't even
know that existed. thank you. lucas
On 12/26/15 5:18 PM, 'Walter R. Ojeda Valiente'
sistemas2000profesio...@gmail.com [firebird-support] wrote:
You can use EXECUTE STATEMENT for that.
Greetings.
Walter.
On Sat, Dec
You can use EXECUTE STATEMENT for that.
Greetings.
Walter.
On Sat, Dec 26, 2015 at 1:50 PM, slucas slu...@iquanta.com
[firebird-support] wrote:
>
>
> hello one and all,
>
> i would like to write a stored procedure which looks something like:
>
> CREATE PROCEDURE IC_INITIATE(d CHAR(3), CN CHAR
hello one and all,
i would like to write a stored procedure which looks something like:
CREATE PROCEDURE IC_INITIATE(d CHAR(3), CN CHAR(20))
RETURNS (IC CHAR(22))
AS
BEGIN
SELECT "CN" FROM TABLE WHERE (DIV = :d) INTO :IC;
...MAYBE OTHER STUFF to IC...
UPDATE TABLE SET "CN" = :IC WHERE (DIV = :d);