Subject Feeling stupid... stored proc/update/not updating
Author cameron@cameroncole.net
I have boiled down my stored proc problem to the just the update. If
I call any of the StoredProcs below, none of them actually perform
the update. I have tried FireBird 0.9.4 Linux and 0.9.5 Windows.

CREATE PROCEDURE SP_TEST (
SOMEID VARCHAR(30))
AS
begin
UPDATE PEOPLE SET NAME_LAST_UPPER = 'SMITHS'
WHERE NAME_LAST_UPPER = :SOMEID;
end

also

CREATE PROCEDURE SP_TEST (
SOMEID VARCHAR(30))
AS
begin
UPDATE PEOPLE SET NAME_LAST_UPPER = 'SMITHS'
WHERE NAME_LAST_UPPER = :SOMEID;
SUSPEND;
end

If I run this through QuickDesk, it says I updated 394 records. If I
change this to a "select count(*) into" with a returns I get 394 as
the output in both Quickdesk and IBConsole. I just don't get why it
isn't working. My guess it is something stupid, but IB Stored Procs
are strange anyhow. This same Stored Proc works fine in MS SQL.