>Hi everybody,
>
>I have a table with primary PK KeyID. This KeyID is auto-generated using default value in the field. Now, user opens table in command window and do append blank. GetNextID fails and returns 0. So, we ended with couple of records with 0 as PK.
>
>How can we stop APPEND BLANK if GetNextID fails?
>
>Thanks in advance.
Why would GetNextID fail?
Perhaps VFP can't find this function.
I place the function which I believe is the equivalent into stored procedures. This works even if user issues APPEND BLANK from the command window, or adds a new record from the BROWSE window.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)