Granted it would take a few years to max them out.

When zap didn't reset the nextvalue too, it got me looking in help on how to reset the nexvalue.(still haven't found it) But your suggestion on creating an empty table everytime I need it is what I really need to be doing.

Thanks
Mark


>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