>I am still new to VFP programming.
>It appears that to add a record to a database via a form, you APPEND BLANK and then have the user enter the new data.
>I did not see any controls that would generate an error message if you tried to enter a duplicate key as happens with BTrieve and other databases.
>Under FoxPro 2.6 you can either go to EOF and SCATTER MEMVAR and not add the record if it is already present.
>Under VPF though, if the blank record is already created it would appear that you would have to do the following in the Validate control for the key field:
>
>
>ThisForm.Validate
> m_suta_state = This.Value
> m_alreadythere = .f.
> m_recno = recno()
> GO TOP
> IF seek( m_suta_state )
> IF m_recno <> recno()
> m_alreadythere = .t.
> ENDIF
> ENDIF
> IF m_alreadythere
> m_thisrecord = recno()
> GOTO ( m_recno )
> DELETE
> GOTO ( m_thisrecord )
> StateUnemployment.Refresh
> ENDIF
>
>But this seems SO KLUDGY. Surely my understanding is incomplete.
>
>Thanks
>Bruce Strom


You could use a primary or a candidate index.