Sequence Value Usage

In article <33609D6C.54C5@eee.nott.ac.uk>, James Bonnyman
 wrote:

> Hi
> 
> I have just completed my first database using ABF, using the
> sequenced command to generate a unique key for 'item_code' 
> collumn of my data when entering data using the data entry 
> form.
> ......
> Is there a way I can set the value of sequenced to start from? 
> (the above problem should never occur again, as all data will
> now be keyed in on a day to day basis)

Sure.  just update the sequence_value column of the appropriate row
in the table ii_sequence_values.  (I think you'll have to use a terminal
monitor, QBF will show you the ii_sequence_values data but I believe it
moans and groans if asked to update the data, claiming that it's a
system catalog.)

You can deal with it programmatically by supplying a starting value
in the SEQUENCE_VALUE call.  (rtfm the 4gl reference).  In your case,
however, it's easiest to just update the column by hand.

Karl
Ingres Q & A
To William's Home Page
Email William