Re: Changing serial value

At 12:19 PM 8/19/97 EDT, you wrote: > >If you want to be able to control the value inserted, you need to >use a different data type. If you are just trying to clone a >record, exclude the "serial" column from the insert. You cannot >specify the value of a serial column. > what version are we talking of here? i seem to recall abt 4 years ago at my alma mater we were able to insert values to a serial column, by specifying a value other than zero. can't remember what the consequences were in terms of the next generated number. the versions were SE and 4GL RDS 4.10. >-d > >At 10:14 AM 8/19/97 +0200, marko kopac wrote: >>I don't know how to change a serial value in a table (Informix >>database). I need this to copy a record to the same table. First I copy >>a record to a temp table. There I try to change the serial value and >>then to insert to the original table. This is my idea. Has anybody some >>another idea hove to solve this problem? >> >>Marko >> >> Best regards, Nigel +-------------------------------------------------------------+ |Name : Edmund Nigel Gall Tel: (868) 636 3153 | |Title : Information Systems Specialist Fax: (868) 679 3770 | |Company: Process Plant Services Limited | |Address: Atlantic Avenue, Point Lisas Industrial Estate | | Point Lisas, Couva, Trinidad & Tobago, W.I. | +----- mailto:nigelg@ppsl.com ------ http://www.ppsl.com -----+