DD,
>
>>
>>Yep! I should clarify my statement a bit, however. It assumed a regular append
without key generation when compared to one using an auto-increment column. Naturally, when compared with with a PK generation routine to do the append, it should be much faster. So there is a performance gain as well.
>
>Oh.. You mean gen the key at the same time as an insert? I suppose there could be an increase but I don't see what's different except that perhaps the VFP engine is gen'ing the key, which could speed things a bit. But that most likely would restrict us to Integer keys, which is fine by me.
As I said to Walter, they're surrogate keys, so it really doesn't matter what they are.
George
Ubi caritas et amor, deus ibi est