Re: UPDATE problem on UNIQUEly INDEXed table on DOS
Use the following:
begin work
update fartigos /* Shift things beyond N */
set c_int_art = c_int_art + N + 1
where c_int_g = ....
.. and c_int_art >= K
insert into fartigos values (....., K) /* Place your stuff */
update fartigos /* Bring back records into domain */
set c_int_art = c_int_art - N
where c_int_g = ...
and c_int_art >= K+N
commit work
========================================================================
Bharat Shah Voice: (508)-663-7570
Unifi Communications Corp. Fax: (508)-663-7543
4 Federal St, Billerica, Mass 01821, USA uunet!bharat@unifi.com
========================================================================