>I made a little .exe which is busy inserting unique integer values into a free .DBF (two columns iValue and iDel). I plan to use the .DBF with the VFP OLEDB driver to use unique values in some ASP apps - when a page needs a unique value it will do an Application.Lock and SQL-Select the value and then SQL-Update the column to delete it and then Application.Unlock. This is for a low-concurrency application so the Application.Un/Lock isn't a big deal.
>
>When the .exe is done (maybe in 3 days, this is a slow desktop), it will have 100,000,000 rows in it. Has anyone used OLEDB or ODBC for query/update on a DBF of this size? I've never used anything of this size so I don't know what kind of corruption issues I might see.
>
Can you just store the last assign key and increment and update it every time you need new one?
--sb--