Entering data in the DBF

[progfox]

Sir,
I wanted to know that if there is any sort of property of dbf or so that when a data is inputed in it or with the help of a grid then it checks the data for its uniqueness and if found it duplicate then add 1,2,3... or A,B,C... like that at the end of the data.

If its a property ar there are sort of code then plase provide me with the code.


Regards

Chandan

 

[Mike Lewis]

Chandan,

You can do this by creating a candidate index on the field in question. If you get a duplicate value, VFP will raise an error, which you can trap and take action on.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com