>Thank you for help
>I m new in VFP
>I have candidate index on some field.
>The user entering\updating the data by grid.
>How can I check if he tring to enter duplicate value in the field before I start to save the grid data to the table (I don't want that VFP will stop him in the middle with VFP error message).
>Thank's
>Gadi
Gadi,
Check indexseek() function. It'd return .t. if the key already exists and not the one they're entering (buffering on). Be carefull once you leave the row indexseek() would return .t. if the key is new (in buffer) or old.
Cetin