Cetin,
>>Cetin,
>>I agree that all database programmers use the concept of the primary key. However, in FoxPro if there was a problem with the 'primary key' it did not shut the application down and the programmer would usually be able to sort things out. In VFP screens using a table with a primary key will not open if the key has been violated. Granted, I have not always been intelligent in handling primary keys - handling deleted records has caused me nightmares, but it would have been nice if VFP had included a primary key generator and if the code were a little more forgiving in handling primary key violations. Just mouthing off....
>
>Strongly agree VFP could and should have a auto key generator. If PK errors too irritating you could set your index to be regular but check with your own way that it's always unique :)
>Cetin
It is my understanding that in VFP8 the ability to auto-generate PKs will be added.
Best,
DD
A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.