It doesnt like to good old
insert into x (id,something) values ((select max(id)+1 from x),'something') ?
> -----Original Message-----
> From: Ishpal [mailto:[EMAIL PROTECTED]]
> Sent: den 22 augusti 2000 12:48
> To: Orion-Interest
> Cc: Orion-Interest
> Subject: Offbeat...Cloudscape
>
>
> Hello,
>
> I know this question doesnot belong here... but any help
> would be highly
> appreciated...
>
> Can we define a column to be auto increment in Cloudscape
> database...???
> Like if i want to make the id field as auto increment so that I dont
> have to generate a new id every time and it gets generated
> automatically.
>
> Thanks,
> Ishpal
>
