- define a integer field - define a index on field TAG host - set the active order to the "host" index tag * insert - set field = field + 1 for all records with field >= N and set the insert record's field value to N ( this put the key in physical tag's position N) * with code TRY * BEGIN TRAN or tablebuffer with FLOCK() SET ORDER host DESCENDING REPLACE ALL WHILE field>=N field with field + 1 INSERT ... FIELD ... VALUES ... N .... * END TRAN or tableupdate() and unlock CATCH * ROLLBACK FINALLY SET ORDER host ENDTRY