Hello Mark,

Seeing that an integer field can go up to over 2 billion, you can estimate how long it will take you to get there. I don't see how zapping a table on a regular basis will help you get there any faster :)

If it is a concern, and if this field doesn't need to be really unique, don't use zap. Create an empty table with the next autoInc ID set to what you want. Copy this empty table over the top of the temp table that you wish to zap when you want to clear out the information.


>When I issus a zap on a table that has an autoinc field I was expecting the nextvalue to reset as well but it doesn't.
>
>Should I be concerned that in temp tables that are zapped alot, that it might eventually max out?
>
>If so then how do I reset it?
>
>Cheers
>Mark