Subject | ROWS_AFFECTED usage? |
---|---|
Author | Bob Murdoch |
Post date | 2004-11-08T20:43:25Z |
I'm trying to create the following stored procedure on FB 1.5:
create procedure debug_change_driver_daily(old_driver_id integer,
new_driver_id integer, start_date date, end_date date) returns
(rows_changed integer) as begin
rows_changed = 0;
update
driver_daily
set
driver_id = :new_driver_id
where
driver_id = :old_driver_id and
del_date between :start_date and :end_date;
rows_changed = rows_affected;
suspend;
end
When compiling the procedure I receive an error of 'unknown column
"ROWS_AFFECTED"'. My understanding is that this value is available in
PSQL?
tia,
Bob M..
create procedure debug_change_driver_daily(old_driver_id integer,
new_driver_id integer, start_date date, end_date date) returns
(rows_changed integer) as begin
rows_changed = 0;
update
driver_daily
set
driver_id = :new_driver_id
where
driver_id = :old_driver_id and
del_date between :start_date and :end_date;
rows_changed = rows_affected;
suspend;
end
When compiling the procedure I receive an error of 'unknown column
"ROWS_AFFECTED"'. My understanding is that this value is available in
PSQL?
tia,
Bob M..