[ic] Auto number-tuning

Stefan Hornburg Racke interchange-users@icdevgroup.org
Wed Jul 3 11:05:00 2002


"Rene Hertell" <interchange@hertell.com> writes:

> Hi all,
> 
> Is there any way in creating an autonumber event that would be "lastrecord
> +1" when using the Admin UI? The tabelname.autonumber file that gets created
> in the products directory gets incremented when I'm adding a new record,
> instead of getting incremented after I hit Save. This causes sometimes the
> gap between the second-last record and the last record to be unnecessary
> large...

I suggest to use MySQL tables with auto_increment keys and AUTO_SEQUENCE 1
in the IC Database settings. A similar method is probably available for
other SQL databases.

Ciao
        Racke

-- 
Prolific Interchange Consulting (Excellent German Quality !).
Take a look at Materialboerse (http://www.materialboerse.de/), WITT 
(http://www.witt-weiden.de/), Boxmover (http://shop.boxmover.ch/) or 
Passionshop (http://www.passionshop.com/racke). Need a shop ? Contact us.