>>Fellow Mere Mortals
>>
>>Does anyone out there already have a utility that will cycle thru Id.dbf and for each entry, open the table, order it by it's Primary Key, go to the bottom, get that value, increment it by 1 and then update id.dbf?
>>
>>I hate reventing the wheel. Does anyone know if the Stonefield SDT does this?
>>
>>Thanks In Advance,
>
>Gil,
>
>Why would you want to do that? The newid stored procedure does pretty much the same thing, and the id table always stores the next ID to be used. Also, as Kevin pointed out, the id table doesn't alway have to store the primary key value for a table.

James,

I have applications at client's and occasionally I have to correct a problem created by a bug in my software or from them trying to fix things themselves by doing selective restores or any of other possible scenerios where the Id table gets out of sync with the table id's. Have a 'reset' for the ID table would solve the problem and keep the error message 'a record with this information exists...' away.