>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.