cameron@... wrote:

>
> 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
>
> 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.
>

Did you do a commit after executing?


Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further