hi,
thanks for your help
i found the mistake:
i work with postgreSQL 7.0.2, ZPyGreSQL and zope 2.2 on suse 7.0 linux
for a identifier field adr_id:serial i want to automatically insert a
new number max(adr_id)+1
how can this be done in an insert into sql statement?
i tried
hi there,
i work with postgreSQL 7.0.2, ZPyGreSQL and zope 2.2 on suse 7.0 linux
for a identifier field adr_id:serial i want to automatically insert a
new number max(adr_id)+1
how can this be done in an insert into sql statement?
i tried nextval('adr_adr_id_seq') but get an error message
any
hi there,
i work with postgreSQL 7.0.2, ZPyGreSQL and zope 2.2 on suse 7.0 linux
for a identifier field adr_id:serial i want to automatically insert a
new number max(adr_id)+1
how can this be done in an insert into sql statement?
i tried nextval('adr_adr_id_seq') but get an error
Hi
Here's what I use:
create table customer(
custid serial primary key,
name text not null check (char_length(name)1),
address text,
code text,
country text,
telephone text,
fax text,
email text,
private_comments text
);
And the zsql method to insert a customer:
insert into