You can use:
insert into a_container values( 0, 'code','detail')

If you use 0, it will insert the next value by default.
samira wrote:
create table a_Container (

ContanierNo smallint key default serial,

ContainerCode varchar(24),

ContainerDetail varchar(40))

Table was created properly.



insert into a_container values( 100, 'code','detail')  <---------------
error.



How can I write  insert statement  into the above table with 'insert
statement' ?

Thanks

samira
--
Mail addressed to my [EMAIL PROTECTED] account is never read


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to