Re: help with database

use an Oracle "sequence" to provide the number for the new customer_id, e.g.:

create sequence seq_cust_id start with 1 increment by 1 nocycle nomaxvalue cache 20;

select seq_cust_id.nextval into :new.customer_id from dual;

that should get you started.

-bdbafh Received on Tue Apr 18 2006 - 14:56:39 CDT