With Firebird 1.03 not tested on old version.


I create these tables :
create table customer
(
idd integer not null,
name varchar(30),
primary key (idd)
)

create table zcustomer
(
idd integer not null,
name varchar(30),
primary key (idd)
)

and this stroed procedure :
create procedure COPYC
as
begin
insert into zcustomer
select * from customer;
end


I have a problem if I add a field in customer :
alter table customer
add adress varchar(200)

alter table zcustomer
add adress varchar(200)

Why adress is not copied in the procedure COPYC => insert into zcustomer
select * from customer which use a * ?


I need to recreate this procedure if I need it to work with my new field
adress :
alter procedure COPYC
as
begin
insert into zcustomer
select * from customer;
end


Why I need to do that ? and why firebird don't return me an "dependancie
error" when I try to alter customer and zcustomer table use in a procedure ?
Why a stored procedure with an "select *" isn't auto refreshed ?

--

Fabrice Vendé
fabrice@...
-
SARL I N F O C O B
Développement, formation, matériel, logiciel
http://www.infocob.com