Subject | Feeling stupid... stored proc/update/not updating |
---|---|
Author | cameron@cameroncole.net |
Post date | 2001-07-19T23:16:53Z |
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.
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.