>Ouch! Thanks. I stand corrected, I missed the VFP part, sorry.
>
>I don't know what the equivalent of a SCOPE_IDENTITY is in VFP (or even if there is one). I suppose if this were done with a stored proc and wrapped inside a transaction, you could get the most recently generated key inside the stored proc...though how full-proof that is, I'm not sure.
>
>Thanks,
>Kevin
I believe, there would be a function in VFP9, but don't remember the name of it of hand. I do not think, there is a way in VFP to find this key. As I recall, this question was asked here few times in VFP forum but without an answer...
If it's not broken, fix it until it is.
My Blog